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 <las...@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 <xserverli...@gmail.com> > >> not really .. >> >> [root@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 <las...@voipfreak.net> >> >>> Hmm, and db_mysql.so can be found under >>> /usr/local/lib64/opensips/modules/ ? >>> >>> -Laszlo >>> >>> >>> 2013/8/12 troxlinux <xserverli...@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 <las...@voipfreak.net> >>>> >>>>> Hi, >>>>> >>>>> Did you install the db_mysql module in opensips? >>>>> >>>>> -Laszlo >>>>> >>>>> >>>>> 2013/8/12 troxlinux <xserverli...@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@lists.opensips.org >>>>>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users >>>>>> >>>>>> >>>>> >>>>> >>>>> -- >>>>> >>>>> -- >>>>> Kind regards, >>>>> Laszlo Bekesi >>>>> http://voipfreak.net >>>>> >>>>> _______________________________________________ >>>>> Users mailing list >>>>> Users@lists.opensips.org >>>>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users >>>>> >>>>> >>>> >>>> >>>> -- >>>> rickygm >>>> >>>> http://gnuforever.homelinux.com >>>> >>>> _______________________________________________ >>>> Users mailing list >>>> Users@lists.opensips.org >>>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users >>>> >>>> >>> >>> >>> -- >>> >>> -- >>> Kind regards, >>> Laszlo Bekesi >>> http://voipfreak.net >>> >>> _______________________________________________ >>> Users mailing list >>> Users@lists.opensips.org >>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users >>> >>> >> >> >> -- >> rickygm >> >> http://gnuforever.homelinux.com >> >> _______________________________________________ >> Users mailing list >> Users@lists.opensips.org >> http://lists.opensips.org/cgi-bin/mailman/listinfo/users >> >> > > > -- > > -- > Kind regards, > Laszlo Bekesi > http://voipfreak.net > > _______________________________________________ > Users mailing list > Users@lists.opensips.org > http://lists.opensips.org/cgi-bin/mailman/listinfo/users > > -- rickygm http://gnuforever.homelinux.com
_______________________________________________ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
