[Serusers] accouting giving mysql access denied error:follow-up
Iqbal
iqbal at gigo.co.uk
Fri Oct 8 04:30:30 CEST 2004
Hi
Just done a trace, now without acc.so loaded, i get the following in
mysqld.log
84 Connect ser at a.b.c.d on ser
85 Connect ser at a.b.c.d on ser
86 Connect ser at a.b.c.d on ser
87 Connect ser at a.b.c.d on ser
BUT with acc.so loading we get
Access denied for user: ser at a.b.c.d' (Using password: YES)
22 Connect ser at a.b.c.d on ser
041008 3:29:23 23 Connect ser at a.b.c.d on ser
24 Connect Access denied for user: ser at a.b.c.d
Now this just dont add up :-)
Iqbal
On 10/8/2004, "Iqbal" <iqbal at gigo.co.uk> wrote:
>
>Hi
>
>I have managed to get ser up and running, with a remote Mysql db, it
>authenticates users fine when I make a call using a UA like X-lite.
>
>I have also managed to play around with ser.cfg, and it seems to parse
>the file correctly judging by the error messages etc I get on the UA.
>
>What I now wanted to do was to use the accounting module acc.so
>
>So I recmpiled and removed the SQL syntax, initially it had been compiled
>with radius, however i dropped that option, seeing that serweb works
>well, and didnt really need radius (unless someone has other thoughts on
>this). I also recompiled all of ser again just to make sure :-)
>
>Well the moment I enter the loadmodule line for acc.so I get the
>following error on start up
>[snip]
> 3(15437) DEBUG: callid: '1ff7efd1-15437 at 127.0.0.1'
> 3(15437) DEBUG: init_mod_child (3): usrloc
> 1(15435) DEBUG: init_mod_child (1): acc
> 1(15435) connect_db(): Can't connect to local MySQL server through
>socket '/var/lib/mysql/mysql.sock' (2)
> 1(15435) db_init(): Error while trying to connect database
> 1(15435) acc:init_child(): Unable to connect database
> 1(15435) init_mod_child(): Error while initializing module acc
>[snip]
>
>
>Now without this module loaded, i get NO connection errors and all is
>fine, so it cant be a permission problem, I then add the
>
>modparam("acc", "db_url", "mysql://ser:XXXX:@aaa.bbb.ccc.ddd/ser")
>
>line
>[snip]
>7(0) DEBUG: init_mod_child (7): tm
> 7(0) DEBUG: callid: '6ffebf9b-0 at 127.0.0.1'
> 7(0) DEBUG: init_mod_child (7): usrloc
> 1(15444) connect_db(): Access denied for user: 'ser at aaa.bbb.ccc.xxx'
>(Using password: YES)
> 1(15444) 2(15445) connect_db(): Access denied for user:
>'ser at aaa.bbb.ccc.xxx' (Using password: YES)
> 2(15445) db_init(): Error while trying to connect database
> 2(15445) acc:init_child(): Unable to connect database
> 2(15445) init_mod_child(): Error while initializing module acc
>[snip]
>
>now I am already using this exact line prior to this module for auth_db
>and userloc, these show no errors, so again it cant be a permission
>problem, but just to be sure I checked from the command line, and all is
>fine.
>
>Any ideas on this one, I am gonna try a sql trace just to see what it is
>sending, but cant see why it would be any different.
>
>Tks
>iqbal
>
>_______________________________________________
>Serusers mailing list
>serusers at lists.iptel.org
>http://lists.iptel.org/mailman/listinfo/serusers
>
>
More information about the sr-users
mailing list