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)
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?
Should i try rockylinux? CWP had some auto error reporting and fixing script, is that still running as i never see any notifications.
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
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.
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 ?
Strange i have no issues with phpmyadmin on alma linux 8.6 and rocky linux.
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 ?
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.
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.
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.
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.
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. ::)
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.
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.
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
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. :)
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 ?