By webmaster-eddie on

I have recently installed aegir and cannot get the server to verify - it always fails with the same error message -

SQLSTATE[28000] [1045] Access denied for user 'root'@'server1.net-speed.com' (using password: YES)
Unable to connect to database server.

I have tried every mysql user with correct passwords and nothing workd.

Of course the platform and site I am trying to verify also fail.

I am using debian squeeze 6 and my web server seems to be working fine. Mysql is up ..

I wonder if I made a fatal mistake when installing aegir.

I am using net-speed.com as main server domain and have called the server itself ( a dedicated server) server1.net-speed.com
and have correctly installed "the perfect server with ... ISPConfig3 etc "

In aegir the server is called server1.net-speed.com - could this be a mistake?

The IP resolves and uname -n correctly gives what it should.

I have been rying for 3 days to get this working - any help, please?

Thanks,

Webmaster Eddie

⋅ Categories: Drupal 7.x

Comments

webmaster-eddie’s picture

webmaster-eddie commented

I have drush 4.5 - and do not seem able to upgrade, and
I cannot determine the version of aegir I am using - I could appreciate help in determining that also - all I know is that neither drush nor aegir will update or upgrade.

Thanks for any help.

Lastly,

I see that my install of aegir is running drupal 6.x and I am developing drupal 7.9x sites - is this a problem? i.e. - I am trying to create drupal 7 .x make and install profiles and am hoping to use aegir to "manage" these - is this ok?

Thanks

ayesh’s picture

ayesh commented

Did you check if mysqli can connect ?
In mysql configuration file, there's a bind ip configuration that restrict access to localhost.

I just washed my hands after an Aegir installation on Debian 6 (auto-install). automatic installation was very easy and didn't take more than 30 mins.

What's new and changing in PHP 8.4

webmaster-eddie’s picture

webmaster-eddie commented

The line referring to localhost in the my.cnf file was and still is commented out.

In my aegir site (net-speed.com) I see that I have 2 databases listed:

localhost

and

server1.net-speed.com

Is this a correct setup? for a webserver that hosts web sites?

When I try to add a new site, it asks me to choose beween them, localhost or server1.net-speed.com and I assule that I must choose server1.net-speed.com as that is the aegir server, however localhost is how processes connect to the mysql database on the server, so this is not clear. Can anyone clarify this?

When I edit the server server1.net-speed.com, should I use for mysql:

root or aegir_root ?

and I assume I use the mysql master password, right?

My hostmaster platform verifies, as does the default drupal 6 site that the aegir install created on the domain net-speed.com

Thanks for any help.

Eddie