Opened 8 years ago

Last modified 5 years ago

#3047 new defect

MySQL driver failed to install

Reported by: fpouw Owned by: grass-dev@…
Priority: normal Milestone: 7.8.3
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 (16)

comment:1 by martinl, 8 years ago

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

in reply to:  1 ; comment:2 by neteler, 8 years ago

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?

in reply to:  2 comment:3 by martinl, 8 years ago

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 by martinl, 8 years ago

In 68620:

wingrass: add mysql_config (see #3047)

comment:5 by martinl, 8 years ago

In 68621:

wingrass: enable mysql support (see #3047)

comment:6 by martinl, 8 years ago

In 68653:

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

comment:7 by martinl, 8 years ago

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.

in reply to:  7 ; comment:8 by neteler, 8 years ago

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

in reply to:  8 comment:9 by neteler, 8 years ago

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 by neteler, 8 years ago

Milestone: 7.0.57.0.6

comment:11 by neteler, 7 years ago

Milestone: 7.0.67.0.7

comment:12 by martinl, 5 years ago

Milestone: 7.0.77.8.0

comment:13 by neteler, 5 years ago

Milestone: 7.8.07.8.1

Ticket retargeted after milestone closed

comment:14 by neteler, 5 years ago

Milestone: 7.8.17.8.2

Ticket retargeted after milestone closed

comment:15 by neteler, 5 years ago

Milestone: 7.8.2

Ticket retargeted after milestone closed

comment:16 by neteler, 5 years ago

Milestone: 7.8.3
Note: See TracTickets for help on using tickets.