Does anybody have any idea why this program won't compile, it seems to
be straightforward, but it I can't get it to compile on Redhat-7.3.
It starts screaming about mysql.h immediately, I use this link to
compile with, on my machine at the house, it compiles just fine and runs
just fine, but I can't get it to compile on any of my other 7.3
machines, does anybody, know what I could be missing, I'm using up to
Redhat rpms of mysql, and I have the devel rpm, so I have all the
libraries and include files. but ???
RPMS on the machines
mysql-devel-3.23.56-1.73
mysql-3.23.56-1.73
mysql-server-3.23.56-1.73
gcc -c -I/usr/include/mysql mysql1.c
In file included from mysql1.c:3:
/usr/include/mysql/mysql.h:127: parse error before `MEM_ROOT'
/usr/include/mysql/mysql.h:127: warning: no semicolon at end of struct
or union
/usr/include/mysql/mysql.h:128: warning: data definition has no type or
storage class
/usr/include/mysql/mysql.h:168: parse error before `MEM_ROOT'
/usr/include/mysql/mysql.h:168: warning: no semicolon at end of struct
or union
/usr/include/mysql/mysql.h:175: parse error before `}'
/usr/include/mysql/mysql.h:175: warning: data definition has no type or
storage class
/usr/include/mysql/mysql.h:182: parse error before `MYSQL_DATA'
------ cut ------ the errors go on quite a bit, but the MEM_ROOT is
pretty instant, and it's over before it begins... anybody ever had this
problem, I've searched google quite a bit, but I can't find what the
deal is and what the problem is. any help appreciated...
/* client1.c - connect to and disconnect from MySQL server */
#include <my_global.h>
#include <mysql.h>
static char *opt_host_name = NULL; /* server host (default=localhost) */
static char *opt_user_name = "username"; /* username (default=login
name) */
static char *opt_password = "password"; /* password (default=none) */
static unsigned int opt_port_num = 0; /* port number (use built-in
value) */
static char *opt_socket_name = NULL; /* socket name (use built-in value)
*/
static char *opt_db_name = "spamassassin"; /* database name
(default=none) */
static unsigned int opt_flags = 0; /* connection flags (none) */
static MYSQL *conn; /* pointer to connection handler */
int
main (int argc, char *argv[])
{
char sql_command[2048];
MYSQL_RES *result;
MYSQL_ROW row;
int state;
int i;
/* initialize connection handler */
conn = mysql_init (NULL);
if(conn==NULL) {
fprintf(stderr,"mysql_init() failed (probably out of
memory)\n");
exit(1);
}
/* connect to server */
if(mysql_real_connect (conn, opt_host_name, opt_user_name,
opt_password,
opt_db_name, opt_port_num, opt_socket_name,
opt_flags)
==NULL)
{
fprintf( stderr, "mysql_real_connect() failed:\nEror %u
(%s)\n",
mysql_errno(conn), mysql_error(conn));
exit(1);
}
/* disconnect from server */
sprintf(sql_command, "SELECT count(*) from spamassassin.badguys
where badguy like '%s'",argv[1]);
state = mysql_query(conn, sql_command);
if (state!=0) return 0;
// must call mysql_store_result() before we can issue any other
// query calls
result = mysql_store_result(conn);
if( (row=mysql_fetch_row(result)) != NULL) {
printf("%s badguys found: %s\n",row[0],argv[1]);
}
// free the result set
mysql_free_result(result);
/* disconnect from server */
mysql_close (conn);
exit (0);
}
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
