Re: Re: [Serusers] Creating particular mysql schema with the given db user name - bad db connection url
28 Dec
2006
28 Dec
'06
7:10 p.m.
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 
28 Dec
28 Dec
8:20 p.m.
New subject: [Serusers] Creating particular mysql schema with the given db user name - bad db connection url
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
--
Alexandr Dubovikov * baron@iRC RusNet * mailto:shurik@start4.info
AD1-UANIC * ICQ: 122351182 * http://www.start4.info
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
8:31 p.m.
New subject: [Serusers] Creating particular mysql schema with the given db user name - bad db connection url
On Thu, Dec 28, 2006 at 03:10:12PM +0100,
tzieleniewski wrote:
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(a)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")
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
--
Alexandr Dubovikov * baron@iRC RusNet * mailto:shurik@start4.info
AD1-UANIC * ICQ: 122351182 * http://www.start4.info 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
29 Dec
29 Dec
1:24 a.m.
New subject: [Serusers] Creating particular mysql schema with the given db user name - bad db connection url
On Thu, Dec 28, 2006 at 04:31:23PM +0100, tzieleniewski wrote:
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
On Thu, Dec 28, 2006 at 03:10:12PM +0100,
tzieleniewski wrote:
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(a)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")
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 "
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@iRC RusNet * mailto:shurik@start4.info
AD1-UANIC * ICQ: 122351182 * http://www.start4.info
6339
days inactive
6339
days old
3 comments
2 participants
participants (2)
-
"tzieleniewski" -
Alexandr Dubovikov