Welcome Guest, Not a member yet? Register   Sign In
Parallels Plesk thoughts and problems
#1

Sup guys! I just installed Plesk 12 web admin edition on my server and im facing few problems. I hope you can help me out Smile

First of all the mysql wont connect using passwords.
After creating a webspace for a client and set up the database PDO wont connect. You might thing that the username or the password is wrong but it isn't. Even i go login as root on my server and try to login with 

Quote:$ mysql --user=admin --password=<password>


<!--exception 'PDOException' with message 'SQLSTATE[28000] [1045] Access denied for user 'hdphosolutions'@localhost (using password: YES)' in /var/www/vhosts/site.com/httpdocs/index.php:7
Stack trace:
#0 /var/www/vhosts/site.com/httpdocs/index.php(7): PDO->__construct('mysql:host=loca...', 'site', '<password>')
#1 {main}-->

it wont connect. From the Parallels docs you can find that plesk is changind the 'root' to 'admin' the the password is the same with your panel password. Source 1   Source 2

You can however use the command below to connect as root/admin
Quote:mysql -uadmin -p`cat /etc/psa/.psa.shadow`

But who cares? I want to connect through PDO! Nothing is working and nothing can establish a connection. Any ideas?

Apache and Nginx
Of course Plesk is using both webservers at the same time with the power of quantum mechanics and magic.
It passes php scripts thought Nginx and serves static pages through Apache. In my old machine i was using only Nginx which is a pain in the *** to migrade it int to Plesk. Probably i will leave it as it is for now and i will try to change it on a mirror server. However if you have any ideas please let me know!


Migration to MariaDB
After switching to MariaDB i noticed better RAM usage. Since im having only 1GB ram this is important to me! By default Plesk is using MySQL so you have to change it manualy. I found this awesome guide here on how to change the database. Since MariaDB is a fork of MySQL it has 99.99% compatibility.


Create subdomains without using the Panel
So, obviously you can add sudomains through Plesk but what i dont want? Is it possible to add the domains directly on the vhost file?
Reply


Messages In This Thread
Parallels Plesk thoughts and problems - by FlevasGR - 11-16-2014, 08:20 AM



Theme © iAndrew 2016 - Forum software by © MyBB