[OpenSIPS-Users] opensips error on centos 6

[troxlinux]

Thnk Laslo , but shows me another error and I have set  the mysql user and
password in opensipsctlrc

 opensipsdbctl create
MySQL password for root:
INFO: test server charset
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
INFO: creating database opensips ...
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
ERROR 1101 (42000) at line 2: BLOB/TEXT column 'body' can't have a default
value
ERROR: Creating core tables failed!



2013/8/12 Laszlo <laszlo at voipfreak.net>

> Then the module is not installed ;)
>
> Try to recompile opensips with the following commands.
>
> make include_modules="db_mysql" modules
> make include_modules="db_mysql" install
>
> And check if db_mysql.so is installed...or not.
>
>
> -Laszlo
>
>
> 2013/8/12 troxlinux <xserverlinux at gmail.com>
>
>> not really ..
>>
>> [root at sipax modules]# ls -l db_*
>> -rwxr-xr-x 1 root root 120497 Aug  9 16:37 db_flatstore.so
>> -rwxr-xr-x 1 root root 231269 Aug  9 16:37 db_text.so
>> -rwxr-xr-x 1 root root 181500 Aug  9 16:37 db_virtual.so
>>
>>
>> /lib64/opensips/modules
>>
>>
>>
>> 2013/8/12 Laszlo <laszlo at voipfreak.net>
>>
>>> Hmm, and db_mysql.so can be found under
>>> /usr/local/lib64/opensips/modules/ ?
>>>
>>> -Laszlo
>>>
>>>
>>> 2013/8/12 troxlinux <xserverlinux at gmail.com>
>>>
>>>> Yes , look Makefile
>>>>
>>>> exclude_modules?= b2b_logic  cpl-c xmpp rls mi_xmlrpc xcap_client \
>>>>         db_oracle db_berkeley  \
>>>>         osp perl  db_perlvdb carrierroute mmgeoip \
>>>>         pua pua_bla pua_mi pua_usrloc pua_xmpp pua_dialoginfo \
>>>>         ldap h350 identity regex cachedb_memcached  \
>>>>
>>>>
>>>>
>>>> 2013/8/12 Laszlo <laszlo at voipfreak.net>
>>>>
>>>>> Hi,
>>>>>
>>>>> Did you install the db_mysql module in opensips?
>>>>>
>>>>> -Laszlo
>>>>>
>>>>>
>>>>> 2013/8/12 troxlinux <xserverlinux at gmail.com>
>>>>>
>>>>>> Hi , I tried to install opensips on centos 6.4 X64  , and I have all
>>>>>> sources installed mysql
>>>>>>  opensipsdbctl create
>>>>>> ERROR: could not load the script in /usr/local/lib64/opensips/
>>>>>> opensipsctl/opensipsdbctl.mysql for da                        tabase
>>>>>> engine MYSQL
>>>>>> ERROR: database engine not loaded - tried 'MYSQL'
>>>>>>
>>>>>>
>>>>>> rpm -qa | grep mysql
>>>>>> mysql-5.6.12-1.x86_64
>>>>>> php-mysql-5.4.16-1.x86_64
>>>>>> mysqlclient16-5.1.30-2.x86_64
>>>>>> mysql-server-5.6.12-1.x86_64
>>>>>> mysql-devel-5.6.12-1.x86_64
>>>>>> mysql-libs-5.6.12-1.x86_64
>>>>>>
>>>>>> any idea?
>>>>>>
>>>>>>
>>>>>> --
>>>>>> rickygm
>>>>>>
>>>>>> http://gnuforever.homelinux.com
>>>>>>
>>>>>> _______________________________________________
>>>>>> Users mailing list
>>>>>> Users at lists.opensips.org
>>>>>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>> --
>>>>>
>>>>> --
>>>>> Kind regards,
>>>>> Laszlo Bekesi
>>>>> http://voipfreak.net
>>>>>
>>>>> _______________________________________________
>>>>> Users mailing list
>>>>> Users at lists.opensips.org
>>>>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>>>>
>>>>>
>>>>
>>>>
>>>> --
>>>> rickygm
>>>>
>>>> http://gnuforever.homelinux.com
>>>>
>>>> _______________________________________________
>>>> Users mailing list
>>>> Users at lists.opensips.org
>>>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>>>
>>>>
>>>
>>>
>>> --
>>>
>>> --
>>> Kind regards,
>>> Laszlo Bekesi
>>> http://voipfreak.net
>>>
>>> _______________________________________________
>>> Users mailing list
>>> Users at lists.opensips.org
>>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>>
>>>
>>
>>
>> --
>> rickygm
>>
>> http://gnuforever.homelinux.com
>>
>> _______________________________________________
>> Users mailing list
>> Users at lists.opensips.org
>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>
>>
>
>
> --
>
> --
> Kind regards,
> Laszlo Bekesi
> http://voipfreak.net
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>


-- 
rickygm

http://gnuforever.homelinux.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20130812/eec32e68/attachment-0001.htm>