mysql/java problem

[mnkeybsness]

so i'm trying to learn a little something about php and mysql. so i went ahead on my powermac, running os x 10.2.4, installed php and mysql. got everything to work. for mysql admin, i am using yoursql. now, my friend wanted to run a small forum for a little ranting on his 10.2.4 server machine. so we downloaded phpbb2 just as i had and set it up and everything, but when it comes time to use yoursql to set up the database in mysql, we try to connect and we get the following error

java.net.ConnectException: Connection refused

can anyone help?

 

[mnkeybsness]

also of note is that when i use the mysql manager in the utilities folder, mysql seems to NOT start up. i can click the start button, but nothing happens. the start button is still clickable.

 

[macktheknife]

What did you put as your server? I connected to my local MySQL database using YourSQL through "localhost:3306" as the server. Give it a shot.

 

[mnkeybsness]

still the same problem...i was actually trying both 127.0.0.1 and localhost

 

[macktheknife]

Were you able to start up MySQL successfully? You should be able to start MySQL up through Terminal.

 

[Rower_CPU]

I'd recommend this tutorial/download for getting MySQL running on OS X.

http://www.entropy.ch/software/macosx/mysql/

 

[mnkeybsness]

actually, that's the tutorial i used!

but i'm still having that weird java error. and really, i'm not seeing how java has anything to do with mysql???

 

[Rower_CPU]

Not directly, but if the java is trying to connect to MySQL and it's not running then you'll get an error message.

Have you run "top" to check if mysqld is running?

 

[mnkeybsness]

yah i checked "top"-

mysql is not running.

what's the deal?

 

[macktheknife]

Originally posted by mnkeybsness
yah i checked "top"-

mysql is not running.

what's the deal?

Start up MySQL with the command "mysqld" in Terminal. Are you getting an error? If so, what does it say?

 

[mnkeybsness]

i believe you meant the command "mysql"

this is my error...

ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)

 

[Rower_CPU]

Did you set up a mysql user, like the tutorial specifies?

Also, make sure you're in the right directory when you use the "sudo ./bin/mysqld_safe &" command to start it up. I know I goofed on that a couple times and MySQL wouldn't start.

 

[mnkeybsness]

one more errors i'm finding...

when trying to start the web server, i get this error:

Syntax error on line 368 of /etc/httpd/httpd.conf:
Cannot add module via name 'mod_php4.c': not in list of loaded modules
/usr/sbin/apachectl start: httpd could not be started

 

[Rower_CPU]

Originally posted by mnkeybsness
one more errors i'm finding...

when trying to start the web server, i get this error:

Is that a line you added in httpd.conf, or just something you uncommented?

 

[mnkeybsness]

that's a line from when i try to update the php module...i think

 

[Rower_CPU]

It's when Apache tries to load the PHP module, but it's not finding it.

 

[mnkeybsness]

okay, well i've tried to reinstall php and still the same thing

 

[Rower_CPU]

Did you install a more recent version of PHP?

The one that's included has always worked fine for me.

 

[mnkeybsness]

yah...i did

is there any way to revert back?

 

[Rower_CPU]

The only thing that comes to mind is to do a clean install. Not great, but it'll do the trick.

 

[mnkeybsness]

worst idea EVER...besides that i can't unless i want to do about 200mbs of software updates.

if your php works, couldn't you just send me the php folder from you drive?

 

[Rower_CPU]

I don't believe that there's any one PHP folder. It's several files between Apache config and everything else.

Sorry I can't do anything more for you at this point.

 

[NavyIntel007]

Let me tell you how fun SQL is. I have an assignment of an airline database. 9 tables each with multiple attributes and 5 attributes per table. 45 entries.... ouch.

 

[macktheknife]

mnkeybsness:

Assuming you installed PHP correctly, I can send you my httpd.conf file for you to compare and look at. Just PM me your e-mail address.

BTW, here's a FAQ from Marc Liyanage with some answers to some common MySQL problems:

http://www.entropy.ch/software/macosx/mysql/#faq

 

[mnkeybsness]

another problem i have encountered...and this is just today, AFTER we re-installed os x server and went through all the updates. this time i didn't update php or mysql.

there were tabs here to be able to turn on stuff for the server last night...and now there are no tabs. and YES, we did configure the server for web, file, mail, qt streaming, etc...