Author Topic: Almalinux 8.6 phpmyadmin not working end user 2083  (Read 6154 times)

0 Members and 1 Guest are viewing this topic.

Offline
*
Almalinux 8.6 phpmyadmin not working end user 2083
« 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)
SEOtraining1.com -SecureHosting.xyz

Offline
*
Re: Almalinux 8.6 phpmyadmin not working end user 2083
« Reply #1 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?
« Last Edit: July 04, 2022, 01:45:23 AM by Shafire »
SEOtraining1.com -SecureHosting.xyz

Offline
*
Re: Almalinux 8.6 phpmyadmin not working end user 2083
« Reply #2 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.
SEOtraining1.com -SecureHosting.xyz

Offline
*
Re: Almalinux 8.6 phpmyadmin not working end user 2083
« Reply #3 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
SEOtraining1.com -SecureHosting.xyz

Offline
*
Re: Almalinux 8.6 phpmyadmin not working end user 2083
« Reply #4 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.
« Last Edit: July 06, 2022, 07:06:48 PM by Shafire »
SEOtraining1.com -SecureHosting.xyz

Offline
***
Re: Almalinux 8.6 phpmyadmin not working end user 2083
« Reply #5 on: July 06, 2022, 08:19:32 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 ?

Offline
*
Re: Almalinux 8.6 phpmyadmin not working end user 2083
« Reply #6 on: July 07, 2022, 12:05:19 AM »
Strange i have no issues with phpmyadmin on alma linux 8.6 and rocky linux.

Offline
****
Re: Almalinux 8.6 phpmyadmin not working end user 2083
« Reply #7 on: July 07, 2022, 12:33:11 AM »
You just posted your own fix.

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

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 ?

Offline
*
Re: Almalinux 8.6 phpmyadmin not working end user 2083
« Reply #8 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.
SEOtraining1.com -SecureHosting.xyz

Offline
****
Re: Almalinux 8.6 phpmyadmin not working end user 2083
« Reply #9 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)


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.

Offline
*
Re: Almalinux 8.6 phpmyadmin not working end user 2083
« Reply #10 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.
SEOtraining1.com -SecureHosting.xyz

Offline
****
Re: Almalinux 8.6 phpmyadmin not working end user 2083
« Reply #11 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.

Offline
*
Re: Almalinux 8.6 phpmyadmin not working end user 2083
« Reply #12 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.  ::)
SEOtraining1.com -SecureHosting.xyz

Offline
****
Re: Almalinux 8.6 phpmyadmin not working end user 2083
« Reply #13 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.

Offline
*
Re: Almalinux 8.6 phpmyadmin not working end user 2083
« Reply #14 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.
SEOtraining1.com -SecureHosting.xyz