<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
by following the instructions below, it give me an error message
(attached) with 'ld: cannot find -lz' . I then loaded 'zlib1g-dev'
package and compile it again, it succeded :) <br>
<br>
I also found out that the mysql module is excluded in Makefile, 'make
all' or 'make modules' will not include mysql, you either have to
modify the Makefile or use 'make include_module=mysql modules' and
'make include_modules=mysql install' <br>
<br>
thanks <br>
Chundao<br>
<br>
<br>
====== error message ===<br>
debian:/home/cche/ser-0.8.12/modules/mysql# make<br>
../../Makefile.defs:421: Old gcc detected (2.9x), use gcc >= 3.1
for better results<br>
../../Makefile.modules:21: "you should run make from the main ser
directory"<br>
gcc -shared -Wl,-O2 -Wl,-E db_con.o db_mod.o db_res.o db_row.o
db_utils.o db_val.o dbase.o utils.o -L/usr/lib/mysql -L/usr/local/lib
-L/usr/local/lib/mysql -L/usr/local/mysql/lib/mysql/
-L/usr/pkg/lib/mysql -L/usr/local/mysql/lib -lmysqlclient -lz -o
mysql.so <br>
/usr/bin/ld: cannot find -lz<br>
collect2: ld returned 1 exit status<br>
make: *** [mysql.so] Error 1<br>
<br>
<br>
Ezequiel Colombo wrote:<br>
<blockquote cite="mid008601c4497b$7635aa10$1d000a0a@ecolombo"
type="cite">
<pre wrap="">Try this and see if mysql compilation fail and the error returned.
cd modules/mysql/
make
(collect error and send to list)
In some systems the mysql.so compilation fail due to absence of zlib or
other needed files.
----- Original Message -----
From: "Andrei Pelinescu-Onciul" <a class="moz-txt-link-rfc2396E" href="mailto:pelinescu-onciul@fokus.fraunhofer.de"><pelinescu-onciul@fokus.fraunhofer.de></a>
To: "Chundao Che" <a class="moz-txt-link-rfc2396E" href="mailto:cche@umd.umich.edu"><cche@umd.umich.edu></a>
Cc: <a class="moz-txt-link-rfc2396E" href="mailto:serusers@lists.iptel.org"><serusers@lists.iptel.org></a>
Sent: Thursday, June 03, 2004 11:37 AM
Subject: Re: [Serusers] Mysql DB on remote host
</pre>
<blockquote type="cite">
<pre wrap="">On Jun 03, 2004 at 09:45, Chundao Che <a class="moz-txt-link-rfc2396E" href="mailto:cche@umd.umich.edu"><cche@umd.umich.edu></a> wrote:
</pre>
<blockquote type="cite">
<pre wrap="">Klaus,
thanks for your response. To question #1, after 'make modules' there is
no mysql.so file generated. Question #2, the db_url does not seem to do
anything differently.
</pre>
</blockquote>
<pre wrap="">#1 :
make modules include_modules=mysql
or
make modules ; make modules modules=modules/mysql
and to install:
make install include_modules=mysq
#2 :
What modules are you using?
Try something like:
modparam("usrloc|acc|auth_db|group|msilo", "db_url",
</pre>
</blockquote>
<pre wrap=""><!----><a class="moz-txt-link-rfc2396E" href="mailto:mysql:ser:XXXXXXX@your.server.com/ser">"mysql:ser:XXXXXXX@your.server.com/ser"</a>)
</pre>
<blockquote type="cite">
<pre wrap="">(and delete from it the modules you are not using)
Andrei
</pre>
<blockquote type="cite">
<pre wrap="">Chundao
Klaus Darilion wrote:
</pre>
<blockquote type="cite">
<pre wrap="">
Chundao Che wrote:
</pre>
<blockquote type="cite">
<pre wrap="">hello group,
I just started setting up Ser on a linux box (Debian). Please excuse
me if my questions have been asked many times before.
I have two questions here
1. when I compile from source, the mysql module is not compiled, I
cannot find mysql.so anywhere. I use the latest 0.8.12 release. The
daemon started okay without mysql modules.
</pre>
</blockquote>
<pre wrap="">you have to enable mysql in the Makefile or by typing:
make modules ........... as described in
<a class="moz-txt-link-freetext" href="http://lists.iptel.org/pipermail/serusers/2004-March/006904.html">http://lists.iptel.org/pipermail/serusers/2004-March/006904.html</a>
</pre>
<blockquote type="cite">
<pre wrap="">2. after no luck with the source, I switched to Debian package. I see
mysql modules are properly installed. I installed the mysql client on
my Debian box, and the Mysql database on a external box, I created
all tables and users successfully and I can manually access the
database from command line. But when I start the Ser daemon, it would
not start and still trying to look the Mysql.sock on local machine.
my questions is where do you tell Ser daemon to use global my.cnf
file for external database?
</pre>
</blockquote>
<pre wrap="">
you have to set the database url:
modparam("auth_db", "password_column", "password")
modparam("auth_db", "db_url",
</pre>
</blockquote>
</blockquote>
</blockquote>
<pre wrap=""><!----><a class="moz-txt-link-rfc2396E" href="mailto:mysql://ser:XXXXXXX@your.server.com/ser">"mysql://ser:XXXXXXX@your.server.com/ser"</a>)
</pre>
<blockquote type="cite">
<blockquote type="cite">
<blockquote type="cite">
<pre wrap="">klaus
_______________________________________________
Serusers mailing list
<a class="moz-txt-link-abbreviated" href="mailto:serusers@lists.iptel.org">serusers@lists.iptel.org</a>
<a class="moz-txt-link-freetext" href="http://lists.iptel.org/mailman/listinfo/serusers">http://lists.iptel.org/mailman/listinfo/serusers</a>
</pre>
</blockquote>
<pre wrap="">_______________________________________________
Serusers mailing list
<a class="moz-txt-link-abbreviated" href="mailto:serusers@lists.iptel.org">serusers@lists.iptel.org</a>
<a class="moz-txt-link-freetext" href="http://lists.iptel.org/mailman/listinfo/serusers">http://lists.iptel.org/mailman/listinfo/serusers</a>
</pre>
</blockquote>
<pre wrap="">_______________________________________________
Serusers mailing list
<a class="moz-txt-link-abbreviated" href="mailto:serusers@lists.iptel.org">serusers@lists.iptel.org</a>
<a class="moz-txt-link-freetext" href="http://lists.iptel.org/mailman/listinfo/serusers">http://lists.iptel.org/mailman/listinfo/serusers</a>
</pre>
</blockquote>
<pre wrap=""><!---->
_______________________________________________
Serusers mailing list
<a class="moz-txt-link-abbreviated" href="mailto:serusers@lists.iptel.org">serusers@lists.iptel.org</a>
<a class="moz-txt-link-freetext" href="http://lists.iptel.org/mailman/listinfo/serusers">http://lists.iptel.org/mailman/listinfo/serusers</a>
</pre>
</blockquote>
</body>
</html>