[Serusers] MySql error

Daniel-Constantin Mierla Daniel-Constantin.Mierla at fokus.fraunhofer.de
Tue Sep 23 10:47:57 CEST 2003


Please keep cc-ing to the mailing list so others can help you faster 
than me and others can benefit from this experience.

The warning is because you didn't specify a listening interface and ser 
tries to listen on all but since you have 'fork=no' that is not possible 
and ser will listen only on the first one (as the log message says).

Secondly, either your mysql server is not running or the mysql client 
package you have installed is a different version than the mysql server 
and they use different unix sockets for client-server communication.

Follow the mail thread:
http://lists.iptel.org/pipermail/serusers/2003-March/000627.html

Best regards,
Daniel

Sesha Bhatlapenumarthy wrote:

>I didnt have the mysql client installed. But now, after I installed that
>one, I am getting new kind of error. I'm pasting this error below. I have
>the mysqld running as root.
>
>root at sipdirector:/home/install# /usr/local/sbin/ser start
>Listening on
>              127.0.0.1 [127.0.0.1]:5060
>              208.133.33.46 [208.133.33.46]:5060
>Aliases: sipdirector:5060 sipdirector.iic.com:5060 localhost:5060
>WARNING: no fork mode  and more than one listen address found (will use only
>the
> the first one)
>stateless - initializing
>Maxfwd module- initializing
> 0(1758) connect_db(): Can't connect to local MySQL server through socket
>'/var/
>run/mysql/mysql.sock' (111)
> 0(1758) db_init(): Error while trying to connect database
> 0(1758) mod_init(): Error while connecting database
> 0(1758) init_mod(): Error while initializing module usrloc
>ERROR: error while initializing modules
>
>
>
>
>
>
>
>
>
>
>
>
>-----Original Message-----
>From: Daniel-Constantin Mierla
>[mailto:Daniel-Constantin.Mierla at fokus.fraunhofer.de]
>Sent: Monday, September 22, 2003 2:57 PM
>To: Sesha Bhatlapenumarthy
>Subject: Re: [Serusers] MySql error
>
>
>Hello,
>Are you sure that the mysql.so from /usr/local/lib/ser/modules/ is the
>one from ser? OnUpdateInt name doesn't look like a common C function
>name under linux -- they are usually lower case ... but never mind ...
>
>The problem is some symbol dependency -- do you have installed mysql
>client and mysql devel packages? If so, please go in the folder where
>the sources of ser are and type:
>'make modules modules=modules/mysql'
>
>Tell me if you get the 'mysql.so' file in the subfolder
>'modules/mysql/'. If you get it, copy it by hand to
>'/usr/local/lib/ser/modules', e.g.,:
>'cp modules/mysql/mysql.so /usr/local/lib/ser/modules'
>
>Try again and tell me if the problem still persists.
>
>Best regards,
>Daniel
>
>Sesha Bhatlapenumarthy wrote:
>
>  
>
>>I am attaching the error in this mail. I restarted the ser with debug level
>>7 and get this file. I have also done make install include_modlues="mysql..
>>i get all the entering directory and leaving directory messages. I dont see
>>it entering the mysql in modules directory.. I have mysql.so in
>>/usr/local/lib/ser/modules. I cant figure out where the problem is.. plzz
>>help.thank you.
>>
>>
>>
>>
>>-----Original Message-----
>>From: Daniel-Constantin Mierla
>>[mailto:Daniel-Constantin.Mierla at fokus.fraunhofer.de]
>>Sent: Monday, September 22, 2003 11:17 AM
>>To: Sesha Bhatlapenumarthy
>>Cc: serusers at lists.iptel.org
>>Subject: Re: [Serusers] MySql error
>>
>>
>>Hello,
>>could you send us the log messages (/var/log/messages, lines beginning
>>with ser, look for "error" word)? Have you tried 'make install
>>include_modules="mysql"'? A hint, look into your ser config file, see
>>the path to mysql module and check if the file is there.
>>
>>Did you install ser sometime ago from a package? If I remember
>>correctly, when installing from sources, the path to modules is
>>/usr/local/lib/ser/modules ...
>>
>>Best regards,
>>Daniel
>>
>>Sesha Bhatlapenumarthy wrote:
>>
>>
>>
>>    
>>
>>>I am not able to load the mysql module. I have installed ser from tar. I
>>>also tried make include_modules="mysql" . But I am not able to load the
>>>mysql module. make install loads all the modules except mysql, though I
>>>      
>>>
>see
>  
>
>>>mysql.so in /usr/lib/ser/modules . mysqld is running. Please help me.
>>>
>>>Sesha
>>>
>>>
>>>_______________________________________________
>>>Serusers mailing list
>>>serusers at lists.iptel.org
>>>http://lists.iptel.org/mailman/listinfo/serusers
>>>
>>>
>>>
>>>
>>>
>>>      
>>>
>>
>>------------------------------------------------------------------------
>>
>>0(1068) loading module /usr/local//lib/ser/modules/mysql.so
>>0(1068) ERROR: load_module: could not open module
>>    
>>
></usr/local//lib/ser/modules/
>  
>
>>mysql.so>: /usr/local//lib/ser/modules/mysql.so: undefined symbol:
>>    
>>
>OnUpdateInt
>  
>
>>0(1068) parse error (29,13-50): failed to load module
>>0(1068) loading module /usr/local//lib/ser/modules/sl.so
>>0(1068) loading module /usr/local//lib/ser/modules/tm.so
>>0(1068) loading module /usr/local//lib/ser/modules/rr.so
>>0(1068) loading module /usr/local//lib/ser/modules/maxfwd.so
>>0(1068) loading module /usr/local//lib/ser/modules/usrloc.so
>>0(1068) loading module /usr/local//lib/ser/modules/registrar.so
>>0(1068) loading module /usr/local//lib/ser/modules/auth.so
>>0(1068) loading module /usr/local//lib/ser/modules/auth_db.so
>>0(1068) set_mod_param_regex: usrloc matches module usrloc
>>0(1068) set_mod_param_regex: found <db_mode> in module usrloc
>>    
>>
>[/usr/local//lib/
>  
>
>>ser/modules/usrloc.so]
>>0(1068) set_mod_param_regex: auth_db matches module auth_db
>>0(1068) set_mod_param_regex: found <calculate_ha1> in module auth_db
>>    
>>
>[/usr/loca
>  
>
>>l//lib/ser/modules/auth_db.so]
>>0(1068) set_mod_param_regex: auth_db matches module auth_db
>>0(1068) set_mod_param_regex: found <password_column> in module auth_db
>>    
>>
>[/usr/lo
>  
>
>>cal//lib/ser/modules/auth_db.so]
>>0(1068) set_mod_param_regex: rr matches module rr
>>0(1068) set_mod_param_regex: found <enable_full_lr> in module rr
>>    
>>
>[/usr/local//l
>  
>
>>ib/ser/modules/rr.so]
>>0(1068) find_export: found <mf_process_maxfwd_header> in module
>>    
>>
>maxfwd_module [
>  
>
>>/usr/local//lib/ser/modules/maxfwd.so]
>>0(1068) find_export: found <sl_send_reply> in module sl_module
>>    
>>
>[/usr/local//lib
>  
>
>>/ser/modules/sl.so]
>>0(1068) find_export: found <sl_send_reply> in module sl_module
>>    
>>
>[/usr/local//lib
>  
>
>>/ser/modules/sl.so]
>>0(1068) find_export: found <record_route> in module rr
>>    
>>
>[/usr/local//lib/ser/mod
>  
>
>>ules/rr.so]
>>0(1068) find_export: found <loose_route> in module rr
>>    
>>
>[/usr/local//lib/ser/modu
>  
>
>>les/rr.so]
>>0(1068) find_export: found <t_relay> in module tm
>>    
>>
>[/usr/local//lib/ser/modules/
>  
>
>>tm.so]
>>0(1068) find_export: found <save> in module registrar
>>    
>>
>[/usr/local//lib/ser/modu
>  
>
>>les/registrar.so]
>>0(1068) find_export: found <lookup> in module registrar
>>    
>>
>[/usr/local//lib/ser/mo
>  
>
>>dules/registrar.so]
>>0(1068) find_export: found <sl_send_reply> in module sl_module
>>    
>>
>[/usr/local//lib
>  
>
>>/ser/modules/sl.so]
>>0(1068) find_export: found <t_relay> in module tm
>>    
>>
>[/usr/local//lib/ser/modules/
>  
>
>>tm.so]
>>0(1068) find_export: found <sl_reply_error> in module sl_module
>>    
>>
>[/usr/local//li
>  
>
>>b/ser/modules/sl.so]
>>ERROR: bad config file (1 errors)
>>0(1068) DEBUG: tm_shutdown : start
>>0(1068) DEBUG: tm_shutdown : empting hash table
>>0(1068) DEBUG: tm_shutdown: releasing timers
>>0(1068) DEBUG: tm_shutdown : removing semaphores
>>0(1068) DEBUG: tm_shutdown : done
>>0(1068) shm_mem_destroy
>>0(1068) destroying the shared memory lock
>>
>>    
>>
>
>
>  
>





More information about the sr-users mailing list