[Serusers] postgres and mysql

Sebastian Kühner skuehner at veraza.com
Mon Jul 11 15:38:44 CEST 2005


Hello,

Thanks for your help. The problem was that I didn't specify the uri_db...

Sebastian


----- Original Message ----- 
From: "Jan Janak" <jan at iptel.org>
To: "Sebastian Kühner" <skuehner at veraza.com>
Cc: <serusers at lists.iptel.org>
Sent: Friday, July 08, 2005 6:03 PM
Subject: Re: [Serusers] postgres and mysql


acc module is not the only module that uses database. auth_db, usrloc,
and uri_db, among others, need database too.

In this particular example you forgot to configure uri_db module to use
postgres, so it is using mysql by default. Change the modparam to:

modparam("acc|uri_db", "db_url",
"postgres://admin:password@localhost:5432/AAA")

   Jan.

On 08-07-2005 16:53, Sebastian Kühner wrote:
> Hello,
>
> I'm using postgres for authentication and accounting since a few days and
> it's working perfect. But I'm wondering why I have to load the mysql.so -
> Module, too. If not (commented), I get the following error:
>
>  0(0) Maxfwd module- initializing
>  0(0) PG[238] db_init entry
>  0(0) PG[193] str2valp got int 2
>  0(0) PG[274] db_close entry textops - initializing
>  0(0) bind_dbmod: Module mysql does not export db_use_table function
>  0(0) ERROR: uridb_db_bind: unable to bind to the database module
>  0(0) ERROR: uri_db:mod_init(): No database module found
>  0(0) init_mod(): Error while initializing module uri_db
> ERROR: error while initializing modules
>
> This error also appears, if I don't have installed/running a mysql server.
> It seems very strange... because all the data is saved correctly in my
> postgresql-database. Why do I need the mysql-module then?
>
> OK, one additional information. To specify my database I use the following
> command:
>
>     modparam("acc", "db_url",
> "postgres://admin:password@localhost:5432/AAA")
>
> If I use "sql://" instead of "postgres://" there appears the same error
like
> above.
>
> Any ideas?
>
> Thanks!
>
> Sebastian
>
>
> _______________________________________________
> Serusers mailing list
> serusers at lists.iptel.org
> http://lists.iptel.org/mailman/listinfo/serusers






More information about the sr-users mailing list