MySQL driver failed to install

[fpouw]

A recent install of GRASS7 is missing the MySQL driver. The result of db.driver does not list 'mysql' it and the db.connect command (executed without a driver specified) returns an error that 'mysql' is out of the domain of accepted values.

[martinl]

Right, WinGRASS is currently built without mysql support, see build log (1)

(1) ​http://wingrass.fsv.cvut.cz/grass70/x86_64/logs/log-r68516-175/package.log

[neteler]

Replying to martinl:

Right, WinGRASS is currently built without mysql support, see build log (1)

(1) ​http://wingrass.fsv.cvut.cz/grass70/x86_64/logs/log-r68516-175/package.log

The log says

"checking whether to use MySQL... no"

Is it a matter of enabling it in the configuration or more complex issues?

[martinl]

Replying to neteler:

Is it a matter of enabling it in the configuration or more complex issues?

I am planning to take a look on this issue. But first of all I need to fix issued related to the building server (grass72).

[martinl]

In 68620:

wingrass: add mysql_config (see #3047)

[martinl]

In 68621:

wingrass: enable mysql support (see #3047)

[martinl]

In 68653:

wingrass: disable mysql support (broken build), see #3047 for details

[martinl]

The MYSQL support has been disabled due to compilation errors

C:/OSGeo4W64/include/mysql.h:64:19: error: unknown type name 'SOCKET'
 #define my_socket SOCKET
                   ^

I hope will be fixed later.

[neteler]

Replying to martinl:

The MYSQL support has been disabled due to compilation errors

C:/OSGeo4W64/include/mysql.h:64:19: error: unknown type name 'SOCKET'
 #define my_socket SOCKET
                   ^

For a potential solution, see

​http://www.technowise.in/2009/08/fixing-socket-does-not-name-type-error.html

[neteler]

Replying to neteler:

Replying to martinl:

The MYSQL support has been disabled due to compilation errors

C:/OSGeo4W64/include/mysql.h:64:19: error: unknown type name 'SOCKET'
 #define my_socket SOCKET
                   ^

For a potential solution, see

​http://www.technowise.in/2009/08/fixing-socket-does-not-name-type-error.html

Did anyone try the solution? Citation:

To fix this error, just include winsock.h before including mysql.h header 
as shown below:

#include <winsock.h>
#include <mysql.h>

[neteler]

Ticket retargeted after milestone closed

[neteler]

Ticket retargeted after milestone closed

[neteler]

Ticket retargeted after milestone closed