Control Web Panel

WebPanel => CentOS-WebPanel Bugs => Topic started by: Shafire on July 04, 2022, 12:41:39 AM

Title: Almalinux 8.6 phpmyadmin not working end user 2083
Post by: Shafire on July 04, 2022, 12:41:39 AM

Can only login as root for SQL no users can access PHPMyAdmin.
Any advice should i use centos 8 stream end of life in 5 years for the current version? or end of life alamlinux current versions 10 years?

For example:
Welcome to phpMyAdmin Cannot log in to the MySQL server Language English Log in Documentation  mysqli::real_connect(): (HY000/1045): Access denied for user 'seosem'@'localhost' (using password: YES)

Title: Re: Almalinux 8.6 phpmyadmin not working end user 2083
Post by: Shafire on July 04, 2022, 01:30:17 AM

Related post info http://forum.centos-webpanel.com/index.php?action=profile;area=showposts;u=24872
This post is specific to almalinux.

Tried but did not work for me, restarted all services, and ran commands:

sh /scripts/mysql_phpmyadmin_update

sh /scripts/update_cwp

my config file: /usr/local/cwpsrv/var/services/pma/config.inc.php

$i++;
/* Authentication type */
$cfg['Servers'][$i]['auth_type'] = 'cookie';
/* Server parameters */
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['compress'] = false;
$cfg['Servers'][$i]['AllowNoPassword'] = false;

/**
 * phpMyAdmin configuration storage settings.
 */

/* User used to manipulate with storage */
// $cfg['Servers'][$i]['controlhost'] = '';
// $cfg['Servers'][$i]['controlport'] = '';
// $cfg['Servers'][$i]['controluser'] = 'pma';
// $cfg['Servers'][$i]['controlpass'] = 'pmapass';


i noticed pma in that section should this be edited?
URL shows: :2087/pma/ and i see some stuff about pma above?

Tried this and did not work either:

sh /scripts/mysql_pwd_reset

Maybe it is something simple i am missing? Something you can configure in the panel GUI?

Title: Re: Almalinux 8.6 phpmyadmin not working end user 2083
Post by: Shafire on July 04, 2022, 09:00:39 PM

Should i try rockylinux? CWP had some auto error reporting and fixing script, is that still running as i never see any notifications.

Title: Re: Almalinux 8.6 phpmyadmin not working end user 2083
Post by: Shafire on July 04, 2022, 10:52:39 PM

would this info help fix the issue?
https://github.com/phpmyadmin/phpmyadmin/issues/16068

williamdes commented on 10 Apr 2020
@hiimjustin000 you will have to reset the leaked passwords in the previous post because we receive notifications by email and they are archived.

Anyway $cfg['Servers'][$i]['auth_type'] = 'cookie'; should be $cfg['Servers'][$i]['auth_type'] = 'config'; to allow usage of user and password

Title: Re: Almalinux 8.6 phpmyadmin not working end user 2083
Post by: Shafire on July 06, 2022, 06:49:41 PM

SOLVED until you do a cwp update, do not run updates in ssh as it will reinstall back to previous phpmyadmin making it not work. I can confirm its all working now, i hope someone from cwp reads this post..

https://ostraining.com/blog/coding/update-phpmyadmin/  using this method to solve issue.

Warning!
If you run:
sh /scripts/update_cwp
It will make cwp reinstall back to the broken PHPMyAdmin.

All working but an error is showing in PHPMyAdmin end user:
 The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated. Find out why.
Or alternately go to 'Operations' tab of any database to set it up there.

Title: Re: Almalinux 8.6 phpmyadmin not working end user 2083
Post by: PakPos on July 06, 2022, 08:19:32 PM

Quote from: Shafire on July 06, 2022, 06:49:41 PM

SOLVED until you do a cwp update, do not run updates in ssh as it will reinstall back to previous phpmyadmin making it not work. I can confirm its all working now, i hope someone from cwp reads this post..

https://ostraining.com/blog/coding/update-phpmyadmin/  using this method to solve issue.

Warning!
If you run:
sh /scripts/update_cwp
It will make cwp reinstall back to the broken PHPMyAdmin.

All working but an error is showing in PHPMyAdmin end user:
 The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated. Find out why.
Or alternately go to 'Operations' tab of any database to set it up there.

any solution from webpanel dev ?

Title: Re: Almalinux 8.6 phpmyadmin not working end user 2083
Post by: Martins-phpbb on July 07, 2022, 12:05:19 AM

Strange i have no issues with phpmyadmin on alma linux 8.6 and rocky linux.

Title: Re: Almalinux 8.6 phpmyadmin not working end user 2083
Post by: Starburst on July 07, 2022, 12:33:11 AM

You just posted your own fix.

DISABLE the CWP repo.
It creates more problems than anything.

Quote from: PakPos on July 06, 2022, 08:19:32 PM

Quote from: Shafire on July 06, 2022, 06:49:41 PM

SOLVED until you do a cwp update, do not run updates in ssh as it will reinstall back to previous phpmyadmin making it not work. I can confirm its all working now, i hope someone from cwp reads this post..

https://ostraining.com/blog/coding/update-phpmyadmin/  using this method to solve issue.

Warning!
If you run:
sh /scripts/update_cwp
It will make cwp reinstall back to the broken PHPMyAdmin.

All working but an error is showing in PHPMyAdmin end user:
 The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated. Find out why.
Or alternately go to 'Operations' tab of any database to set it up there.

any solution from webpanel dev ?

Title: Re: Almalinux 8.6 phpmyadmin not working end user 2083
Post by: Shafire on July 07, 2022, 10:28:40 PM

Thanks for the replies appreciated, no they are too busy partying maybe  ;D Need the cwp repo for updates but a good idea if not production. Going to keep this server and spent too much time configuring it, making a new server with centos 8 stream hoping that has fewer problems, will keep almalinux cwp and work with centos 8 stream too, looking for long-term server setups.

Title: Re: Almalinux 8.6 phpmyadmin not working end user 2083
Post by: Starburst on July 08, 2022, 12:31:34 AM

Actually it's the opposite, having the CWP repo is only good for development, since they push incompatible versions against release versions.
One of which you found.

We have it disabled, and AlmaLinux 8.6 supplies the release version of the updates, and the control panel version (currently 0.9.8.1040, with a pending update for tonight) is still updated via their script.

CentOS Stream is not a long term solution, since it is now an alpha version OS, below Fedora.

CentOS -> Fedora -> RHEL
(alpha) -> (Beta) -> (Release)

Quote from: Shafire on July 07, 2022, 10:28:40 PM

Thanks for the replies appreciated, no they are too busy partying maybe  ;D Need the cwp repo for updates but a good idea if not production. Going to keep this server and spent too much time configuring it, making a new server with centos 8 stream hoping that has fewer problems, will keep almalinux cwp and work with centos 8 stream too, looking for long-term server setups.

Title: Re: Almalinux 8.6 phpmyadmin not working end user 2083
Post by: Shafire on July 08, 2022, 10:29:50 AM

Damm, thanks for the feedback, well i will go with rockylinux and delete centos 8 stream maybe. Was following the cwp official recommendations, though for long term almalinux and rocklinux will be the best option.

Title: Re: Almalinux 8.6 phpmyadmin not working end user 2083
Post by: Starburst on July 08, 2022, 03:24:46 PM

What I like about AlmaLinux, is it's basically the same company as CloudLinux that CWP recommends.

Alma seems to be the Free version, and Cloud the paid version.

Title: Re: Almalinux 8.6 phpmyadmin not working end user 2083
Post by: Shafire on July 09, 2022, 12:28:50 AM

how about rocky linux i just reinstalled to rocky linux from centos 8 stream, should i use alamalinux or rockylinux i was thining have 1 of each 2 cwp servers. If cwp cost more money would just have 1 server.  ::)

Title: Re: Almalinux 8.6 phpmyadmin not working end user 2083
Post by: Starburst on July 09, 2022, 01:21:39 AM

People where complaining about missing libraries in Rocky Linux 8.5, not sure about 8.6.

And as mentioned we use AlmaLinux now.

I think it comes down to personal choice.

Title: Re: Almalinux 8.6 phpmyadmin not working end user 2083
Post by: Shafire on July 09, 2022, 02:35:37 AM

Thanks for the replies, installed rockylinux hopefully newest version didn't have time to check, will report back to the forum if i face any issues, with further information, version etc. RUnning both alam and rocky now dropped centos8 stream seems pointless.

Title: Re: Almalinux 8.6 phpmyadmin not working end user 2083
Post by: ctorres on July 09, 2022, 04:37:10 AM

Hello,

have you tried to perform a live reinstall through the cwp script?

I recommend you first to see the logs to identify what is happening, one of these paths will help you, this is the reference link: https://wiki.centos-webpanel.com/service-log-paths

/usr/local/cwpsrv/logs/
/usr/local/cwp/php71/var/log/

and this would be the script, beware before doing this I recommend you make a backup of your server, if it is a vps server contracted with a hosting provider or a kvm request a snapshot of the system just in case, in order to work safely, In theory you can use this script to reinstall cwp with the latest available version.

https://wiki.centos-webpanel.com/how-to-create-cwp-iso-image read carefully before executing any action

regards

Title: Re: Almalinux 8.6 phpmyadmin not working end user 2083
Post by: Shafire on July 14, 2022, 10:53:09 PM

That sounds like the last option basically reinstalling, it works now all secure etc so won't change it, but good info for other people searching it helps a lot.  :)

Title: Re: Almalinux 8.6 phpmyadmin not working end user 2083
Post by: PakPos on August 20, 2022, 03:54:26 PM

forgot to reply here .. lol

https://i.vgy.me/iBCEip.png
correct ?

Quote from: Starburst on July 07, 2022, 12:33:11 AM

You just posted your own fix.

DISABLE the CWP repo.
It creates more problems than anything.

Quote from: PakPos on July 06, 2022, 08:19:32 PM

Quote from: Shafire on July 06, 2022, 06:49:41 PM

SOLVED until you do a cwp update, do not run updates in ssh as it will reinstall back to previous phpmyadmin making it not work. I can confirm its all working now, i hope someone from cwp reads this post..

https://ostraining.com/blog/coding/update-phpmyadmin/  using this method to solve issue.

Warning!
If you run:
sh /scripts/update_cwp
It will make cwp reinstall back to the broken PHPMyAdmin.

All working but an error is showing in PHPMyAdmin end user:
 The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated. Find out why.
Or alternately go to 'Operations' tab of any database to set it up there.

any solution from webpanel dev ?