It works on on-rev because they have a symbolic link in place to link from /tmp/mysql.sock to wherever the real file is. Now, if you are on a shared host such as Dreamhost, there is a big chance that this symbolic link does not exist and since you are not root, you will not be allowed to create it, so, you will not be able to connect to mysql.
I am lucky that I have my own VPS and know enough of Linux to spot this problem and fix it on my own but this is the kind of silly thing that we should not be facing. If the engine is looking for a specific file we should always have a way to override it, much like we can with revSetDatabaseDriversPath and things like that. Another option was if the mysql.so thing would pick the UNIX socket file from mysqld who will always point to the correct place... actually you need both, you need the engine to look into the configured place in mysqld and also to be able to override it. On Tue, Sep 6, 2011 at 4:08 PM, Bob Sneidar <b...@twft.com> wrote: > I am using On-Rev SQL with a direct connection. I am using 4.6.3. It seem > to be working fine for me. > > Bob > > > On Sep 5, 2011, at 10:06 AM, Andre Garzia wrote: > > > Folks, > > > > I've updated the quality centre with a new bug report: > > > > http://quality.runrev.com/show_bug.cgi?id=9712 > > > > As explained in there, LiveCodeServer tries to connect to /tmp/mysql.sock > > which is not always the correct location. The mysqld daemon will tell the > > client what socket file to use but LiveCode server is not using that > file. > > LiveCode Server 3.5 works fine but the new 4.6.x series does not. > > > > I call on the users of these lists to vote for this bug report. This bug > has > > a workaround with symbolic links but this linking can't be done for users > on > > shared hosts, so I think it qualifies for a severe bug. > > > > Cheers > > andre > > > > -- > > http://www.andregarzia.com All We Do Is Code. > > _______________________________________________ > > use-livecode mailing list > > use-livecode@lists.runrev.com > > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > > http://lists.runrev.com/mailman/listinfo/use-livecode > > > _______________________________________________ > use-livecode mailing list > use-livecode@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode > -- http://www.andregarzia.com All We Do Is Code. _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode