Page 1 of 1

SSL file with spaces

Posted: 06.02.2012, 13:25
by tintinux
Hi

I can successfully connect to MySql with a SSL certificate, but not when the file is in a folder containing spaces.

Code: Select all

MYSQL_SSL=TRUE
MYSQL_SSL_CA=/tmp/ca-cert.pem
is Ok.

Code: Select all

MYSQL_SSL=TRUE
MYSQL_SSL_CA=/tmp/test folder/ca-cert.pem
returns : "SQL error : SSL Connection Error" (of course the .pem file was moved in the folder...)

I have tried quotes and double quotes around the file name, %20 instead of the space, with no better results...

Is there a workaround ?

Regards

Tintinux

Posted: 01.03.2012, 01:19
by mdaems
Hi Tintinux,

I have no idea what the reason is or could be.
Some guesses:
- zeoslib strips part of the filename when spaces are included. Debugging the zeoslib SSL code for mysql can show this. See the ZDbcMysql.pas unit. In this case : send us a patch ith the fiw please
- mysql expects a special format when passing such filenames. Probably you'll find more info on this in the C-connector documentation (~libmysql.dll) or mysql specific forums

Mark