There is a missing line in your ser.cfg file at least the db_url parameter
... or are you using the default permissions?
Is not a bad idea to have the line anyway, here it goes...
modparam("auth_db|usrloc", "db_url",
"mysql://ser:heslo@localhost/ser")
Regards,
-----Original Message-----
From: harry gaillac [mailto:gaillacharry@yahoo.fr]
Sent: quinta-feira, 5 de Maio de 2005 10:38
To: Elton Machado
Subject: RE: [Serusers] RE: Ser Crashes
Look at my ser.cfg
do you add users in db with serctl ?
Harry
--- Elton Machado <elton.machado(a)gmail.com> a écrit :
And did you confirm if your mysql accept local
connection with user
name and password you are using?
What do you mean by your authentication is working?
Can you provide us a
snip of your code?
Regards,
_____
From: Edgardo O. Gonzales II
[mailto:edgardo.g@pacific.net.ph]
Sent: sexta-feira, 29 de Abril de 2005 5:36
To: Elton Machado; 'IpTel List'; 'Iptel Mailing list'
Subject: RE: [Serusers] RE: Ser Crashes
I already did.. Im sure my username and password is correct because my
authentication is working..
any other suggestion ..
At 06:17 AM 4/29/2005, Elton Machado wrote:
Did you checked out well your configuration?
You have to have something like...
loadmodule "/usr/local/lib/ser/modules/mysql.so"
loadmodule "/usr/local/lib/ser/modules/usrloc.so"
loadmodule "/usr/local/lib/ser/modules/auth.so"
loadmodule "/usr/local/lib/ser/modules/auth_db.so"
#......
modparam("auth_db|usrloc", "db_url",
"mysql://ser:heslo@localhost/ser")
modparam("auth_db", "calculate_ha1", 1) modparam("auth_db",
"password_column", "password") modparam("usrloc",
"db_mode", 2)
to ser load things up from database, check if you have the right
username and password, and if your mysql database is running.
Regards,
_____
From: serusers-bounces(a)lists.iptel.org [
mailto:serusers-bounces@lists.iptel.org
<mailto:serusers-bounces@lists.iptel.org> ] On Behalf Of IpTel List
Sent: quinta-feira, 21 de Abril de 2005 8:19
To: Iptel Mailing list
Subject: [Serusers] RE: Ser Crashes
Hi!
Thanx for help. It writes that he can't connect to MYSQL DB now ...
Output is the following ...
root@ignosya:/usr/local/etc/ser# ser -E -d Listening on
127.0.0.1 [127.0.0.1]:5060
84.230.194.213 [84.230.194.213]:5060
192.168.1.1 [192.168.1.1]:5060
Aliases: 1.1.168.192.in-addr.arpa:5060
a84-230-194-213.elisa-laajakaista.fi:5060
localhost:5060
root@ignosya:/usr/local/etc/ser# stateless - initializing Maxfwd
module- initializing
0(15143) connect_db(): Can't connect to local MySQL server through
socket '/var/run/mysql/mysql.sock' (2)
0(15143) db_init(): Error while trying to connect database
0(15143) mod_init(): Error while connecting database
0(15143) init_mod(): Error while initializing module usrloc
ERROR: error while initializing modules
root@ignosya:/usr/local/etc/ser#
So, it seams for me, that it's like MYSQL problem.
So, i have to reconfigure
it ... or check it up ...
But, are there any methods selecting mysql host adres? For example, if
mysql is not on local machine ... is it enough to set SQL_HOST var?
Best wishes,
Alexandro.
_______________________________________________
Serusers mailing list
serusers(a)lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers
_______________________________________________
Serusers mailing list
serusers(a)lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers
__________________________________________________________________
Découvrez le nouveau Yahoo! Mail : 250 Mo d'espace de stockage pour vos
mails !
Créez votre Yahoo! Mail sur
http://fr.mail.yahoo.com/
-----Original Message-----
From: harry gaillac [mailto:gaillacharry@yahoo.fr]
Sent: quinta-feira, 5 de Maio de 2005 10:38
To: Elton Machado
Subject: RE: [Serusers] RE: Ser Crashes
Look at my ser.cfg
do you add users in db with serctl ?
Harry
--- Elton Machado <elton.machado(a)gmail.com> a écrit :
And did you confirm if your mysql accept local
connection with user name and
password you are using?
What do you mean by your authentication is working?
Can you provide us a
snip of your code?
Regards,
_____
From: Edgardo O. Gonzales II
[mailto:edgardo.g@pacific.net.ph]
Sent: sexta-feira, 29 de Abril de 2005 5:36
To: Elton Machado; 'IpTel List'; 'Iptel Mailing
list'
Subject: RE: [Serusers] RE: Ser Crashes
I already did.. Im sure my username and password is
correct because my
authentication is working..
any other suggestion ..
At 06:17 AM 4/29/2005, Elton Machado wrote:
Did you checked out well your configuration?
You have to have something like...
loadmodule "/usr/local/lib/ser/modules/mysql.so"
loadmodule "/usr/local/lib/ser/modules/usrloc.so"
loadmodule "/usr/local/lib/ser/modules/auth.so"
loadmodule "/usr/local/lib/ser/modules/auth_db.so"
#......
modparam("auth_db|usrloc", "db_url",
"mysql://ser:heslo@localhost/ser")
modparam("auth_db", "calculate_ha1", 1)
modparam("auth_db", "password_column", "password")
modparam("usrloc", "db_mode", 2)
to ser load things up from database, check if you
have the right username
and password, and if your mysql database is running.
Regards,
_____
From: serusers-bounces(a)lists.iptel.org [
mailto:serusers-bounces@lists.iptel.org
<mailto:serusers-bounces@lists.iptel.org> ] On Behalf Of
IpTel List
Sent: quinta-feira, 21 de Abril de 2005 8:19
To: Iptel Mailing list
Subject: [Serusers] RE: Ser Crashes
Hi!
Thanx for help. It writes that he can't connect to
MYSQL DB now ... Output
is the following ...
root@ignosya:/usr/local/etc/ser# ser -E -d
Listening on
127.0.0.1 [127.0.0.1]:5060
84.230.194.213 [84.230.194.213]:5060
192.168.1.1 [192.168.1.1]:5060
Aliases: 1.1.168.192.in-addr.arpa:5060
a84-230-194-213.elisa-laajakaista.fi:5060
localhost:5060
root@ignosya:/usr/local/etc/ser# stateless -
initializing
Maxfwd module- initializing
0(15143) connect_db(): Can't connect to local MySQL
server through socket
'/var/run/mysql/mysql.sock' (2)
0(15143) db_init(): Error while trying to connect
database
0(15143) mod_init(): Error while connecting
database
0(15143) init_mod(): Error while initializing
module usrloc
ERROR: error while initializing modules
root@ignosya:/usr/local/etc/ser#
So, it seams for me, that it's like MYSQL problem.
So, i have to reconfigure
it ... or check it up ...
But, are there any methods selecting mysql host
adres? For example, if mysql
is not on local machine ... is it enough to set
SQL_HOST var?
Best wishes,
Alexandro.
_______________________________________________
Serusers mailing list
serusers(a)lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers
_______________________________________________
Serusers mailing list
serusers(a)lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers
__________________________________________________________________
Découvrez le nouveau Yahoo! Mail : 250 Mo d'espace de stockage pour vos
mails !
Créez votre Yahoo! Mail sur
http://fr.mail.yahoo.com/