MySQL and shared-memory connection

[patrikd]

Hi,

has anybody successfully got connected to a mysql server using a shared mem connection? I can't get it work. Connecting via tcp works fine but if I set the sql.ini to "skip-networking" and set the parameters for a shared mem connection I get the error:
"Can't connect to MySQL server on 'localhost' (10061) QMYSQL: Unable to connect"

My sql.ini settings:

skip-networking
shared-memory
shared-memory-base-name=TestApp
enable-named-pipe
socket=mysql-TestApp.sock
bind-address=127.0.0.1
port=3333
init-connect="SET NAMES UTF8"
basedir="../"
datadir="../Data/"
default-character-set=UTF8
collation_server=utf8_unicode_ci
default-storage-engine=INNODB
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

skip-networking
shared-memory
shared-memory-base-name=TestApp
enable-named-pipe
socket=mysql-TestApp.sock
bind-address=127.0.0.1
port=3333
init-connect="SET NAMES UTF8"
basedir="../"
datadir="../Data/"
default-character-set=UTF8
collation_server=utf8_unicode_ci
default-storage-engine=INNODB
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

To copy to clipboard, switch view to plain text mode 

Client code:

QSqlDatabase::setConnectOptions("protocol=memory;shared-memory-base-name=TestApp;")

QSqlDatabase::setConnectOptions("protocol=memory;shared-memory-base-name=TestApp;")

To copy to clipboard, switch view to plain text mode 

Database: MySQL v. 5.1.26 running as standalone
Qt: 4.3.4

Any ideas?

Thanks,
Patrik

[patrik08]

Hi,

Client code:

QSqlDatabase::setConnectOptions("protocol=memory;shared-memory-base-name=TestApp;")

QSqlDatabase::setConnectOptions("protocol=memory;shared-memory-base-name=TestApp;")

To copy to clipboard, switch view to plain text mode 

Database: MySQL v. 5.1.26 running as standalone

Thanks,
Patrik

QSqlDatabase::setConnectOptions on QMysql only this option you can set..

CLIENT_COMPRESS
CLIENT_FOUND_ROWS
CLIENT_IGNORE_SPACE
CLIENT_SSL
CLIENT_ODBC
CLIENT_NO_SCHEMA
CLIENT_INTERACTIVE
UNIX_SOCKET

read my answer on German Forum...
http://www.qtforum.de/forum/viewtopic.php?p=36454#36454