Forum

Welcome to ProjeQtOr new Forum. We migrated old forum to the new website.
You will find all your posts here, with your usual account.
Just one point : you’ll have to reinitialize your password. Use “Lost password” feature.

[SOLVED] Unable to ...
 
Notifications
Clear all

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

14 Posts
3 Users
0 Reactions
11.5 K Views
(@catalystdroid)
Posts: 38
Active Member
Topic starter
 
[#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:

 


 
Posted : 25 Jul 2023 22H30
babynus
(@babynus)
Posts: 14966
Main Contributor 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.


 
Posted : 26 Jul 2023 11H01
(@catalystdroid)
Posts: 38
Active Member
Topic starter
 

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.


 
Posted : 28 Jul 2023 17H18
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

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


 
Posted : 28 Jul 2023 17H20
(@cecile)
Posts: 161
Active Member 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.

 


 
Posted : 28 Jul 2023 17H32
(@catalystdroid)
Posts: 38
Active Member
Topic starter
 

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 ?


 
Posted : 28 Jul 2023 17H35
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

Just check Technical prerequisites as defined on the website.


 
Posted : 28 Jul 2023 17H42
(@catalystdroid)
Posts: 38
Active Member
Topic starter
 

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 ?


 
Posted : 28 Jul 2023 17H45
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

Yes, it is highly advised to use UTF8


 
Posted : 28 Jul 2023 19H56
(@catalystdroid)
Posts: 38
Active Member
Topic starter
 

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'


 
Posted : 28 Jul 2023 20H03
babynus
(@babynus)
Posts: 14966
Main Contributor 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. 


 
Posted : 30 Jul 2023 18H39
(@catalystdroid)
Posts: 38
Active Member
Topic starter
 

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.


 
Posted : 01 Aug 2023 17H35
(@cecile)
Posts: 161
Active Member 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).


 
Posted : 02 Aug 2023 17H15
(@catalystdroid)
Posts: 38
Active Member
Topic starter
 

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

So I should be good.  Correct? 


 
Posted : 02 Aug 2023 19H39
Share:

Scroll to Top