I have a small c program that is supposed to run a select query against a MySQL database. It keeps bombing with a segfault during what I think is the db connect. I recompiled everything with debug and ran mysql_debug in the code and am getting the following:
[youngd@fett]:~/src/logit $ ./searchlog -d Debug set Parsed config file and got: DB Host: fett DB Name: CHANGELOG DB User: youngd DB Pass: xxxxxx 1: dbug: libmysql.c: 1176: 1: >mysql_real_connect 2: dbug: libmysql.c: 1178: 1: | enter: host: fett db: CHANGELOG user: youngd 3: dbug: libmysql.c: 1294: 1: | info: Server name: 'fett'. TCP sock: 1073830556 4: dbug: violite.c: 103: 2: | >vio_new 5: dbug: violite.c: 104: 2: | | enter: sd=3 6: dbug: my_malloc.c: 31: 3: | | >my_malloc 7: dbug: my_malloc.c: 32: 3: | | | my: Size: 84 MyFlags: 16 8: dbug: my_malloc.c: 48: 3: | | | exit: ptr: 8072d68 9: dbug: my_malloc.c: 49: 3: | | <my_malloc 10: dbug: violite.c: 126: 2: | <vio_new 11: dbug: libmysql.c: 1346: 1: | error: Got error 111 on connect to 'fett' 12: dbug: libmysql.c: 1568: 1: | error: message: 2003 (Can't connect to MySQL server on 'fett' (111)) 13: dbug: libmysql.c: 622: 2: | >end_server 14: dbug: libmysql.c: 626: 2: | | info: Net: TCP/IP (3) 15: dbug: violite.c: 341: 3: | | >vio_close 16: dbug: violite.c: 362: 3: | | | vio_error: close() failed, error: 107 17: dbug: violite.c: 367: 3: | | <vio_close 18: dbug: my_malloc.c: 58: 3: | | >my_free 19: dbug: my_malloc.c: 59: 3: | | | my: ptr: 8072d68 20: dbug: my_malloc.c: 62: 3: | | <my_free 21: dbug: my_malloc.c: 58: 3: | | >my_free 22: dbug: my_malloc.c: 59: 3: | | | my: ptr: 333a3630 Segmentation fault If I run a strace on the same binary I get: connect(3, {sin_family=AF_INET, sin_port=htons(23196), sin_addr=inet_addr("192.168.5.3")}}, 16) = -1 ECONNREFUSED (Connection refused) shutdown(3, 2 /* send and receive */) = -1 ENOTCONN (Transport endpoint is not connected) close(3) = 0 --- SIGSEGV (Segmentation fault) --- +++ killed by SIGSEGV +++ It picks up the connection info from a config file. I have other utils that use the same config file and parsing code which work ok. The host, db, username and password are used by other scripts and programs. The only thing this program does is runs a single select query against the db. Any ideas what error 111 and/or 2003 is? Other thoughts? The actual debug used in the code is: mysql_debug("d:t:F:L:n:N:P:o:, /tmp/client.trace"); Thanks, Darren Young [EMAIL PROTECTED] --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php