[Serusers] RE: Ser Crashes

[Edgardo O. Gonzales II]

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 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 ...
>
><mailto:root at ignosya:/usr/local/etc/ser>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
><mailto:root at ignosya:/usr/local/etc/ser>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
>
><mailto:root at ignosya:/usr/local/etc/ser>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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20050429/2d8f1352/attachment.htm>