Getting a 404 error when logging into sqladmin of any domain
If you are getting 404 error while accessing sqladmin page, please follow the two steps shown below.
“%plesk_bin%\websrvmng.exe” –reconfigure-sqladmin
“%plesk_bin%\defpackagemng.exe” –fix –type=sqladmin.mssql
This error is due to incorrect configuration of web admin in IIS.
Error when try to use PHPMyAdmin in the Plesk CP
Sometimes you might get the following error when try to use PHPMyAdmin in Plesk CP:
“#1045 - Access denied for user ‘pma_xxxxxxx’@'localhost’ (using password: YES)”
You can use the following to fix the issue:
Make sure Plesk PHPMyAdmin user exists in mysql.user table and has right password and privileges. User name and password can be found in /usr/local/psa/admin/htdocs/domains/databases/phpMyAdmin/config.inc.php file.
# cd /usr/local/psa/admin
# grep controluser htdocs/domains/databases/phpMyAdmin/config.inc.php
$cfg['Servers'][$i]['controluser'] = ‘USER’;
# grep controlpass htdocs/domains/databases/phpMyAdmin/config.inc.php
$cfg['Servers'][$i]['controlpass'] = ‘PASSWORD’;
# grep pmadb htdocs/domains/databases/phpMyAdmin/config.inc.php
$cfg['Servers'][$i]['pmadb'] = ‘DATABASE’;
Try to login as this user into MySQL from the command line. If the password doesn’t match, update mysql.user table and set ‘PASSWORD’ password for ‘USER’. If such user doesn’t exist in Mysql, create it with commands like:
# mysql -uadmin -p`cat /etc/psa/.psa.shadow`
mysql> use mysql;
mysql> insert into user values (’localhost’,'USER’,password(’PASSWORD’),’N',’N',’N',’N',’N',’N',’N',’N',’N',’N',’N',’N',’N',’N',’N',’N',’N',’N',’N',’N',’N',”,”,”,”,0,0,0);
mysql> INSERT INTO `db` VALUES(’localhost’,'DATABASE’,'USER’,'Y’,'Y’,'Y’,'Y’,'N’,'N’,'N’,'N’,'N’,'N’,'N’,'N’);
mysql> flush privileges;
Replace USER, PASSWORD and DATABASE with the right values from config.inc.php.
Postgresql Error on Plesk
When trying to use Postgresql on Plesk Control Panel >> servers >> Database Servers >> Local PostgreSQL, getting the following error while using the postgresql for the first time.
Unable to rewrite /var/lib/pgsql/data/pg_hba.conf
1
Error on query to PostgreSQL
1
Unable to rewrite /var/lib/pgsql/data/pg_hba.conf
1
0: /usr/local/psa/admin/plib/DatabaseManagerPostgreSQL.php:263DatabaseManagerPostgreSQL-
>createLocalAdminLoginImpl(string ‘admin’, string ‘********’, NULL null)1: /usr/local/psa/
admin/plib/DatabaseManager.php:513DatabaseManager->updateLocalAdmin()2:
/usr/local/psa/admin/plib/DatabaseServerManager.php:229DatabaseServerManager->
updateServer(object of type DatabaseServer)3: /usr/local/psa/admin/htdocs/server/db_server_edit.php:52
This means postgresql is not running and when checking the error logs we can see like this:
#tail -f /usr/local/psa/admin/logs/httpsd_error_log
psql: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket “/tmp/.s.PGSQL.5432″?
sed: can’t read /var/lib/pgsql/data/pg_hba.conf: No such file or directory
#tail -f /var/lib/pgsql/pgstartup.log
postmaster cannot access the server configuration file “/var/lib/pgsql/data/postgresql.conf”:
No such file or directory
Usually this happens when the postgresql database is not properly initialized. For fixing this error, we need to reinitialize the postgrsql database.
# rm -rf /var/lib/pgsql/data
# /etc/rc.d/init.d/postgresql start
Then again go to Plesk Control Panel >> servers >> Database Servers >> Local PostgreSQL and give your
administrator username and password.
Domain creation error in Plesk
When you create a new domain via the Plesk control Panel, sometimes you may receive the following error.
ERROR:
Failed domain creation: Unable to update domain data: Failed mail post-configuration: Can’t create mail domain servie: mailManager->addDomain() failed: mailmng failed: MEAOPO.PostOffice ———————- Debug Info ——————————- 0: c:\Program Files\SWsoft\Plesk\admin\htdocs\domains\create_domain.php:146
This means that there is some issue with the mail server configuration and that has to be repaired.
Run the following command.
cd %plesk_bin%
mchk.exe –all
After executing the above command, check if you are able to create a new domain. If you receive any error again, then run the following command.
The above command will forcefully reset the domain and server wide configuration settings according to the Plesk Database.
Note that the custom settings will be lost after executing this command.
FFmpeg error
After installing FFMpeg , when you execute the command : ffmpeg or ffmpeg -v, you may receive an error.
ffmpeg: error while loading shared libraries: libavformat.so.50:
Resolution :
Execute the following command :
export LD_LIBRARY_PATH=/usr/local/lib:LD_LIBRARY_PATH
But this value will be cleared once you log off that session.
So it is better to save this value in bashrc.
vi .bashrc
LD_LIBRARY_PATH=/usr/local/lib
