New in CWP Edge-LatestFree with every CWPpro licenceWebsites up to 300x faster

CWP now includes LSPHP, LSAPI-Cache and CWP Cage at no extra cost with all CWPpro licences. The LSAPI-Cache plugin is integrated into our WordPress and other script installers, and CWP Cage gives every user complete isolation. Available now in the CWP Edge-Latest version.

Get CWPpro ›

Almalinux 8.6 phpmyadmin not working end user 2083

Started by Shafire, July 04, 2022, 12:41:39 AM

Previous topic - Next topic

Shafire

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

Shafire

#1
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?
SEOtraining1.com -SecureHosting.xyz

Shafire

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

Shafire

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

Shafire

#4
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.
SEOtraining1.com -SecureHosting.xyz

PakPos

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 ?

Martins-phpbb

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

Starburst

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 ?

Shafire

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

Starburst

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.

Shafire

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

Starburst

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.

Shafire

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

Starburst

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.

Shafire

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