I can't Create/Manage databases - no phpmyadmin

[villasweb]

After changing some passwords I don’t remember, the phpmyadmin doesn’t open anymore. When I tried to create OR LIST databases, doesn’t work either.

When it was working I needed to change the name of the database that I had created in the CP and I managed to do it through phpmyadmin, as well as create new databases with the name I wanted … I think that this should not be enabled. This could be the reason why the problem happened.
Thanks.

Phpmyadmin: doesn’t open (neither the login page)
Ubuntu 22.04.1 LTS (GNU/Linux 5.15.0-60-generic x86_64)
Maria DB is running OK
FTP doesn’t work anymore.

[josephgodwinke]

@villasweb

When it was working I needed to change the name of the database that I had created in the CP and I managed to do it through phpmyadmin, as well as create new databases with the name I wanted

Hello @villasweb

Did you alter anything in the cyberpanel database ?

[villasweb]

Nothing. As I have a production app there, I just access via console to backup 3 databases with mysqldump.
When I had the access to PHPMyAdmin, I import or create 3 new databases there in the root directory of CP I think. I thought it was weird but …

[josephgodwinke]

Run the upgrade script

Can you access phpmyadmin ? if not post screenshot of the error

[villasweb]

No error just a blank page after showing for like 3 seconds that button “ACCESS NOW” you know?

[josephgodwinke]

Look if you have phpmyadmin installed

$ ls /usr/local/CyberCP/public/

Do you see phpmyadmin folder

[villasweb]

@josephgodwinke

ls /usr/local/CyberCP/public/

Yes I have.

mailwatch
phpmyadmin
snappymail
static

[josephgodwinke]

Try now

$ yum install unzip || apt install unzip
$ cd /usr/local/CyberCP/public/
$ rm -rf phpmyadmin
$ wget -cO - https://files.phpmyadmin.net/phpMyAdmin/5.2.1/phpMyAdmin-5.2.1-all-languages.zip > phpmyadmin.zip
$ unzip phpmyadmin.zip

You can try access phpmyadmin via https://SERVER_URL:8090/phpmyadmin/index.php or go to Databases → PHPMYAdmin

See this to make sure your root password is same everywhere:

Some Dont's After Installing CyberPanel!

Hello! After installing CyberPanel there are somethings that you don’t want to do for having a smooth experience. Don’t upload files via SFTP When you upload files via sftp they are owned by root, and CyberPanel runs each account through its own user, so once you have uploaded content via root, you might start getting permissions errors. More details can be found here. Even though file manager now has one-click fix permission button to get rid of this issue, but this is still not a recomme…

[villasweb]

@josephgodwinke

yum install unzip || apt install unzip

There is the response to apt install unzip -
root@villasweb:~# yum install unzip || apt install unzip

Command ‘yum’ not found, did you mean:

command ‘num’ from deb quickcal (2.4-1)

command ‘zum’ from deb perforate (1.2-5.1)

command ‘sum’ from deb coreutils (8.32-4.1ubuntu1)

command ‘yum4’ from deb nextgen-yum4 (4.5.2-6)

command ‘uum’ from deb freewnn-jserver (1.1.1~a021+cvs20130302-7build1)

Try: apt install

Reading package lists… Done

Building dependency tree… Done

Reading state information… Done

unzip is already the newest version (6.0-26ubuntu3.1).

0 upgraded, 0 newly installed, 0 to remove and 2 not upgraded.

1 not fully installed or removed.

After this operation, 0 B of additional disk space will be used.

Do you want to continue? [Y/n] y

Setting up pure-ftpd (1.0.50-2.1) …

Job for pure-ftpd.service failed because the control process exited with error code.

See “systemctl status pure-ftpd.service” and “journalctl -xeu pure-ftpd.service” for details.

invoke-rc.d: initscript pure-ftpd, action “start” failed.

× pure-ftpd.service

Loaded: loaded (/etc/init.d/pure-ftpd; generated)

Active: failed (Result: exit-code) since Wed 2023-02-15 12:22:15 CST; 15ms ago

Docs: man:systemd-sysv-generator(8)

Process: 223333 ExecStart=/etc/init.d/pure-ftpd start (code=exited, status=2)

CPU: 52ms

Feb 15 12:22:15 villasweb.us systemd[1]: Starting pure-ftpd.service…

Feb 15 12:22:15 villasweb.us pure-ftpd[223333]: Starting ftp server:

Feb 15 12:22:15 villasweb.us pure-ftpd[223341]: /usr/sbin/pure-ftpd-wrapper: Couldn’t examine directory /etc/pure-ftpd/conf: No such file or directory

Feb 15 12:22:15 villasweb.us systemd[1]: pure-ftpd.service: Control process exited, code=exited, status=2/INVALIDARGUMENT

Feb 15 12:22:15 villasweb.us systemd[1]: pure-ftpd.service: Failed with result ‘exit-code’.

Feb 15 12:22:15 villasweb.us systemd[1]: Failed to start pure-ftpd.service.

dpkg: error processing package pure-ftpd (–configure):

installed pure-ftpd package post-installation script subprocess returned error exit status 1

Errors were encountered while processing:

pure-ftpd

E: Sub-process /usr/bin/dpkg returned an error code (1)

[josephgodwinke]

Just run apt install unzip and proceed with rest of commands

[villasweb]

@josephgodwinke

phpmyadmin/index.php

Unzipped but not accessible:

Not Found

The requested resource was not found on this server.