HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   Installation/Configuration (http://www.howtoforge.com/forums/forumdisplay.php?f=16)
-   -   mysql password problem (http://www.howtoforge.com/forums/showthread.php?t=1581)

brianetilley 7th December 2005 23:57

mysql password problem
 
So close...But it choked at the mysql password. I entered 'localhost' for server.
'root' for user...and the mysql password I created when installing the base system. Should I have used 'debian-sys-maint' for user? Should I use 'ispconfigdb' for database. Should I enter the static IP address I used during the base install for ISPConfig web? Please explain the proper syntax for this step. Thank you.

Brian

falko 8th December 2005 00:35

Quote:

Originally Posted by brianetilley
So close...But it choked at the mysql password. I entered 'localhost' for server.

Correct.
Quote:

Originally Posted by brianetilley
'root' for user...

Correct.

Quote:

Originally Posted by brianetilley
and the mysql password I created when installing the base system. Should I have used 'debian-sys-maint' for user?

No, root is correct. Make sure you make no typos when you type in the password.
Quote:

Originally Posted by brianetilley
Should I use 'ispconfigdb' for database.

Any name you like and that doesn't exist as database yet.

Quote:

Originally Posted by brianetilley
Should I enter the static IP address I used during the base install for ISPConfig web?

As host and domain you type in the FQDN you want to use for the ISPConfig web interface (normally your servers hostname). You have to make sure that the FQDN exists in DNS and points to your ISPConfig server, and your firewall must allow pings to the server.
If you don't have a DNS record for your FQDN, you can leave the host empty and enter your system's IP address as domain.

brianetilley 8th December 2005 03:59

I started from the beginning...and got the same results. The password choked. This is the error message:
ERROR:1045: Access denied for user:'root@localhost' (Using password:YES)
ERROR: The provided MySQL password is wrong! The installation routine stops here! Is there a way to reconfigure/edit the MySQL password? Thank you...

Brian

till 8th December 2005 10:43

Do you have any special chars in your password? Did you have a look at the debian howtos for ISPConfig? It is described there how you can set the an mySQL password:

http://www.ispconfig.org/documentation.htm

mysqladmin -u root password yourrootsqlpassword

falko 8th December 2005 12:04

Quote:

Originally Posted by till
mysqladmin -u root password yourrootsqlpassword

If you have set another MySQL password before, the command to set a new password would be:

Code:

mysqladmin -u root -p<current_password> password <new_password>
(there's no space between -p and <current_password>!)

brianetilley 10th December 2005 01:10

Changing the password worked. I have tried to find some info about the use of special characters in MySQL passwords with no luck. Do you have a link to the appropriate docs? After a successful install of ispconfig I can not login to the ispconfig interface. Do I need to install a browser on the server to access the interface? Or do I use the IP address I used on the base install for a DNS lookup? Thank you...

till 10th December 2005 12:52

Quote:

Originally Posted by brianetilley
Changing the password worked. I have tried to find some info about the use of special characters in MySQL passwords with no luck. Do you have a link to the appropriate docs? After a successful install of ispconfig I can not login to the ispconfig interface.

Please describe it a bit more detailed. Wich uRL did you use? Is it the URL that you entered during the setup? Did you use username: admin password: admin?

Quote:

Do I need to install a browser on the server to access the interface?
No.

Quote:

Or do I use the IP address I used on the base install for a DNS lookup?
No. Only if the Server domain is not propagated in DNS yet.

brianetilley 10th December 2005 15:41

These are the values returned by the system;

hostname:www.earthstationproductions.com
dns domainname:localdomain
hostname --fgdn:localhost.localdomain

I used a staticIP address given to me from my ISP when installing ISPConfig. I tried using Lynx and it logged me in, I entered 'admin' for user, but it would not accept 'admin' for password...the cursor jumps out of the field. Do I need to set the nameservers on my domain registrar's site to point to the static IP...is the static IP the IP of the DNS set up by ISPConfig? I apologize for my ignorance of these issues...the more I research this the more confusing it gets...but I know I am only a few keystrokes away from success. Thanks for the patience.

Brian

falko 10th December 2005 16:06

When you try to log in, you have to use the same URL that you typed in during setup and that is now in the file /home/admispconfig/ispconfig/lib/config.inc.php.

brianetilley 10th December 2005 17:01

From the file 'config.inc.php'
["server_url"] = "https://www.earthstationproductions.com:81";

When I try to login from another machine with URL 'https://www.earthstationproductions.com:81' I get a not found error.
When I use the IP address I get a connection refused error.

Using Lynx on the server I get 'SSL error: Can't find common name in certificate -Continue ? (y). When I continue the login page comes up as follows;

[login_logo.png]
Here you can login:
Username:_ _ _ _ _ _ _ _ _ _
Password:_ _ _ _ _ _ _ _ _ _
Login

Using 'admin' for both fields returns returns another SSL error: Can't find common name in certificate - Continue? (y)
refresh URL not absolute

I hope this helps....

Brian


All times are GMT +2. The time now is 10:24.

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