[Serusers] Mysql DB on remote host

[Andrei Pelinescu-Onciul]

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