[OpenSIPS-Users] opensips error on centos 6

[troxlinux]

Ok  I check my.cnf and not I have the option, the add in this way and I do
not run

[mysqld]
sql-mode = ""


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

> 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
>
> _______________________________________________
> 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/a46151cc/attachment-0001.htm>