RE: [Help-glpk] Problems with making glpk communicate with mysql on mac os 10.6

[Maria Vasardani]

Andrew, thank you very much for your reply! I did what you suggested, and even though I had different errors now showing after execution of 'make', at least I don't think there were any related to mysql. However, when I try to run the transp_mysql.mod example provided with the package, I get this:

GLPSOL: GLPK LP/MIP Solver, v4.44
Parameter(s) specified in the command line:
 -m transp_mysql.mod
Reading model section from transp_mysql.mod...
Reading data section from transp_mysql.mod...
71 lines were read
Reading plants...
unable to open library libmysqlclient.dylib
file not found
transp_mysql.mod:17: error on opening table plants
MathProg model processing error


I have run the necessary script and created the database and tables, and MySQL is up and running. Would you happen to know what I get this message?

Thank you very much in advance.

Gispider

> Subject: Re: [Help-glpk] Problems with making glpk communicate with mysql on mac os 10.6
> From: address@hidden
> To: address@hidden
> CC: address@hidden
> Date: Sun, 14 Nov 2010 21:26:52 +0300
>
> > I am on Mac OS 10.6 and I have installed MySQL 5.1.52 and it works fine.
> > I am trying to make glpk communicate with it, in other words, I am trying
> > the --enable-mysql option in the ./configure script.
> >
> > However, when I run make, I get all sorts of errors like:
> > lpsql.c:1102:20: error: my_sys.h: No such file or directory
> > glpsql.c:1103:19: error: mysql.h: No such file or directory
> > glpsql.c:1108: error: expected specifier-qualifier-list before ‘MYSQL’
> > .......
> > etc.
> >
> > I think, from all the searching I have been doing, that the compiler cannot
> > find the header files for MySQL???
> > In this case, what can I do?
> >
> > I have used the locate command, and have found these files, but I don't know
> > how to use this information.
> >
>
> Try the following:
>
> make CFLAGS=-I/foo/bar/include
>
> where '/foo/bar/include' is a directory that contains mysql.h .
>
> For more details about configuring/installing see file INSTALL.
>