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

 

Correct.

Correct.

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

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

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.

 

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

 

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>!)

 

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...

 

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

 

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.

 

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

 

My workstation is running SuSE 9.3 and has the same ISP as the server. There is no firewall/router on either machine. I entered my name in the 'common name' field of the certificate (from the example). I have to leave for 3 hours...

Brian

 

This is what I found out:

There's no A record for www.earthstationproductions.com! You have to create that first.

 

Could you please give me a link to the documentation that explains how to set up the "A" record. Thanks..

Brian

 

I can not access the ispconfig interface, so any changes I make must be from the command line. Please tell me what file to edit...and the correct syntax. Thank you...

Brian

 

Do you mean I should change the nameservers of my Domain Registrar to the IP address in the conf.inc.php file (without the port 81). Is this the same IP address used by the DNS server installed with ISPConfig?

Brian

 

The authoritative name servers for earthstationproductions.com are ns2.dnsexit.com and ns1.dnsexit.com. That's where you have to create the DNS records for your domain ("Managed DNS").

Also have a look here: http://www.howtoforge.com/forums/showpost.php?p=6292&postcount=4