[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