Opened 3 years ago

Last modified 11 days ago

#3047 new defect

MySQL driver failed to install

Reported by: fpouw Owned by: grass-dev@…
Priority: normal Milestone: 7.8.2
Component: Database Version: 7.0.4
Keywords: mysql driver, wingrass Cc:
CPU: Unspecified Platform: MSWindows 7

Description

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.

Change History (14)

comment:1 Changed 3 years ago by martinl

Keywords: wingrass added

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

comment:2 in reply to:  1 ; Changed 3 years ago by 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?

comment:3 in reply to:  2 Changed 3 years ago by 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).

comment:4 Changed 3 years ago by martinl

In 68620:

wingrass: add mysql_config (see #3047)

comment:5 Changed 3 years ago by martinl

In 68621:

wingrass: enable mysql support (see #3047)

comment:6 Changed 3 years ago by martinl

In 68653:

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

comment:7 Changed 3 years ago by 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.

comment:8 in reply to:  7 ; Changed 3 years ago by 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

comment:9 in reply to:  8 Changed 3 years ago by 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>

comment:10 Changed 3 years ago by neteler

Milestone: 7.0.57.0.6

comment:11 Changed 21 months ago by neteler

Milestone: 7.0.67.0.7

comment:12 Changed 7 months ago by martinl

Milestone: 7.0.77.8.0

comment:13 Changed 2 months ago by neteler

Milestone: 7.8.07.8.1

Ticket retargeted after milestone closed

comment:14 Changed 11 days ago by neteler

Milestone: 7.8.17.8.2

Ticket retargeted after milestone closed

Note: See TracTickets for help on using tickets.