Re: MySQL issues

2005-06-09 Thread John Tate
050611 01:25:37 mysqld started 050611 1:25:37 Can't start server: Bind on TCP/IP port: Address already in use050611 1:25:37 Do you already have another mysqld server running on port: 3306 ? 050611 1:25:37 Aborting Damn process was running in the background. Im sure I checked ps aux. Im off

Re: MySQL issues

2005-06-09 Thread Karsten McMinn
On 6/9/05, John Tate <[EMAIL PROTECTED]> wrote: > I just tried everything here, however it has come to the same problem > again... mysql refuses to start... > > -bash-3.00# mysqld_safe > Starting mysqld daemon with databases from /var/mysql > 050610 21:24:10 mysqld ended whats in the log? (defau

Re: MySQL issues

2005-06-09 Thread John Tate
I just tried everything here, however it has come to the same problem again... mysql refuses to start... -bash-3.00# mysqld_safe Starting mysqld daemon with databases from /var/mysql 050610 21:24:10 mysqld ended On 6/10/05, Matthew S Elmore <[EMAIL PROTECTED]> wrote: > John, > > Do not want yo

Re: MySQL issues

2005-06-09 Thread Matthew S Elmore
John, Do not want you to get frustrated! Here are all the changes I made on my local machine (OpenBSD 3.7/sparc64, but config is the exact same on my OpenBSD 3.7/i386 machines). I normally set everything up before installing mysql. Unless you have databases to save I would recommend starting

Re: MySQL issues

2005-06-09 Thread Matthew S Elmore
For your needs, you can use mostly the default settings. Look in /usr/local/share/mysql There will be several files called my-small.cnf, my-large.cnf, etc. Copy my-small.etc to /etc/my.cnf. Edit the file and change the two lines where it references the mysql socket. Remove any links you made

Re: MySQL issues

2005-06-09 Thread John Tate
Dang how did I not think of that. I am offically captain stupid. On 6/10/05, Jason Crawford <[EMAIL PROTECTED]> wrote: > On 6/9/05, John Tate <[EMAIL PROTECTED]> wrote: > > Right, I created a hardlink of the socket into > > /var/www/mysql/mysql.sock and changed this directive in php.ini to the >

Re: MySQL issues

2005-06-09 Thread Jason Crawford
On 6/9/05, John Tate <[EMAIL PROTECTED]> wrote: > Right, I created a hardlink of the socket into > /var/www/mysql/mysql.sock and changed this directive in php.ini to the > following... > > mysql.default_socket = /var/www/mysql/mysql.sock There is part of the problem, as when apache is chrooted, i

Re: MySQL issues

2005-06-09 Thread John Tate
Alright, I have tried everything (almost) and I still can't get it to work, I created a my.cnf and now mysql refuses to start. What exactly do I have to do to make mysql listen on localhost? On 6/9/05, Jason Crawford <[EMAIL PROTECTED]> wrote: > Well, as long as where ever the mysql unix socket is

Re: MySQL issues

2005-06-09 Thread Per Engelbrecht
John Tate wrote: Right, I created a hardlink of the socket into /var/www/mysql/mysql.sock and changed this directive in php.ini to the following... mysql.default_socket = /var/www/mysql/mysql.sock I however could not find the my.cnf file, where is it on OpenBSD 3.6, I did a "find / | grep my.cn

Re: MySQL issues

2005-06-09 Thread John Tate
Right, I created a hardlink of the socket into /var/www/mysql/mysql.sock and changed this directive in php.ini to the following... mysql.default_socket = /var/www/mysql/mysql.sock I however could not find the my.cnf file, where is it on OpenBSD 3.6, I did a "find / | grep my.cnf" which showed up

Re: MySQL issues

2005-06-08 Thread Chris Zakelj
The answer is in the archives ;) Trust me, I'm the one who caused it to be so. Hint: You'll want to create datadir and socket directives in /etc/my.cnf John Tate wrote: Hey, I am having trouble with phpBB2 running on my OpenBSD 3.6 machine, it cannot connect to the database (Mysql). I am gue

Re: MySQL issues

2005-06-08 Thread Jason Crawford
Well, as long as where ever the mysql unix socket is located is on the same partition as apache, you can just create a hard link for it inside the apache chroot. Another option is to make the mysql server listen on localhost, and have phpBB2 connect via localhost. The benefit to that is that it doe

Re: MySQL issues

2005-06-08 Thread Jason Dixon
On Jun 8, 2005, at 10:10 PM, John Tate wrote: Hey, I am having trouble with phpBB2 running on my OpenBSD 3.6 machine, it cannot connect to the database (Mysql). I am guessing this is because Apache and phpBB2 are running in a chroot environment and cannot connect to the Mysql Server's socket. W