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

tzieleniewski tzieleniewski at o2.pl
Thu Dec 28 16:31:23 CET 2006



> 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")

> 
> > 
> > But despite that ser try too connect to the "ser" database:
> > stateless - initializing
> >  0(0) Maxfwd module- initializing
> > textops - initializing
> >  0(0) AVPops - initializing
> > acc - initializing
> >  0(0) INFO: udp_init: SO_RCVBUF is initially 109568
> >  0(0) INFO: udp_init: SO_RCVBUF is finally 262142
> >  1(0) INFO: fifo process starting: 3499
> >  1(0) new_connection(): Access denied for user 'ser'@'localhost' to database 'ser'
> >  1(0) db_init(): Could not create a connection
> >  1(0) ERROR: acc_db_init: unable to connect to the database
> >  1(0) init_mod_child(): Error while initializing module acc
> >  1(0) ERROR: open_uac_fifo: init_child failed
> >  1(0) starting fifo server failed
> >  1(0) INFO: signal 15 received
> > 
> > > On Thu, Dec 28, 2006 at 02:14:18PM +0100, TZieleniewski wrote:
> > > 
> > > > Ok but I generalny dont want to install ser I just want to compile it
> > > > and then have two different instances of ser on the same machine
> > > > (different releases)<br>
> > > > gen_ha1.c and gen_ha1.d are in utils/gen_ha1 directory , there is a
> > > > makefile included will it work if I will invoke make in that directory?<br>
> > > 
> > > yep, it will works. Just compile and change the path to gen_ha1 in
> > > ser_mysql.sh.
> > > 
> > > 
> > > > <br>
> > > > Tomasz<br>
> > > > </body>
> > > > </html>
> > > 
> > > -- 
> > > Alexandr Dubovikov * baron at iRC RusNet * mailto:shurik at start4.info
> > >     AD1-UANIC      *  ICQ: 122351182  *  http://www.start4.info
> > 
> 
> -- 
> Alexandr Dubovikov * baron at iRC RusNet * mailto:shurik at start4.info
>     AD1-UANIC      *  ICQ: 122351182  *  http://www.start4.info




More information about the sr-users mailing list