[OpenSIPS-Users] opensips error on centos 6
troxlinux
xserverlinux at gmail.com
Tue Aug 13 17:27:56 CEST 2013
ready, the problem was with mysql, had strict mode enabled
mysql> SELECT @@GLOBAL.sql_mode;
+--------------------------------------------+
| @@GLOBAL.sql_mode |
+--------------------------------------------+
| STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION |
+--------------------------------------------+
1 row in set (0.00 sec)
### disabled ###
SET @@GLOBAL.sql_mode = '';
Query OK, 0 rows affected (0.00 sec)
regardss
2013/8/12 troxlinux <xserverlinux at gmail.com>
> 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
>
--
rickygm
http://gnuforever.homelinux.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20130813/e0bc8f97/attachment-0001.htm>
More information about the Users
mailing list