mysql.h issue

["Edward Hotchkiss" <edward@xxxxxxxxxxxx>]

When I "make -f MAKE" using the following make file, I Get this error: 

thing.c:28:19: error: mysql.h: No such file or directory
thing.c:49: error: syntax error before '*' token
thing.c:49: warning: data definition has no type or storage class
thing.c: In function 'mysql_connect':
thing.c:134: warning: assignment makes pointer from integer without a
cast
make: *** [thing.o] Error 1

When I run "locate mysql.h"
It returns /usr/include/mysql/mysql.h

Any ideas why I get this error?

- edward 



# MAKE
CC = gcc
INCLUDES = -P/usr/include/mysql/mysql.h
LIBS = -L/usr/local/lib/mysql -lmysqlclient

all: thing

thing: thing.o
	$(CC) -o thing thing.o $(LIBS)

clean:
	rm -f thing.o



/*
thing.c
- WebServer Monitor w/ MySQL logging
- 04/29/06
------------------------------------
*/

#include <stdio.h>
#include <stdlib.h>
#include <string.h>
#include <errno.h>
#include <unistd.h>
#include <arpa/inet.h>
#include <sys/types.h>
#include <sys/socket.h>
#include <netinet/tcp.h>
#include <netinet/ip.h>
#include <netinet/in.h>
#include <netdb.h>
#include <unistd.h>
#include <mysql.h>

// default port to start with
#define DEF_START_PORT  1

// default port to end with
#define DEF_STOP_PORT 65000

// Program Version
#define VERSION 0

// Author
#define AUTHOR "e2"

// MySQL Connection data
#define MYSQL_HOST "localhost"
#define MYSQL_USER "root"
#define MYSQL_PASS "5gtswedfgbc06"
#define MYSQL_DATABASE "thing"

// MySQL Connection Handle
MYSQL *conn;

struct sockaddr_in addr;
struct hostent *rh;
struct servent *rp;

int sock, i;

// Pointers to the start and stop ports
int start_ptr, stop_ptr;

// Show the user proper program usage
int Usage(char *ARG);

// Connection/Port
int CONNECTION(int port);
     
// Iterate through ports, check ports for validity                
int main(int argc, char *argv[])
{

	if (argc != 4)
		Usage(argv[0]);
		start_ptr = atoi(argv[2]);
		stop_ptr = atoi(argv[3]);
	if (strcmp(argv[2],"-")==0 && strcmp(argv[3],"-")==0){
		start_ptr = DEF_START_PORT;
		stop_ptr = DEF_STOP_PORT;
	}
		
	if ( start_ptr > stop_ptr){
		fprintf(stderr,"Error, <Star-Port> Can't Be Greater Than
<Stop-Port>.-\n");
		Usage(argv[0]);
		exit(1);
	}
	// Host does not exist
	if ((rh=gethostbyname(argv[1])) == NULL) {		
		fprintf(stderr,"Can't Resolve Host %s .-\n",argv[1]);
		Usage(argv[0]);
		exit(1);
	}
	// Scan title
	printf("Scanning Host %s From %d TCP Port To %d .-\n", argv[1],
start_ptr, stop_ptr);
	// Iterate through ports
	for (i=start_ptr; i <= stop_ptr; i++)
	{
		if (CONNECTION(i)==0)
		{
			rp = getservbyport(htons(i), "tcp");
			printf("Port %d Is Open !!! <%s>
ServicE.-\n",i,(rp == NULL)?"Uknown":rp->s_name);
		}
	close(sock);
	}
// Exit
return 0;
}

// Try and connect to a port
int CONNECTION(int port)
{
	if ((sock=socket(AF_INET, SOCK_STREAM, 0)) == -1){
		perror("SockeT");
		exit(1);
	}      
	addr.sin_family = AF_INET;
	addr.sin_port = htons(port);
	addr.sin_addr = *((struct in_addr *)rh->h_addr);
	if ((connect(sock,(struct sockaddr *) &addr, sizeof(addr))) ==
0)
		// Port is open
		return 0;
	else
		// Port is close
		return 1;
}

// Invalid usage, display usage information
int Usage(char *ARG) 
{
	fprintf(stderr,"\nUsage: %s <Remote-Host> <Start-Port> <Stop
Port>\n\n", ARG);
	exit(1);
}

// Connect to a MySQL Server
int mysql_connect(int argc, char *argv[])
{
	conn = mysql_init (NULL);
	mysql_real_connect (
		conn,
		// Connect data       
		MYSQL_HOST,
		MYSQL_USER,
		MYSQL_PASS,
		MYSQL_DATABASE,
		// Port
		0,   
		// Socket, use default          
		NULL,
		// Flags, None
		0
	);
};

// Close connection to a mysql server
int mysql_disconnect() 
{
	mysql_close(conn);
}