[Serusers] Help! Run SER with MySQL to do authentication

[Greger V. Teigre]

http://www.iptel.org/mysql_newbie
This is your error:
0(0) new_connection(): Can't connect to local MySQL server through 
socket '/tmp/mysql.sock'  (2)

Check your /etc/my.cnf for where the socket is and change it to 
/tmp/mysql.sock
g-)

Tako Chang wrote:
> Thank you very much!! Greger
> I have create a database for ser by ser_mysql.sh create
> and use serctl to add two accounts
> I thought that i'll very close to setup successfully
> there is a strange problem remaining.......
> when i run ser by
> #ser -f auth-mysql.cfg
> 0(4222) WARRING: fix_socket_list: could not rev. resolve 192.168.1.7 
> <http://192.168.1.7>
>                192.168.1.7 <http://192.168.1.7> [ 192.168.1.7 
> <http://192.168.1.7>]:5060
> 0(4222) WARRING: fix_socket_list: could not rev. resolve 192.168.1.7 
> <http://192.168.1.7>
>                192.168.1.7 <http://192.168.1.7> [192.168.1.7 
> <http://192.168.1.7>]:5060
> Listening on
>              udp: 192.168.1.7 <http://192.168.1.7> [192.168.1.7 
> <http://192.168.1.7>]:5060
>              tcp: 192.168.1.7 <http://192.168.1.7> [192.168.1.7 
> <http://192.168.1.7>]:5060
> Aliases:
>
> WARING: no fork mode
> stateless - initializing
> 0(0) Maxfwd module- initializing
> 0(0) new_connection(): Can't connect to local MySQL server through 
> socket '/tmp/mysql.sock'  (2)
> 0(0) db_init(): Could not create a connection
> 0(0) ERROR: uridb_db_ver: unable to open database connection
> 0(0) ERROR: uri_db:mod_init(): Error while quering table version
> 0(0) init_mod(): Error while initializing module uri_db
> ERROR: error while initializing modules
>
> It seems that SER can't connect to mysql
> but i can use the command to ser database
> #mysql -u ser -pheslo
> mysql>connect ser
> Connectiong id:      27
> Current database:   ser
>
> What should I do for this situation?
> Thanks again^^
>
> 2006/12/12, Greger V. Teigre <greger at teigre.com 
> <mailto:greger at teigre.com>>:
>
>     Copy the list.
>     Well, "libmysqlclient.so.14: cannot open shared object file: No
>     such file or directory" pretty much says it all, right?
>     Your LD_LIBRARY_PATH environment variable must include your
>     library dirs before starting ser (cumbersome) or you need to add
>     /usr/lib/mysql to your /etc/ld.so.conf file (which btw should have
>     been updated when installing mysql, I don't know why it didn't
>     happen for you).
>     g-)
>
>
>     Tako Chang wrote:
>>     Thanks!!
>>     I ran make_and_install script
>>     But i still can't run 'auth-mysql.cfg'
>>     Error message :
>>     load_module: could not open module
>>     </usr/local/lib/ser/modules/mysql.so>: libmysqlclient.so.14:
>>     cannot open shared object file: No such file or directory
>>
>>     but I have libmysqlclient.so.14 at "/usr/local/lib/mysql"
>>     What should I do?? 
>>
>>     Thanks for your help <(_ _)>
>>
>>     I mentioned that someone talked about the version of mysql
>>     So, i download the older version 4.1.22
>>     2006/12/6, Greger V. Teigre < greger at teigre.com
>>     <mailto:greger at teigre.com>>:
>>
>>         Look at the make_and_install script in the scripts package
>>         (same place). It does this for you. mysql-devel must be
>>         installed.
>>         g-)
>>
>>         Tako Chang wrote:
>>>         Hi, all
>>>
>>>         First of all, I read [SER - Getting Started
>>>         <http://siprouter.onsip.org/doc/gettingstarted/>] and
>>>         downloaded [ SER Source package
>>>         <ftp://siprouter.onsip.org/pub/gettingstarted/packages/ser-0.9.7-pre1.GettingStarted.1.6.tar.gz>]
>>>
>>>         after I make the package under debug mode,  it runs well.
>>>         Now, I can receive REGISTER requests and send 200 OK
>>>         Responses and play a SIP proxy server
>>>
>>>         I  want to  test  "auth_mysql.cfg"  in Chapter 7.... so,
>>>         i remove "exclude_modules?= jabber mysql\" in Makefile
>>>         but i still can't compile the mysql.so
>>>
>>>         Is there some more detail documents or suggestions for me?
>>>
>>>         Thank!
>>>         ------------------------------------------------------------------------
>>>
>>>         _______________________________________________
>>>         Serusers mailing list
>>>         Serusers at lists.iptel.org <mailto: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/20061220/943d0f3d/attachment.htm>