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:
### in /etc/rc.local:
# mysql server
if [ -x /usr/local/bin/mysqld_safe ] ; then
su -c mysql root -c '/usr/local/bin/mysqld_safe >/dev/null
2>&1 &'
echo -n ' mysql'
mkdir -p /var/www/var/run/mysql
chown www:daemon /var/www/var/run/mysql
# wait for a socket to appear
for i in 1 2 3 4 5 6; do
if [ -S /var/run/mysql/mysql.sock ]; then
break
else
sleep 1
echo -n "."
fi
done
ln -f /var/run/mysql/mysql.sock
/var/www/var/run/mysql/mysql.sock
fi
- trouble is that the line if [ -S /var/run/mysql/mysql.sock....
... and teh symbolic link being created further on refers to a
non-existent path, due to my mysql.sock not being in a subdir of run..
But I'm in full agreement with you that it's a chroot issue - I'm just
trying to get around it.
I'll go and read that article you linked to - thanks.
Guy
On 18/08/2013 15:03, Greg Thomas wrote:
> 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.au>wrote:
>
>> 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
>> (
>> http://www.openbsd.org/cgi-bin/cvsweb/ports/databases/mysql/Makefile?rev=1.217;content-type=text%2Fx-cvsweb-markup
>> )
>> seems to tell me it should be in /var/run/mysql.
>>
>> yet I have just installed OpenBSD 5.3 and there's no mysql directory in
>> /var/run. The mysql.sock appears in /var/mysql
>>
>> Apologies if it's a silly question, but it's preventing me getting my
>> drupal site up and running on this server - all else works well but i
>> can't get mysql to connect....
>>
>> I've installed php 5.2.17p13 and mysql-server-5.1.68
>>
>> If it helps i've made a (small) donation:
>> Confirmation number: 9T459158LW9701138
>>
>> Thanks,
>>
>> Guy
>> Brisbane Australia
>> (When I get it all up and running i will send you the log of my
>> sysconfig for your records, as i read somewhere you like to receive)
>
>
> -----
> No virus found in this message.
> Checked by AVG - www.avg.com
> Version: 2013.0.3392 / Virus Database: 3211/6584 - Release Date: 08/16/13
