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" <pelinescu-onciul(a)fokus.fraunhofer.de>
To: "Chundao Che" <cche(a)umd.umich.edu>
Cc: <serusers(a)lists.iptel.org>
Sent: Thursday, June 03, 2004 11:37 AM
Subject: Re: [Serusers] Mysql DB on remote host
On Jun 03, 2004 at 09:45, Chundao Che
<cche(a)umd.umich.edu> wrote:
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.
#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",
"mysql:ser:XXXXXXX@your.server.com/ser")
(and delete from it the modules you are not using)
Andrei
>
> Chundao
>
> Klaus Darilion wrote:
>
> >
> >
> >Chundao Che wrote:
> >
> >>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.
> >
> >you have to enable mysql in the Makefile or by typing:
> >make modules ........... as described in
> >http://lists.iptel.org/pipermail/serusers/2004-March/006904.html
> >
> >>
> >>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?
> >
> >
> >you have to set the database url:
> >modparam("auth_db", "password_column",
"password")
> >modparam("auth_db", "db_url",
"mysql://ser:XXXXXXX@your.server.com/ser")
>
>
> >klaus
>
>
>_______________________________________________
> >Serusers mailing list
> >serusers(a)lists.iptel.org
> >http://lists.iptel.org/mailman/listinfo/serusers
>
> _______________________________________________
> Serusers mailing list
> serusers(a)lists.iptel.org
>
http://lists.iptel.org/mailman/listinfo/serusers
_______________________________________________
Serusers mailing list
serusers(a)lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers