Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 2 > Installation/Configuration

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 25th September 2005, 07:03
ctroyp ctroyp is offline
Senior Member
 
Join Date: Sep 2005
Posts: 292
Thanks: 3
Thanked 2 Times in 1 Post
Default Problem installing ISPConfig, then with MySQL...

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/per...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:
Code:
[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:
Code:
[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/per...fedora_core_4/ , and I am running FC4.

Any help is greatly appreciated...thanks!

Last edited by ctroyp; 25th September 2005 at 07:09. Reason: Forgot to subscribe to this thread.
Reply With Quote
Sponsored Links
  #2  
Old 26th September 2005, 00:45
ctroyp ctroyp is offline
Senior Member
 
Join Date: Sep 2005
Posts: 292
Thanks: 3
Thanked 2 Times in 1 Post
Default

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.
Reply With Quote
  #3  
Old 26th September 2005, 09:30
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,202
Thanks: 829
Thanked 5,420 Times in 4,262 Posts
Default

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
Reply With Quote
  #4  
Old 26th September 2005, 14:33
ctroyp ctroyp is offline
Senior Member
 
Join Date: Sep 2005
Posts: 292
Thanks: 3
Thanked 2 Times in 1 Post
Default

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!
Reply With Quote
  #5  
Old 26th September 2005, 14:36
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,202
Thanks: 829
Thanked 5,420 Times in 4,262 Posts
Default

The mySQL password is stored in the ISPConfig configuration file:

/home/admispconfig/ispconfig/lib/config.inc.php
Reply With Quote
  #6  
Old 26th September 2005, 14:41
ctroyp ctroyp is offline
Senior Member
 
Join Date: Sep 2005
Posts: 292
Thanks: 3
Thanked 2 Times in 1 Post
Default

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!
Reply With Quote
  #7  
Old 26th September 2005, 15:46
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,741 Times in 2,575 Posts
Default

Quote:
Originally Posted by ctroyp
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:

Code:
mysqladmin -u root password yourrootsqlpassword
And then you open /home/admispconfig/ispconfig/lib/config.inc.php and enter your new MySQL password there.
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
The Following User Says Thank You to falko For This Useful Post:
trcinc1 (20th March 2011)
  #8  
Old 26th September 2005, 16:37
ctroyp ctroyp is offline
Senior Member
 
Join Date: Sep 2005
Posts: 292
Thanks: 3
Thanked 2 Times in 1 Post
 
Default

Thanks much Falko...I'll try it later this afternoon.
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
postfix ISPconfig problem matehortua Installation/Configuration 8 3rd September 2006 17:03
Mysql Problem Adding adamluz General 2 20th September 2005 09:33
MySQL issue during install of ISPConfig ricbax Installation/Configuration 4 16th September 2005 09:41
Problems installing ISPConfig Debian Sarge hschel Server Operation 4 22nd August 2005 19:46
Mysql ejs Installation/Configuration 5 12th August 2005 07:01


All times are GMT +2. The time now is 00:53.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.