I recently tried installing phpbb forum via fantastico and everytime I try I get the error "phpbb critical error" "could not connect to database"
I also get an error connecting to database when I try installing SMF.
I checked the configuration/information and the password and username is all correct.
I got this weird problem with my VPS which has MySQL 4.1.22 running on it. Everything works fine for sometime and then out of a sudden, it stop recognizing the mysql users and refused to allow my PHP scripts to access the database.
It seems that I needed to restart mySQL server to resolve the issue. Then out of the blues, the same problem occurs.
I am running Cpanel on a VPS and there isn't any overloading as the database access is pretty light on my 512mb VPS.
I contacted my web host about the issue and it seems like all they do is to restart the mySQL. This cannot be a solution as it happens at least once or twice a day depending on how soon I could catch the problem.
All the time this problem occurs, the MYSQL Server is still active and working. I can even access it through PHPMyAdmin but not through the scripts.
I just added an hourly crontab so as to restart the MySQL server as a stop gap.
I'm having trouble to connect my site to the MYSQL server. The condition is like this:
My site is running under 5 http servers and all are serve using a mysql server. Recently, I have changed the ip address of all the servers due to the ip migration at the datacenter. After the changes, all my http server having problem to connect to mysql server. It shows the error like below:
Quote:
Error: Can't connect to MySQL server on '123.456.789.2' (4)
Errno.: 2003
However, I tried to establish a connection by placing the http file into mysql server.
Only this site can be shown up correctly. Means, there's actually no problem with the Mysql Server.
Can I know what's the problem actually? I guess there might be some setting of the mysql server blocking the connection from my other servers. Where do we normally do the setting for this? I'm quite new in server stuff and wish to get some advice from you all...
I got this error when i try to active an account in Plesk.
Error: DNSZone::Table::select() failed: no such row in the table
And when o try to solve issue by the following steps,
1) Login to mysql psa database using the plesk administrator password,
cd %plesk_dir%Mysqlin
mysql -h 127.0.0.1 -uadmin -p -P 8306 psa
I got : Unknown psa Database...I'm ensure that database is founded on the server under C:Program Files(86x)MysqlData
Is it possible to make Joomla connect to an external mysql database server?
Meaning, the database for Joomla won't be local, but on another server.
Will it work by just entering the mysql hostname, user and password in Joomla's config?
What issues might arose by doing this?
I had Plesk 10 installed on my openSUSE system (was a low version, maybe 11 or less) and then decided to upgrade to 11.5. So I did distribution upgrades to openSUSE 12.3 and everything went smoothly, except for some services like mysql and php. So I used Plesk autoinstaller to fix the php error and edited an outdated line in mysql configuration and both services ran smoothly!
Then I downloaded Plesk autoinstaller and ran the autoinstaller, but was surprised by this error message:
===> Checking for previous installation ... found.
ERR (3) [panel]: Error during product key mode determination, details: Unable to connect to database: ; trace: #0 /usr/local/psa/admin/plib/functions.php(2821): isPpaKeyRequired()
#1 /usr/local/psa/admin/plib/common_func.php3(11): require_once('/usr/local/psa/...')
#2 /usr/local/psa/admin/plib/api-common/cu.php(5): require_once('/usr/local/psa/...')
#3 /usr/local/psa/admin/sbin/httpdmng(8): include_once('/usr/local/psa/...')
#4 (main)
Unable to connect to database:
- My MySQL version is: 5.5.33 openSUSE package
- I did run mysql_upgrade with my admin username and password (password from: /etc/psa/.psa.shadow) and it worked successfully and fixed all of the errors, I did so after running the auto installer first, but then ran the installer again and the problem was still there
- I can access my web page, but it still doesn't connect to MySQL either.
I believe this is a problem with MySQL, but how can I make sure or detect what exactly the problem is
when I try to access to my plesk I obtain:
ERROR: PleskFatalException: Unable to connect to database: Access denied for user 'admin'@'localhost' to database 'psa' (auth.php:142).
If I restart with ssh /etc/init.d/psa start and I check plesk_11.5.30_reset_instance_data.log
I note: ERROR 1044 (42000): Access denied for user 'admin'@'localhost' to database 'mysql'.
I cant connect to the Database WebAdmin. If I click the icon, i got an "File not found." in the opening tab. Back in Plesk I get the following:
ERROR: PlexkFatalException
Server id is undefined?
I even cant connect via ssh to the mysql part of my server. But the server is running and both of my two wordpress pages run smoothly. I know this page: [URL] .... – but as I sad, cant enter die mysql.
It seems something is wrong with the permissions. I'm on the point where I just want to reset everything database related. But how?
Last night i went to install GD on my server(Linux RH) I went through the process /scripts/easyapache and at the end of it gave me this error
"...Unable to connect to host: 127.0.0.1......Failed......Unable to connect to
host: 127.0.0.1......Fail
ed......Unable to connect to host: 127.0.0.1......Failed......Unable to connect
to host: 127.0.0.1.....
.Failed......Unable to connect to host: 127.0.0.1......Failed......Unable to
connect to host: 127.0.0.1
......Failed......Unable to connect to host: 127.0.0.1......Failed......Unable
to connect to host: 127.
0.0.1......Failed......Unable to connect to host:
127.0.0.1......Failed......Unable to connect to host:
127.0.0.1......Failed......Unable to connect to host:
127.0.0.1......Failed......Unable to connect to
host: 127.0.0.1......Failed......Unable to connect to host:
127.0.0.1......Failed...
The was no content, the test may be unable to connect to 8080 simply because
tomcat is still initila
izing.
You can try to go to
http://localhost:8080/
to manually check it.
-- End test 'Basic tomcat port running test' --
Post check of 'httpd' process Ok
-- End post apache restart tests --
Executing '/scripts/initfpsuexec'
Executing '/scripts/initsslhttpd'
Executing '/scripts/gentomcatlist2'
Compiling report...
Sending report (336 bytes)...
If you want to create a support ticket with cPanel regarding this please
reference 'BuildAP Report
Id': '528932'
Report processed.
You can change how PHP is configured.
As root, simply execute:
/usr/local/cpanel/bin/rebuild_phpconf --help
for more information.
Build Complete
Verbose logfile is at '/usr/local/cpanel/logs/easy/apache/build.1198389830'
Now I am unable to connect to MYSQL databases, MYSQL is still running from what I can see. I have base knowlage of Linux as well.
When I update servers via CLI autoinstaller, I always (afair) get this mysqldump error message:
Code:
Stopping psa... * Stopping Plesk engine pool manager sw-engine-fpm
...done.
done
-- Warning: Skipping the data of table mysql.event. Specify the --events option explicitly.
mysqldump: Got error: 1049: Unknown database 'atmail' when selecting the database
===> Cumulative APS controller database (apsc) upgrade has been started.
===> Cumulative upgrade of APS controller database has been completed.
===> Cumulative Plesk database upgrade (revertable stage) has been started.
===> Preparing Plesk database upgrade (revertable stage).
===> Cumulative upgrade of Plesk database (revertable stage) has been completed.
Reading package lists...
There is no database "atmail" on any of our Plesk servers. Simple solution should be to first check if the DB exists before performing actions on it.As a bonus, perhaps it would be possible to suppress the warning about mysql.event.
