Forum

[SOLVED] Unable to ...
 
Notifications
Retirer tout

[SOLVED] Unable to Access MySQL DB after changing root password with phpmyadmin

14 Posts
3 Utilisateurs
0 Reactions
11.5 {numéro}K Vu
(@catalystdroid)
Posts: 38
Active Member
Début du sujet
 
[#8982]

When I attempt to access mysql from cli using the below:

mysql -u root -p 

I receive the following error:

ERROR 1524 (HY000): Plugin '*717792008D019DA9A8E4133215A0AECDFBE6847F' is not loaded

 

I am also getting the following error when trying to access phpmyadmin:

 


 
Posté : 25 Juil PM 22:077
(@babynus)
Posts: 14952
Membre Admin
 

Your PHP installation is incomplete.
Missing php-mysql or php-pdo or php-pdo-mysql or any other (message is not clear).
This is not a projeqtor issue, itr is pure PHP issue, I'm affraid we cannot help much.


 
Posté : 26 Juil AM 11:077
(@catalystdroid)
Posts: 38
Active Member
Début du sujet
 

Culprit seemed to be php as you indicated.

Removed older version of PHP to PHP Version 7.1.3 and problem resolved.

Thank you for the insight.


 
Posté : 28 Juil PM 17:077
(@babynus)
Posts: 14952
Membre Admin
 

Really, PHP 7.1.3 is a very old version and should not be used in production anymore.


 
Posté : 28 Juil PM 17:077
(@cecile)
Posts: 160
Membre Admin
 

Hello CatalystDROID,
You seem to encounter many issues with your web server installation and therefore, issues with ProjeQtOr.
Maybe you can have a look at this page concerning the compatibilities and technical requirements :
https://www.projeqtor.org/en/product-en/technical-en/64-setup-en/412-product-prerequisites-en
And also this one about security during the setup-up
https://www.projeqtor.org/en/product-en/technical-en/64-setup-en/413-product-setup-en

With all those information, you should be able to set up a correct web server for your ProjeQtOr instance.

 


 
Posté : 28 Juil PM 17:077
(@catalystdroid)
Posts: 38
Active Member
Début du sujet
 

Currently I am using Projeqtor v10.3.4 and PHP v7.1.3.

Should I upgrade php to a specific version?

Will a new updated php version play nice with Projeqtor v10.3.4 ?


 
Posté : 28 Juil PM 17:077
(@babynus)
Posts: 14952
Membre Admin
 

Just check Technical prerequisites as defined on the website.


 
Posté : 28 Juil PM 17:077
(@catalystdroid)
Posts: 38
Active Member
Début du sujet
 

I see the following:

Recommended MySql configuration (in my.ini ou my.cnf) :
innodb-default-row-format=dynamic
collation when creating the database :
For ProjeQtOr = V10.0 : utf8mb4_general_ci

Should I be using utf8mb4_general_ci instead of the latin1_general_ci ?


 
Posté : 28 Juil PM 17:077
(@babynus)
Posts: 14952
Membre Admin
 

Yes, it is highly advised to use UTF8


 
Posté : 28 Juil PM 19:077
(@catalystdroid)
Posts: 38
Active Member
Début du sujet
 

But i needed to change it to 'latin1_general_ci' to resolve the below errors and the Global Planning. Will I get these errors again if I change it to 'utf8mb4_general_ci' ?

** ERROR ** [V10.3.4] Exception-[42000] SQLSTATE[42000]: Syntax error or access violation: 1253 COLLATION 'utf8mb4_general_ci' is not valid for CHARACTER SET 'latin1'

** ERROR ** [V10.3.4] Exception-[42000] SQLSTATE[42000]: Syntax error or access violation: 1253 COLLATION 'utf8_general_ci' is not valid for CHARACTER SET 'latin1'


 
Posté : 28 Juil PM 20:077
(@babynus)
Posts: 14952
Membre Admin
 

The parameter you changed is just to tell projeqtor the encoding of your DB.
If your DB is Latin, you must specifylatin.
DB (not th9e parameter in proj=eqtor, the DBengine) should be encodeded UTF8MB4, then projeqtor parameter is useless. 


 
Posté : 30 Juil PM 18:077
(@catalystdroid)
Posts: 38
Active Member
Début du sujet
 

Ok. But what is confusing to me is why it was looking to use a latin1 CHARACTER SET in the first place. Is this a default ? I did not make any changes to reflect this at the DB level.

What can I do/check to make sure I am setup properly?

Should I check/update something in mysql setup? What elements/values should I have in any projeqtor config files etc?

Thanks again for any assistance.


 
Posté : 1 Août PM 17:088
(@cecile)
Posts: 160
Membre Admin
 

Hello,
That's exactly what we are telling you from the beginning.
As it's explained in the documentation and in our website (I already gave you the useful links), your database should be encoded in UTF8mb4, just like Babynus told you.
That's part of your mysql setup, even before installing ProjeQtOr on your webserver.
Then, the installation should be automatic, you should not have to change anything in the config files directly (concerning the encoding).


 
Posté : 2 Août PM 17:088
(@catalystdroid)
Posts: 38
Active Member
Début du sujet
 

According to phpmyadmin, I am set to "uft8mb4_general_ci".

So I should be good.  Correct? 


 
Posté : 2 Août PM 19:088
Share:
Retour en haut