[OpenSIPS-Users] opensips error on centos 6

[Laszlo]

Hmm, that error means you running mysqld in strict mode. Can you check if
you have something like this in your my.cnf file?

sql_mode=STRICT_TRANS_TABLES

If you have this, please remove it and restart mysqld to changes take
effect. And then drop your opensips tables, and re-run opensipsdbctl create.


-Laszlo



2013/8/12 troxlinux <xserverlinux at gmail.com>

> 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
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>


-- 

--
Kind regards,
Laszlo Bekesi
http://voipfreak.net
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20130812/0d904a95/attachment.htm>