PDA

View Full Version : Problem installing ISPConfig, then with MySQL...


ctroyp
25th September 2005, 07:03
Hello, I am having a similar problem with installing ISPConfig...

After entering my MySQL server 'localhost', user 'root', and password 'mypassword', I got booted from the install.

I followed some instruction to change my root password to blank and ran into trouble with the MySQL installation. I landed up uninstalling MySQL and reinstalled it using the instructions from http://www.falkotimme.com/howtos/perfect_setup_fedora_core_4/ , which is how I installed MySQL in the first place. Now when I get to the point where I start the MySQL service, i get:
[root@server1 ~]# /etc/init.d/mysqld start
chown: `mysql:mysql': invalid user
chown: `mysql:mysql': invalid user
Timeout error occurred trying to start MySQL Daemon.
Starting MySQL: [FAILED]

I must have lost something during the uninstall and I am unsure what it was...

I tried adding the mysql user by:
[root@server1 ~]# useradd -d /dev/null -s /bin/false mysql
...no luck still.

Would anyone have any ideas how to fix this? Then I can get back to my original problem with the ISPConfig problem.

I am a newbie, so bare with me. I have setup everything as detailed from http://www.falkotimme.com/howtos/perfect_setup_fedora_core_4/ , and I am running FC4.

Any help is greatly appreciated...thanks!

ctroyp
26th September 2005, 00:45
Disregard...I just reinstalled my O/S. I couldn't figure it out and never got any replies from any of the forums I posted this problem to...

Oh well, maybe it was the best thing to do anyhow.

Now, I hope I can get past the MySQL login problem during the ISPConfig installation. This time, I set the MySQL root pw to blank for now in hopes that it will not error out again.

Will keep you informed, for those interested.

till
26th September 2005, 09:30
It is not nescessary to let the mySQL password blank. Just do not use any special characters. It is safe to use the chars: a-z, A-Z, 0-9 and _ (underscore). There may be many other chars that can be used saefely, bu I've not testd all :D

ctroyp
26th September 2005, 14:33
Thanks for the feedback till. I set the MySQL root password to blank to assure that I wouldn't have any problems during setup of ISPConfig. I finally got ISPConfig running last night.

I initially had a password set that included no special characters. For whatever reason, the ISPCongig install would halt when trying to connect to the MySQL db. It said that root@localhost did not exist (something like that).

Anyhow, now I need to change the password in MySQL from blank. I also need to change it in ISPConfig. Now that everything is running, I am unsure how to do this. Can you offer any instruction?

Thanks!

till
26th September 2005, 14:36
The mySQL password is stored in the ISPConfig configuration file:

/home/admispconfig/ispconfig/lib/config.inc.php

ctroyp
26th September 2005, 14:41
Okay thanks! Is there not a password in MySQL--just ISPConfig?

I spent about an hour on ISPConfig last night. I setup a few accounts and such. It seems very functional and easy to use...

Thanks again!

falko
26th September 2005, 15:46
Okay thanks! Is there not a password in MySQL--just ISPConfig?

I spent about an hour on ISPConfig last night. I setup a few accounts and such. It seems very functional and easy to use...

Thanks again!

You can set your MySQL password on the shell like this:

mysqladmin -u root password yourrootsqlpassword

And then you open /home/admispconfig/ispconfig/lib/config.inc.php and enter your new MySQL password there.

ctroyp
26th September 2005, 16:37
Thanks much Falko...I'll try it later this afternoon.