Re: mysql.sock location

2013-08-24 Thread Stuart Henderson
On 2013-08-24, Guy Ferguson guyfergu...@tpg.com.au wrote: Hmm - ok, I actually just went to that path (/usr/local/share/doc/pkg-readmes/) and there are 4 files, one of which is a mysql-server-5.x.xx..but it's only 1325 bytes, and certainly no comments from users like ajacoutot@. I

Re: mysql.sock location

2013-08-24 Thread Chris Cappuccio
Gilbert Sanford [gilbertz@gmail.com] wrote: You're welcome. Since the OpenBSD documentation is clear and precise, any cloud of confusion must be a product of my own defective thinking. So I keep going back to the documentation (I stay off Google for OpenBSD research) to push it in and

Re: mysql.sock location

2013-08-24 Thread Gilbert Sanford
You are spot on in your observation that MySQL is not OpenBSD. I used the lesson I learned in that succinct assertion to realize the distinction between a pkg-readme and a manual page, i.e., a pkg-readme is not a manual page, even if an OpenBSD developer wrote the pkg-readme! Please pardon me

Re: mysql.sock location

2013-08-24 Thread Gilbert Sanford
On Fri, Aug 23, 2013 at 10:06 PM, Guy Ferguson guyfergu...@tpg.com.au wrote: Hmm - ok, I actually just went to that path (/usr/local/share/doc/pkg- readmes/) and there are 4 files, one of which is a mysql-server-5.x.xx..but it's only 1325 bytes, and certainly no comments from users like

Re: mysql.sock location

2013-08-23 Thread Guy Ferguson
liviu, At last, I get your name right, if a little under-capitalised. Your help was the first step in maybe a dozen or so that got the site back up. So thank you kindly for that. Just some minor linking to outside the chroot and it'll be perfect. But thanks for the help. guy On 19/08/2013

Re: mysql.sock location

2013-08-23 Thread Gilbert Sanford
The instructions in /usr/local/share/doc/pkg-readmes/mysql-server-5.1.xx have always worked for me . . . very handy reference with specific instructions from ajacoutot@ on Running mysql-server-5.1.xx on OpenBSD. Gilbert On Fri, Aug 23, 2013 at 4:34 AM, Guy Ferguson guyfergu...@tpg.com.au

Re: mysql.sock location

2013-08-23 Thread Stuart Henderson
On 2013-08-23, Guy Ferguson guyfergu...@tpg.com.au wrote: liviu, At last, I get your name right, if a little under-capitalised. Your help was the first step in maybe a dozen or so that got the site back up. So thank you kindly for that. Just some minor linking to outside the chroot and

Re: mysql.sock location

2013-08-23 Thread Guy Ferguson
Hmm - ok, I actually just went to that path (/usr/local/share/doc/pkg-readmes/) and there are 4 files, one of which is a mysql-server-5.x.xx..but it's only 1325 bytes, and certainly no comments from users like ajacoutot@. I mean, there are maybe two or three sugegstions about changing the

Re: mysql.sock location

2013-08-23 Thread Gilbert Sanford
Since you said you were new to OpenBSD, I trust the length of this post is justified, and I'm not offending others on this list. I've been using OpenBSD around 5 years now, but I had not subscribed or ever posted anything to @misc until your post. Actually, I've never participated in any mailing

Re: mysql.sock location

2013-08-23 Thread Gilbert Sanford
You're welcome. Since the OpenBSD documentation is clear and precise, any cloud of confusion must be a product of my own defective thinking. So I keep going back to the documentation (I stay off Google for OpenBSD research) to push it in and push out the misunderstanding. I always figured @misc

Re: mysql.sock location

2013-08-23 Thread Guy Ferguson
Gilbert, Thanks very much for supplying the text of your readme. In mine, v5.1.68, which I am pretty sure was the latest version on i386 about tow weeks ago, all the text beginning with the heading chrooted daemons and MySQL socket = ...does not exist. SO

Re: mysql.sock location

2013-08-18 Thread Liviu Daia
On 18 August 2013, Guy Ferguson guyfergu...@tpg.com.au wrote: [...] BUt I am trying to handle the chroot issue by using a hack I found online: ### in /etc/rc.local: # mysql server if [ -x /usr/local/bin/mysqld_safe ] ; then su -c mysql root -c

Re: mysql.sock location

2013-08-18 Thread Kārlis Miķelsons
Broken record: linking only works until you restart the server manually, as mysqld removes the socket and re-creates it when starting. The location of the socket is configured in /etc/my.cnf. To use mysql with chrooted Apache / Nginx either use TCP connections, or set both /etc/my.cnf and

Re: mysql.sock location

2013-08-18 Thread Ville Valkonen
ehm.. 127.0.0.1 == localhost On Aug 18, 2013 12:06 PM, Kārlis Miķelsons karlis.mikels...@lf.lv wrote: Broken record: linking only works until you restart the server manually, as mysqld removes the socket and re-creates it when starting. The location of the socket is configured in

Re: mysql.sock location

2013-08-18 Thread Otto Moerbeek
On Sun, Aug 18, 2013 at 01:29:14PM +0300, Ville Valkonen wrote: ehm.. 127.0.0.1 == localhost yes, but if you use 127.0.0.1 you force a tcp connection and no unix domain socket is even needed. -Otto On Aug 18, 2013 12:06 PM, K??rlis Mi??elsons karlis.mikels...@lf.lv wrote:

Re: mysql.sock location

2013-08-18 Thread Guy Ferguson
Livia, Thanks for your help. I modded the /etc/my.cnf to add in the extra /run directory. A few other tweaks here and there and i can now get a test.php to connect to the default host mysql ($conn=mysql_connect...) So now i'm confident that mysql is working and connectable...I just ahve to

Re: mysql.sock location

2013-08-18 Thread Liviu Daia
On 18 August 2013, Guy Ferguson guyfergu...@tpg.com.au wrote: Livia, If you want to address me by name, s/Livia/Liviu/ please. It might not be much, but it's my name, and I kind of became attached to it over the years. :) Thanks for your help. I modded the /etc/my.cnf to add in the

Re: mysql.sock location

2013-08-18 Thread Ville Valkonen
fair enough. thanks for the clarification. On 18 August 2013 14:13, Otto Moerbeek o...@drijf.net wrote: On Sun, Aug 18, 2013 at 01:29:14PM +0300, Ville Valkonen wrote: ehm.. 127.0.0.1 == localhost yes, but if you use 127.0.0.1 you force a tcp connection and no unix domain socket is even

Re: mysql.sock location

2013-08-18 Thread Matthew Weigel
On 8/18/2013 5:29 AM, Ville Valkonen wrote: ehm.. 127.0.0.1 == localhost http://dev.mysql.com/doc/refman/5.5/en/connecting.html On Unix, MySQL programs treat the host name localhost specially, in a way that is likely different from what you expect compared to other network-based programs. For

mysql.sock location

2013-08-17 Thread Guy Ferguson
Hello, First time user of OpenBSD here. Having issues getting mysql up and running Can I ask you to confirm that in OpenBSD 5.3 mysql.sock should be being created in/var/run/mysql or in/var/mysql? This page

Re: mysql.sock location

2013-08-17 Thread Greg Thomas
Need more info, like exactly how you're checking whether mysql works or not. But from your message you're apparently running into chroot issues: http://www.openbsd.org/faq/faq10.html#httpdchroot On Sat, Aug 17, 2013 at 8:52 PM, Guy Ferguson guyfergu...@tpg.com.auwrote: Hello, First time

Re: mysql.sock location

2013-08-17 Thread Guy Ferguson
Cheers. I'm testing that it's up and running - fstat | grep *: | grep mysql ...which outputs (from memory) a line indicating it works - something like: internet stream tcp .*:3306 So it's running. BUt I am trying to handle the chroot issue by using a hack I found online: