<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<a class="moz-txt-link-freetext" href="http://www.iptel.org/mysql_newbie">http://www.iptel.org/mysql_newbie</a><br>
This is your error:<br>
0(0) new_connection(): Can't connect to local MySQL server through
socket '/tmp/mysql.sock' (2)<br>
<br>
Check your /etc/my.cnf for where the socket is and change it to
/tmp/mysql.sock <br>
g-)<br>
<br>
Tako Chang wrote:
<blockquote
cite="mid48c4eeb40612192349h2243158dj9266ebef5c7575a4@mail.gmail.com"
type="cite">Thank you very much!! Greger<br>
I have create a database for ser by ser_mysql.sh create<br>
and use serctl to add two accounts<br>
I thought that i'll very close to setup successfully<br>
there is a strange problem remaining.......
<br>
when i run ser by<br>
#ser -f auth-mysql.cfg<br>
0(4222) WARRING: fix_socket_list: could not rev. resolve <a
href="http://192.168.1.7">192.168.1.7</a><br>
<a href="http://192.168.1.7">192.168.1.7</a> [<a
href="http://192.168.1.7">
192.168.1.7</a>]:5060<br>
0(4222) WARRING: fix_socket_list: could not rev. resolve <a
href="http://192.168.1.7">192.168.1.7</a><br>
<a href="http://192.168.1.7">192.168.1.7</a> [<a
href="http://192.168.1.7">192.168.1.7</a>]:5060<br>
Listening on<br>
udp: <a href="http://192.168.1.7">192.168.1.7</a> [<a
href="http://192.168.1.7">192.168.1.7</a>]:5060<br>
tcp: <a href="http://192.168.1.7">192.168.1.7</a> [<a
href="http://192.168.1.7">192.168.1.7</a>]:5060<br>
Aliases:<br>
<br>
WARING: no fork mode<br>
stateless - initializing<br>
0(0) Maxfwd module- initializing<br>
0(0) new_connection(): Can't connect to local MySQL server through
socket '/tmp/mysql.sock' (2)<br>
0(0) db_init(): Could not create a connection<br>
0(0) ERROR: uridb_db_ver: unable to open database connection
<br>
0(0) ERROR: uri_db:mod_init(): Error while quering table version<br>
0(0) init_mod(): Error while initializing module uri_db<br>
ERROR: error while initializing modules<br>
<br>
It seems that SER can't connect to mysql
<br>
but i can use the command to ser database<br>
#mysql -u ser -pheslo<br>
mysql>connect ser<br>
Connectiong id: 27<br>
Current database: ser<br>
<br>
<div><span class="gmail_quote">What should I do for this situation?
<br>
Thanks again^^<br>
<br>
2006/12/12, Greger V. Teigre <<a href="mailto:greger@teigre.com">greger@teigre.com</a>>:</span>
<blockquote class="gmail_quote"
style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div bgcolor="#ffffff" text="#000000">Copy the list.<br>
Well, "libmysqlclient.so.14: cannot open shared object file: No such
file or directory" pretty much says it all, right?<br>
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).<br>
<span class="sg">g-)</span>
<div><span class="e" id="q_10f763f4492d47cc_2"><br>
<br>
Tako Chang wrote:
<blockquote
cite="http://mid48c4eeb40612102319o274c2094g24a88e8bbdb8b2c7@mail.gmail.com"
type="cite">Thanks!!<br>
I ran make_and_install script<br>
But i still can't run 'auth-mysql.cfg'<br>
Error message :<br>
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 <br>
<br>
but I have libmysqlclient.so.14 at "/usr/local/lib/mysql"<br>
What should I do?? <br>
<br>
Thanks for your help <(_ _)><br>
<br>
I mentioned that someone talked about the version of mysql<br>
So, i download the older version 4.1.22<br>
<div><span class="gmail_quote">2006/12/6, Greger V. Teigre < <a
href="mailto:greger@teigre.com" target="_blank"
onclick="return top.js.OpenExtLink(window,event,this)">greger@teigre.com</a>>:</span>
<blockquote class="gmail_quote"
style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div bgcolor="#ffffff" text="#000000">Look at the
make_and_install
script in the scripts package (same
place). It does this for you. mysql-devel must be installed.<br>
g-)<br>
<br>
Tako Chang wrote:
<blockquote
cite="http://mid48c4eeb40612052226h36337dcet3706498600b55d5@mail.gmail.com"
type="cite">
<div><span>Hi, all<br>
<br>
First of all, I read [<a
href="http://siprouter.onsip.org/doc/gettingstarted/" target="_blank"
onclick="return top.js.OpenExtLink(window,event,this)">SER - Getting
Started</a>] and downloaded [<a
href="ftp://siprouter.onsip.org/pub/gettingstarted/packages/ser-0.9.7-pre1.GettingStarted.1.6.tar.gz"
target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
SER Source package</a>] <br>
after I make the package under debug mode, it runs well.<br>
Now, I can receive REGISTER requests and send 200 OK Responses and play
a SIP proxy server<br>
<br>
I want to test "auth_mysql.cfg" in Chapter 7.... so, <br>
i remove "exclude_modules?= jabber mysql\" in Makefile<br>
but i still can't compile the mysql.so<br>
<br>
Is there some more detail documents or suggestions for me?<br>
<br>
Thank!<br>
</span></div>
<pre><hr size="4" width="90%">
_______________________________________________
Serusers mailing list
<a href="mailto:Serusers@lists.iptel.org" target="_blank"
onclick="return top.js.OpenExtLink(window,event,this)">Serusers@lists.iptel.org</a>
<a href="http://lists.iptel.org/mailman/listinfo/serusers"
target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">http://lists.iptel.org/mailman/listinfo/serusers</a>
</pre>
</blockquote>
</div>
</blockquote>
</div>
<br>
</blockquote>
</span></div>
</div>
</blockquote>
</div>
<br>
</blockquote>
</body>
</html>