[BUG] LiveCode server 4.6.3 fails to connect to MySQL UNIX socket file

Andre Garzia andre at andregarzia.com
Tue Sep 6 16:22:53 EDT 2011


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 <bobs at 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 at 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 at 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.



More information about the use-livecode mailing list