[Serusers] Creating particular mysql schema with the given db user name - bad db connection url

[Alexandr Dubovikov]

On Thu, Dec 28, 2006 at 04:31:23PM +0100, tzieleniewski wrote:
> 
> 
> > On Thu, Dec 28, 2006 at 03:10:12PM +0100, tzieleniewski wrote:
> > > worked but another problem apeared:)
> > > the script has created the ser database user and the database ser_0_9_7 for this user
> > > Ive changed the database connection urls to the following:
> > > fifo_db_url="mysql://ser:heslo@localhost/ser0_9_7"
> > > modparam("auth_db|uri_db|usrloc|domain", "db_url", "mysql://ser:heslo@localhost/ser0_9_7")
> > 
> > 
> > or you still have in config connect to "ser" database, or you use old
> > config.
> > try to start with  "-c /path/to/newser.cfg "
> > 
> 
> U mean "-f ..ser.cfg", so I did:
> I started ser with the following command:
>  /home/ser/ser/ser-0.9.7/ser -f /home/ser/ser/ser-0.9.7/ser.cfg -P /home/ser/ser/ser-0.9.7/ser.pid -w /home/ser/ser/ser-0.9.7  2>/home/ser/traces/ser.trace.20061228 1>/home/ser/traces/ser.trace.20061228
> 
> where contents of ser.cfg are the following:
> ser at tomix:~/ser/ser-0.9.7$ pwd
> /home/ser/ser/ser-0.9.7
> ser at tomix:~/ser/ser-0.9.7$ cat ser.cfg | grep mysql
> # $Id: bfwd+auth+mysql.cfg 2006-11-27 /Tomek Zieleniewski/emailAddress=tezet at touk.pl
> fifo_db_url="mysql://ser:heslo@localhost/ser0_9_7"
> loadmodule "/home/ser/src/ser-0.9.7-pre1/modules/mysql/mysql.so"
> modparam("auth_db|uri_db|usrloc|domain", "db_url", "mysql://ser:heslo@localhost/ser0_9_7")
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
> modparam("avpops", "avp_url", "mysql://ser:heslo@localhost/ser0_9_7")

> > >  1(0) ERROR: acc_db_init: unable to connect to the database

		^^^^^^^^^^^^^^

and what about accounting module ?

modparam("acc", "db_url", "mysql://user:password@localhost/ser")



Wbr,
-- 
Alexandr Dubovikov * baron at iRC RusNet * mailto:shurik at start4.info
    AD1-UANIC      *  ICQ: 122351182  *  http://www.start4.info