[Serusers] Mysql DB on remote host

[Ezequiel Colombo]

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 at fokus.fraunhofer.de>
To: "Chundao Che" <cche at umd.umich.edu>
Cc: <serusers at 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 at 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 at 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 at lists.iptel.org
> > >http://lists.iptel.org/mailman/listinfo/serusers
> >
> > _______________________________________________
> > Serusers mailing list
> > serusers at lists.iptel.org
> > http://lists.iptel.org/mailman/listinfo/serusers
>
> _______________________________________________
> Serusers mailing list
> serusers at lists.iptel.org
> http://lists.iptel.org/mailman/listinfo/serusers
>