Livecode Server MySQL socket

Are you using LiveCode to create server scripts or CGIs?

Moderators: Klaus, FourthWorld, heatherlaine, kevinmiller, robinmiller

Post Reply
elijahlowGA1b54
Posts: 10
Joined: Mon Dec 05, 2011 5:33 pm

Livecode Server MySQL socket

Post by elijahlowGA1b54 » Tue Nov 13, 2012 3:13 pm

The default MySQL socket using livecode server is /tmp/mysql.sock however my server runs mysql socket at /var/run/mysqld/mysqld.sock. How do i change Livecode server to point to /var/run/mysqld/mysqld.sock ?

sturgis
Livecode Opensource Backer
Livecode Opensource Backer
Posts: 1682
Joined: Sat Feb 28, 2009 11:49 pm

Re: Livecode Server MySQL socket

Post by sturgis » Tue Nov 13, 2012 3:53 pm

From the examples in revOpenDatabase

get revOpenDatabase("mysql", "localhost", "dbName", myUsr, myPass, false, "/var/mysql.sock", 1, true) -- change "/var/mysql.sock" to point to whatever location.


Also shows this..

socket - (MySQL Only) A string specifying the socket or named pipe the driver should use to connect with. If empty, the default for the host will be used.

elijahlowGA1b54
Posts: 10
Joined: Mon Dec 05, 2011 5:33 pm

Re: Livecode Server MySQL socket

Post by elijahlowGA1b54 » Tue Nov 13, 2012 4:37 pm

Thanks, that works :D

Post Reply

Return to “CGIs and the Server”