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:
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,
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@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@lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers