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%">
_______________________________________________<br>Serusers mailing list<br><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>