<div dir="ltr"><div><div><div>Hmm, that error means you running mysqld in strict mode. Can you check if you have something like this in your my.cnf file?<br></div><br>sql_mode=STRICT_TRANS_TABLES<br><br></div>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.<br>
<br><br></div>-Laszlo<br><div><div><br></div></div></div><div class="gmail_extra"><br><br><div class="gmail_quote">2013/8/12 troxlinux <span dir="ltr"><<a href="mailto:xserverlinux@gmail.com" target="_blank">xserverlinux@gmail.com</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Thnk Laslo , but <span lang="en"><span>shows me</span> <span>another error</span> <span>and</span> <span>I have</span> <span>set </span> <span>the</span> <span>mysql</span> <span>user and</span> <span>password</span> <span>in opensipsctlrc<br>
<br> opensipsdbctl create<br>MySQL password for root:<br>INFO: test server charset<br>Warning: Using a password on the command line interface can be insecure.<br>Warning: Using a password on the command line interface can be insecure.<br>
INFO: creating database opensips ...<br>Warning: Using a password on the command line interface can be insecure.<br>Warning: Using a password on the command line interface can be insecure.<br>Warning: Using a password on the command line interface can be insecure.<br>
Warning: Using a password on the command line interface can be insecure.<br>Warning: Using a password on the command line interface can be insecure.<br>Warning: Using a password on the command line interface can be insecure.<br>
Warning: Using a password on the command line interface can be insecure.<br>Warning: Using a password on the command line interface can be insecure.<br>Warning: Using a password on the command line interface can be insecure.<br>
Warning: Using a password on the command line interface can be insecure.<br>ERROR 1101 (42000) at line 2: BLOB/TEXT column 'body' can't have a default value<br>ERROR: Creating core tables failed!<br><br></span></span></div>
<div class="HOEnZb"><div class="h5">
<div class="gmail_extra"><br><br><div class="gmail_quote">2013/8/12 Laszlo <span dir="ltr"><<a href="mailto:laszlo@voipfreak.net" target="_blank">laszlo@voipfreak.net</a>></span><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr"><div><div><div><div>Then the module is not installed ;)<br><br></div>Try to recompile opensips with the following commands.<br><br></div>make include_modules="db_mysql" modules<br>make include_modules="db_mysql" install<br>
<br></div>And check if db_mysql.so is installed...or not.<span><font color="#888888"><br><br><br></font></span></div><span><font color="#888888">-Laszlo<br></font></span></div><div>
<div><div class="gmail_extra"><br><br><div class="gmail_quote">2013/8/12 troxlinux <span dir="ltr"><<a href="mailto:xserverlinux@gmail.com" target="_blank">xserverlinux@gmail.com</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><span lang="en"><span>not really ..<br><br>[root@sipax modules]# ls -l db_*<br>-rwxr-xr-x 1 root root 120497 Aug 9 16:37 db_flatstore.so<br>
-rwxr-xr-x 1 root root 231269 Aug 9 16:37 db_text.so<br>
-rwxr-xr-x 1 root root 181500 Aug 9 16:37 db_virtual.so<br><br><br>/lib64/opensips/modules<br><br></span></span></div><div><div><div class="gmail_extra"><br><br><div class="gmail_quote">2013/8/12 Laszlo <span dir="ltr"><<a href="mailto:laszlo@voipfreak.net" target="_blank">laszlo@voipfreak.net</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div>Hmm, and db_mysql.so can be found under /usr/local/lib64/opensips/modules/ ?<span><font color="#888888"><br>
<br></font></span></div><span><font color="#888888">-Laszlo<br></font></span></div><div><div><div class="gmail_extra"><br><br><div class="gmail_quote">2013/8/12 troxlinux <span dir="ltr"><<a href="mailto:xserverlinux@gmail.com" target="_blank">xserverlinux@gmail.com</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Yes , look Makefile<br><div><br>exclude_modules?= b2b_logic cpl-c xmpp rls mi_xmlrpc xcap_client \<br>
db_oracle db_berkeley \<br>
osp perl db_perlvdb carrierroute mmgeoip \<br> pua pua_bla pua_mi pua_usrloc pua_xmpp pua_dialoginfo \<br>
ldap h350 identity regex cachedb_memcached \<br><br></div></div><div class="gmail_extra"><div><div><br><br><div class="gmail_quote">2013/8/12 Laszlo <span dir="ltr"><<a href="mailto:laszlo@voipfreak.net" target="_blank">laszlo@voipfreak.net</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div><div>Hi,<br><br></div>Did you install the db_mysql module in opensips?<br><br></div>-Laszlo<br></div>
<div class="gmail_extra"><br><br><div class="gmail_quote">2013/8/12 troxlinux <span dir="ltr"><<a href="mailto:xserverlinux@gmail.com" target="_blank">xserverlinux@gmail.com</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div><div dir="ltr">Hi , I tried to install opensips on centos 6.4 X64 , <span lang="en"><span>and</span> <span>I have</span> <span>all</span> <span>sources</span> <span>installed</span> <span>mysql</span></span>
<br> opensipsdbctl create<br>ERROR: could not load the script in /usr/local/lib64/opensips/<div>opensipsctl/opensipsdbctl.mysql for da tabase engine MYSQL<br>ERROR: database engine not loaded - tried 'MYSQL'<br>
<br><br>rpm -qa | grep mysql<br>mysql-5.6.12-1.x86_64<br>php-mysql-5.4.16-1.x86_64<br>mysqlclient16-5.1.30-2.x86_64<br>mysql-server-5.6.12-1.x86_64<br>mysql-devel-5.6.12-1.x86_64<br>mysql-libs-5.6.12-1.x86_64<div>
<div><img src="https://mail.google.com/mail/images/cleardot.gif"><br></div><div>any idea?<span><font color="#888888"><br></font></span></div></div></div><span><font color="#888888"><br clear="all">
<br>-- <br>rickygm<br>
<br><a href="http://gnuforever.homelinux.com" target="_blank">http://gnuforever.homelinux.com</a>
</font></span></div>
<br></div></div>_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a><br>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
<br></blockquote></div><span><font color="#888888"><br><br clear="all"><br>-- <br><div dir="ltr"><div><div><div><br>--<br></div>Kind regards,<br></div>Laszlo Bekesi<br></div><a href="http://voipfreak.net" target="_blank">http://voipfreak.net</a><br>
</div>
</font></span></div>
<br>_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a><br>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
<br></blockquote></div><br><br clear="all"><br>-- <br></div></div>rickygm<br><br><a href="http://gnuforever.homelinux.com" target="_blank">http://gnuforever.homelinux.com</a>
</div>
<br>_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a><br>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
<br></blockquote></div><br><br clear="all"><br>-- <br><div dir="ltr"><div><div><div><br>--<br></div>Kind regards,<br></div>Laszlo Bekesi<br></div><a href="http://voipfreak.net" target="_blank">http://voipfreak.net</a><br>
</div>
</div>
</div></div><br>_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a><br>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
<br></blockquote></div><br><br clear="all"><br>-- <br>rickygm<br><br><a href="http://gnuforever.homelinux.com" target="_blank">http://gnuforever.homelinux.com</a>
</div>
</div></div><br>_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a><br>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
<br></blockquote></div><br><br clear="all"><br>-- <br><div dir="ltr"><div><div><div><br>--<br></div>Kind regards,<br></div>Laszlo Bekesi<br></div><a href="http://voipfreak.net" target="_blank">http://voipfreak.net</a><br>
</div>
</div>
</div></div><br>_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a><br>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
<br></blockquote></div><br><br clear="all"><br>-- <br>rickygm<br><br><a href="http://gnuforever.homelinux.com" target="_blank">http://gnuforever.homelinux.com</a>
</div>
</div></div><br>_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
<br></blockquote></div><br><br clear="all"><br>-- <br><div dir="ltr"><div><div><div><br>--<br></div>Kind regards,<br></div>Laszlo Bekesi<br></div><a href="http://voipfreak.net" target="_blank">http://voipfreak.net</a><br>
</div>
</div>