I was more thinking of changing /etc/my.cnf to '/var/lib/mysql/mysql.sock'. AFAIK, /tmp/mysql.sock was the old location of the socket. The /tmp directory is no place for a socket... g-)
Kamran Ahmad wrote:
/etc/my.cnf [mysqld] datadir=/var/lib/mysql socket=/tmp/mysql.sock
[mysql.server] user=mysql ;basedir=/var/lib basedir=/usr/local/mysql
[safe_mysqld] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid
but it is still looking '/var/lib/mysql/mysql.sock'
textops - initializing 0(0) DEBUG: init_mod: uri_db 0(0) uri_db - initializing 0(0) find_mod_export: found <db_use_table> in module mysql [/usr/local/lib/ser/modules/mysql.so] 0(0) find_mod_export: found <db_init> in module mysql [/usr/local/lib/ser/modules/mysql.so] 0(0) find_mod_export: found <db_close> in module mysql [/usr/local/lib/ser/modules/mysql.so] 0(0) find_mod_export: found <db_query> in module mysql [/usr/local/lib/ser/modules/mysql.so] 0(0) find_mod_export: found <db_raw_query> in module mysql [/usr/local/lib/ser/modules/mysql.so] 0(0) find_mod_export: found <db_free_result> in module mysql [/usr/local/lib/ser/modules/mysql.so] 0(0) find_mod_export: found <db_insert> in module mysql [/usr/local/lib/ser/modules/mysql.so] 0(0) find_mod_export: found <db_delete> in module mysql [/usr/local/lib/ser/modules/mysql.so] 0(0) find_mod_export: found <db_update> in module mysql [/usr/local/lib/ser/modules/mysql.so] 0(0) get_connection(): Connection not found in the pool 0(0) new_connection(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) 0(0) db_init(): Could not create a connection 0(0) ERROR: uridb_db_ver: unable to open database connection 0(0) ERROR: uri_db:mod_init(): Error while querying table version 0(0) init_mod(): Error while initializing module uri_db ERROR: error while initializing modules 0(0) XLOG: destroy module ... 0(0) DEBUG: tm_shutdown : start 0(0) DEBUG: unlink_timer_lists : emptying DELETE list 0(0) DEBUG: tm_shutdown : emptying hash table 0(0) DEBUG: tm_shutdown : releasing timers 0(0) DEBUG: tm_shutdown : removing semaphores 0(0) DEBUG: tm_shutdown : destroying tmcb lists 0(0) DEBUG: tm_shutdown : done 0(5133) shm_mem_destroy 0(5133) destroying the shared memory lock -..............................................
--- "Greger V. Teigre" greger@teigre.com wrote:
You define the mysql socket in /etc/my.cnf g-) Kamran Ahmad wrote:
when i am starting ser it is not working. how to set mysql socket to /tmp/mysql.sock
/var/log/messages
Apr 14 05:13:47 achieva ser: WARNING: fix_socket_list: could not rev. resolve 202.42.132.133 Apr 14 05:13:57 achieva ser: WARNING: fix_socket_list: could not rev. resolve 202.42.132.133 Apr 14 05:13:57 achieva ser[16717]: Maxfwd module- initializing Apr 14 05:13:57 achieva ser[16717]: new_connection(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) Apr 14 05:13:57 achieva ser[16717]: db_init(): Could not create a connection Apr 14 05:13:57 achieva ser[16717]: ERROR: uridb_db_ver: unable to open database connection Apr 14 05:13:57 achieva ser[16717]: ERROR: uri_db:mod_init(): Error while querying table version Apr 14 05:13:57 achieva ser[16717]: init_mod(): Error while initializing module uri_db Apr 14 05:14:22 achieva cups: cupsd shutdown succeeded Apr 14 05:14:25 achieva cups: cupsd startup succeeded Apr 14 05:14:25 achieva logrotate: ALERT exited abnormally with [1]
--- "Greger V. Teigre" greger@teigre.com wrote:
Kamran, The make_and_install script saves all output to make_and_install_output.txt in the source root directory. Search for errors in that file (or mysql) and you will see what happened. If you don't get a mysql.so at all, most likely you have not installed the mysql-devel package (so mysql header file is missing). g-) Kamran Ahmad wrote:
hello
while i am trying to compile mysql module for ser but it is not working. i am using ser-0.9.0.
I HAVE TRIED ./make_and_install sql but unable to compile mysql and i also used changed Makefile then make; make install but still unable to compile mysql.so
any one gone through this.
Kamran
Do you Yahoo!? Yahoo! Small Business - Try our new resources site! http://smallbusiness.yahoo.com/resources/
Serusers mailing list serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers
Do you Yahoo!? Yahoo! Small Business - Try our new resources site! http://smallbusiness.yahoo.com/resources/
Do you Yahoo!? Yahoo! Small Business - Try our new resources site! http://smallbusiness.yahoo.com/resources/