[Serusers] RE: Ser Crashes
Elton Machado
elton.machado at gmail.com
Thu May 5 12:00:18 CEST 2005
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 at 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 at 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 at 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 at lists.iptel.org [
> mailto:serusers-bounces at lists.iptel.org
> <mailto:serusers-bounces at 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 at 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 at 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 at 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 at lists.iptel.org
> http://lists.iptel.org/mailman/listinfo/serusers
>
> > _______________________________________________
> Serusers mailing list
> serusers at 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 at 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 at 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 at 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 at lists.iptel.org [
> mailto:serusers-bounces at lists.iptel.org
> <mailto:serusers-bounces at 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 at 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 at 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 at 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 at lists.iptel.org
> http://lists.iptel.org/mailman/listinfo/serusers
>
> > _______________________________________________
> Serusers mailing list
> serusers at 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/
More information about the sr-users
mailing list