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 :)

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'

thanks
Chundao


====== error message ===
debian:/home/cche/ser-0.8.12/modules/mysql# make
../../Makefile.defs:421: Old gcc detected (2.9x), use  gcc >= 3.1 for better results
../../Makefile.modules:21: "you should run make from the main ser directory"
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
/usr/bin/ld: cannot find -lz
collect2: ld returned 1 exit status
make: *** [mysql.so] Error 1


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

    

_______________________________________________
Serusers mailing list
serusers@lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers