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@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@127.0.0.1' 7(0) DEBUG: init_mod_child (7): usrloc 1(15444) connect_db(): Access denied for user: 'ser@aaa.bbb.ccc.xxx' (Using password: YES) 1(15444) 2(15445) connect_db(): Access denied for user: 'ser@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
Hi
Just done a trace, now without acc.so loaded, i get the following in mysqld.log
84 Connect ser@a.b.c.d on ser 85 Connect ser@a.b.c.d on ser 86 Connect ser@a.b.c.d on ser
87 Connect ser@a.b.c.d on ser
BUT with acc.so loading we get
Access denied for user: ser@a.b.c.d' (Using password: YES) 22 Connect ser@a.b.c.d on ser 041008 3:29:23 23 Connect ser@a.b.c.d on ser 24 Connect Access denied for user: ser@a.b.c.d
Now this just dont add up :-)
Iqbal
On 10/8/2004, "Iqbal" iqbal@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@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@127.0.0.1' 7(0) DEBUG: init_mod_child (7): usrloc 1(15444) connect_db(): Access denied for user: 'ser@aaa.bbb.ccc.xxx' (Using password: YES) 1(15444) 2(15445) connect_db(): Access denied for user: 'ser@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@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers
I am interested to take a look at the source code for the functions rewriteuser and rewritehost Can someone tell me which module these functions reside in. I have done a text search for rewriteuser and rewritehost and get no hits.
Thanks, Dinesh
Hi Dinesh,
these functions are implemented in SER's core as script actions. Please look in file action.c, function do_action().
Best regards, Marian Dumitru
Dinesh Mahbubani wrote:
I am interested to take a look at the source code for the functions rewriteuser and rewritehost Can someone tell me which module these functions reside in. I have done a text search for rewriteuser and rewritehost and get no hits.
Thanks, Dinesh
Serusers mailing list serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers
-
Dinesh Mahbubani -
Iqbal -
Marian Dumitru