[Serusers] Mysql DB on remote host

Bogdan-Andrei IANCU iancu at fokus.fraunhofer.de
Thu Jun 3 17:16:44 CEST 2004


Doing make directly in a module directori is totaly broken. If you want 
to compile only a module do :
    make modules modules=modules/mysql

Bogdan

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 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
>>
>>    
>>
>
>_______________________________________________
>Serusers mailing list
>serusers at lists.iptel.org
>http://lists.iptel.org/mailman/listinfo/serusers
>
>  
>




More information about the sr-users mailing list