Re: Re: [Serusers] Creating particular mysql schema with the given db user name - bad db connection url
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")
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@iRC RusNet * mailto:shurik@start4.info AD1-UANIC * ICQ: 122351182 * http://www.start4.info
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 "
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@iRC RusNet * mailto:shurik@start4.info AD1-UANIC * ICQ: 122351182 * http://www.start4.info
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@tomix:~/ser/ser-0.9.7$ pwd /home/ser/ser/ser-0.9.7 ser@tomix:~/ser/ser-0.9.7$ cat ser.cfg | grep mysql # $Id: bfwd+auth+mysql.cfg 2006-11-27 /Tomek Zieleniewski/emailAddress=tezet@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@iRC RusNet * mailto:shurik@start4.info AD1-UANIC * ICQ: 122351182 * http://www.start4.info
-- Alexandr Dubovikov * baron@iRC RusNet * mailto:shurik@start4.info AD1-UANIC * ICQ: 122351182 * http://www.start4.info
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@tomix:~/ser/ser-0.9.7$ pwd /home/ser/ser/ser-0.9.7 ser@tomix:~/ser/ser-0.9.7$ cat ser.cfg | grep mysql # $Id: bfwd+auth+mysql.cfg 2006-11-27 /Tomek Zieleniewski/emailAddress=tezet@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,
-
"tzieleniewski" -
Alexandr Dubovikov