Show Posts
This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
Pages: [1] 2
1
PHP / Re: Install PHP 8.X - PHP Version Switcher
« on: November 28, 2022, 08:40:04 PM »
I tried both ways, both unsuccessful.
I believe that it is actually due to the specifications of my VPS, it currently has 1GB RAM, I will be increasing it to 2GB RAM and testing again.
I believe that it is actually due to the specifications of my VPS, it currently has 1GB RAM, I will be increasing it to 2GB RAM and testing again.
2
PHP / Install PHP 8.X - PHP Version Switcher
« on: September 25, 2022, 01:11:56 PM »
I am updating my PHP to version 8.0.23 by option PHP Version Switcher who has in CWP panel.
It does the entire installation process, it shows build complete in the log, but it still doesn't leave the 7.4.30 version that I installed when I first installed the CWP panel.
Follows complete log that shows when you are doing the installation of PHP.
https://gist.github.com/crashzk/3aab8d8bbf94e99e3e8df8abbb558827
It does the entire installation process, it shows build complete in the log, but it still doesn't leave the 7.4.30 version that I installed when I first installed the CWP panel.
Follows complete log that shows when you are doing the installation of PHP.
https://gist.github.com/crashzk/3aab8d8bbf94e99e3e8df8abbb558827
3
MySQL / CWP Painel Root - MySQL Error Connection
« on: October 20, 2021, 02:47:38 AM »
Today I started getting the following error on my CWP:
I've already tried running the command he quotes.
But nothing, same error yet.
I also checked the MySQL Root Password:
How can I fix it? All my clients are offline as they don't have access to the MysQL database.
Code: [Select]
Warning: mysqli_connect(): (HY000/2002): Connection refused in /usr/local/cwpsrv/htdocs/resources/admin/include/functions.php on line 0
Warning: mysqli_connect(): (HY000/2002): Connection refused in /usr/local/cwpsrv/htdocs/resources/admin/include/functions.php on line 0
Warning: mysqli_connect(): (HY000/2002): Connection refused in /usr/local/cwpsrv/htdocs/admin/admin/index.php on line 0
Warning: mysqli_connect(): (HY000/2002): Connection refused in /usr/local/cwpsrv/htdocs/admin/admin/index.php on line 0
Trying to start mysql server, please wait!
Try to restart Control Web Panel with command: sh /scripts/restart_cwpsrv
**Check your MySQL root password in: /usr/local/cwpsrv/htdocs/resources/admin/include/db_conn.php and /root/.my.cnf
Warning: mysqli_error() expects exactly 1 parameter, 0 given in /usr/local/cwpsrv/htdocs/admin/admin/index.php on line 0
Could not connect:
I've already tried running the command he quotes.
Code: [Select]
Trying to start mysql server, please wait!
Try to restart Control Web Panel with command: sh /scripts/restart_cwpsrv
But nothing, same error yet.
I also checked the MySQL Root Password:
Code: [Select]
**Check your MySQL root password in: /usr/local/cwpsrv/htdocs/resources/admin/include/db_conn.php and /root/.my.cnf
How can I fix it? All my clients are offline as they don't have access to the MysQL database.
4
CentOS 7 Problems / Re: Warning: mysqli_connect(): (HY000/2002)
« on: July 16, 2021, 12:34:54 PM »
I'm also having this same error, even following all the tips here the problem still occurs.
Code: [Select]
[root@vps1 ~]# service mysqld restart
Restarting mysqld (via systemctl): Job for mariadb.service failed because a fatal signal was delivered to the control process. See "systemctl status mariadb.service" and "journalctl -xe" for details.
[FAILED]
[root@vps1 ~]# systemctl status mariadb.service
● mariadb.service - MariaDB 10.2.36 database server
Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
Drop-In: /etc/systemd/system/mariadb.service.d
└─migrated-from-my.cnf-settings.conf
Active: activating (auto-restart) (Result: signal) since Fri 2021-07-16 09:32:22 -03; 4s ago
Docs: man:mysqld(8)
https://mariadb.com/kb/en/library/systemd/
Process: 25722 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS --basedir=/usr $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=killed, signal=ABRT)
Process: 25686 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -eq 0 ] && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=0/SUCCESS)
Process: 25685 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Main PID: 25722 (code=killed, signal=ABRT)
Jul 16 09:32:22 vps1.zkservidores.com systemd[1]: Failed to start MariaDB 10.2.36 database server.
Jul 16 09:32:22 vps1.zkservidores.com systemd[1]: Unit mariadb.service entered failed state.
Jul 16 09:32:22 vps1.zkservidores.com systemd[1]: mariadb.service failed.
[root@vps1 ~]# journalctl -xe
Jul 15 08:08:38 vps1.zkservidores.com postfix/pickup[30223]: warning: 5A57684460: message has been queued for 1 days
Jul 15 08:08:38 vps1.zkservidores.com postfix/pickup[30223]: 5A57684460: uid=0 from=<root>
Jul 15 08:08:38 vps1.zkservidores.com postfix/cleanup[15945]: 5A57684460: message-id=<20210715110838.5A57684460@vps1.zkservidores.com>
Jul 15 08:08:38 vps1.zkservidores.com postfix/cleanup[15945]: warning: proxy:mysql:/etc/postfix/mysql-virtual_alias_default_maps.cf lookup error for "root@vps1.zkservidores.com"
Jul 15 08:08:38 vps1.zkservidores.com postfix/cleanup[15945]: warning: 5A57684460: virtual_alias_maps map lookup problem for root@vps1.zkservidores.com -- message not accepted, try again later
Jul 15 08:08:38 vps1.zkservidores.com postfix/cleanup[15945]: warning: proxy:mysql:/etc/postfix/mysql-virtual_vacation.cf lookup error for "root@vps1.zkservidores.com"
Jul 15 08:08:38 vps1.zkservidores.com postfix/cleanup[15945]: warning: 5A57684460: recipient_bcc_maps map lookup problem -- message not accepted, try again later
Jul 15 08:08:39 vps1.zkservidores.com postfix/pickup[30223]: 5B4AE84460: uid=0 from=<root>
Jul 15 08:08:39 vps1.zkservidores.com postfix/cleanup[15947]: 5B4AE84460: message-id=<20210715110839.5B4AE84460@vps1.zkservidores.com>
Jul 15 08:08:39 vps1.zkservidores.com postfix/cleanup[15947]: warning: proxy:mysql:/etc/postfix/mysql-virtual_alias_default_maps.cf lookup error for "root@vps1.zkservidores.com"
Jul 15 08:08:39 vps1.zkservidores.com postfix/cleanup[15947]: warning: 5B4AE84460: virtual_alias_maps map lookup problem for root@vps1.zkservidores.com -- message not accepted, try again later
Jul 15 08:08:39 vps1.zkservidores.com postfix/cleanup[15947]: warning: proxy:mysql:/etc/postfix/mysql-virtual_vacation.cf lookup error for "root@vps1.zkservidores.com"
Jul 15 08:08:39 vps1.zkservidores.com postfix/cleanup[15947]: warning: 5B4AE84460: recipient_bcc_maps map lookup problem -- message not accepted, try again later
Jul 15 08:08:40 vps1.zkservidores.com postfix/pickup[30223]: 8516C84460: uid=0 from=<root>
Jul 15 08:08:40 vps1.zkservidores.com postfix/cleanup[15945]: 8516C84460: message-id=<20210715110840.8516C84460@vps1.zkservidores.com>
Jul 15 08:08:40 vps1.zkservidores.com postfix/cleanup[15945]: warning: proxy:mysql:/etc/postfix/mysql-virtual_alias_default_maps.cf lookup error for "webmaster@zkservidores.com"
Jul 15 08:08:40 vps1.zkservidores.com postfix/cleanup[15945]: warning: 8516C84460: virtual_alias_maps map lookup problem for webmaster@zkservidores.com -- message not accepted, try again later
Jul 15 08:08:40 vps1.zkservidores.com postfix/cleanup[15945]: warning: proxy:mysql:/etc/postfix/mysql-virtual_vacation.cf lookup error for "webmaster@zkservidores.com"
Jul 15 08:08:40 vps1.zkservidores.com postfix/cleanup[15945]: warning: 8516C84460: recipient_bcc_maps map lookup problem -- message not accepted, try again later
Jul 15 08:08:41 vps1.zkservidores.com postfix/pickup[30223]: 8648E84460: uid=0 from=<root>
Jul 15 08:08:41 vps1.zkservidores.com postfix/cleanup[15947]: 8648E84460: message-id=<20210715110841.8648E84460@vps1.zkservidores.com>
Jul 15 08:08:41 vps1.zkservidores.com postfix/cleanup[15947]: warning: proxy:mysql:/etc/postfix/mysql-virtual_alias_default_maps.cf lookup error for "root@vps1.zkservidores.com"
Jul 15 08:08:41 vps1.zkservidores.com postfix/cleanup[15947]: warning: 8648E84460: virtual_alias_maps map lookup problem for root@vps1.zkservidores.com -- message not accepted, try again later
Jul 15 08:08:41 vps1.zkservidores.com postfix/cleanup[15947]: warning: proxy:mysql:/etc/postfix/mysql-virtual_vacation.cf lookup error for "root@vps1.zkservidores.com"
Jul 15 08:08:41 vps1.zkservidores.com postfix/cleanup[15947]: warning: 8648E84460: recipient_bcc_maps map lookup problem -- message not accepted, try again later
Jul 15 08:08:42 vps1.zkservidores.com systemd[1]: mariadb.service holdoff time over, scheduling restart.
Jul 15 08:08:42 vps1.zkservidores.com systemd[1]: Cannot add dependency job for unit systemd-vconsole-setup.service, ignoring: Unit is masked.
Jul 15 08:08:42 vps1.zkservidores.com systemd[1]: Stopped MariaDB 10.2.36 database server.
-- Subject: Unit mariadb.service has finished shutting down
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit mariadb.service has finished shutting down.
Jul 15 08:08:42 vps1.zkservidores.com systemd[1]: Starting MariaDB 10.2.36 database server...
-- Subject: Unit mariadb.service has begun start-up
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit mariadb.service has begun starting up.
Jul 15 08:08:42 vps1.zkservidores.com mysqld[17979]: 2021-07-15 8:08:42 139974079039680 [Note] /usr/sbin/mysqld (mysqld 10.2.36-MariaDB) starting as process 17979 ...
Jul 15 08:08:42 vps1.zkservidores.com mysqld[17979]: 2021-07-15 8:08:42 139974079039680 [Warning] Could not increase number of max_open_files to more than 16384 (request: 32232)
Jul 15 08:08:42 vps1.zkservidores.com postfix/pickup[30223]: warning: 8722384460: message has been queued for 5 days
Jul 15 08:08:42 vps1.zkservidores.com postfix/pickup[30223]: 8722384460: uid=0 from=<root>
Jul 15 08:08:42 vps1.zkservidores.com postfix/cleanup[15945]: 8722384460: message-id=<20210715110842.8722384460@vps1.zkservidores.com>
Jul 15 08:08:42 vps1.zkservidores.com postfix/cleanup[15945]: warning: proxy:mysql:/etc/postfix/mysql-virtual_alias_default_maps.cf lookup error for "root@vps1.zkservidores.com"
Jul 15 08:08:42 vps1.zkservidores.com postfix/cleanup[15945]: warning: 8722384460: virtual_alias_maps map lookup problem for root@vps1.zkservidores.com -- message not accepted, try again later
Jul 15 08:08:42 vps1.zkservidores.com postfix/cleanup[15945]: warning: proxy:mysql:/etc/postfix/mysql-virtual_vacation.cf lookup error for "root@vps1.zkservidores.com"
Jul 15 08:08:42 vps1.zkservidores.com postfix/cleanup[15945]: warning: 8722384460: recipient_bcc_maps map lookup problem -- message not accepted, try again later
Jul 15 08:08:42 vps1.zkservidores.com mysqld[17979]: 2021-07-15 8:08:42 139974079039680 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
Jul 15 08:08:42 vps1.zkservidores.com mysqld[17979]: 2021-07-15 8:08:42 139974079039680 [Note] InnoDB: Uses event mutexes
Jul 15 08:08:42 vps1.zkservidores.com mysqld[17979]: 2021-07-15 8:08:42 139974079039680 [Note] InnoDB: Compressed tables use zlib 1.2.7
Jul 15 08:08:42 vps1.zkservidores.com mysqld[17979]: 2021-07-15 8:08:42 139974079039680 [Note] InnoDB: Using Linux native AIOAny way to fix, besides those already informed? Did I forget something?
5
MySQL / Re: Start MySQL server, please wait
« on: July 15, 2021, 04:08:23 PM »
Consegui mais algumas informações, caso ajude:
Code: [Select]
********************************************
Welcome to CWP (CentOS WebPanel) server
********************************************
CWP Wiki: http://wiki.centos-webpanel.com
CWP Forum: http://forum.centos-webpanel.com
CWP Support: http://centos-webpanel.com/support-services
13:04:48 up 2 days, 3:05, 1 user, load average: 0.32, 0.30, 0.26
USER TTY FROM LOGIN@ IDLE JCPU PCPU WHAT
root pts/0 186.233.221.128 13:04 0.00s 0.02s 0.00s sh /root/.bash_cwp
[root@vps1 ~]# sh /scripts/restart_cwpsrv
[root@vps1 ~]# service mysql restart
Restarting mysql (via systemctl): Job for mariadb.service failed because a fatal signal was delivered to the control process. See "systemctl status mariadb.service" and "journalctl -xe" for details.
[FAILED]
[root@vps1 ~]# systemctl status mariadb.service
● mariadb.service - MariaDB 10.2.36 database server
Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
Drop-In: /etc/systemd/system/mariadb.service.d
└─migrated-from-my.cnf-settings.conf
Active: activating (auto-restart) (Result: signal) since Thu 2021-07-15 13:06:35 -03; 2s ago
Docs: man:mysqld(8)
https://mariadb.com/kb/en/library/systemd/
Process: 6858 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS --basedir=/usr $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=killed, signal=ABRT)
Process: 6825 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -eq 0 ] && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=0/SUCCESS)
Process: 6824 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Main PID: 6858 (code=killed, signal=ABRT)
Jul 15 13:06:35 vps1.zkservidores.com systemd[1]: Failed to start MariaDB 10.2.36 database server.
Jul 15 13:06:35 vps1.zkservidores.com systemd[1]: Unit mariadb.service entered failed state.
Jul 15 13:06:35 vps1.zkservidores.com systemd[1]: mariadb.service failed.
[root@vps1 ~]# journalctl -xe
Jul 15 13:06:46 vps1.zkservidores.com mysqld[6987]: :0(__GI_raise)[0x7ffa212a6387]
Jul 15 13:06:46 vps1.zkservidores.com mysqld[6987]: :0(__GI_abort)[0x7ffa212a7a78]
Jul 15 13:06:46 vps1.zkservidores.com mysqld[6987]: /usr/sbin/mysqld(+0x999ac3)[0x55ff6dd70ac3]
Jul 15 13:06:46 vps1.zkservidores.com mysqld[6987]: /usr/sbin/mysqld(+0x9df768)[0x55ff6ddb6768]
Jul 15 13:06:46 vps1.zkservidores.com mysqld[6987]: /usr/sbin/mysqld(+0x9fd9e7)[0x55ff6ddd49e7]
Jul 15 13:06:46 vps1.zkservidores.com mysqld[6987]: /usr/sbin/mysqld(+0x9dc6a8)[0x55ff6ddb36a8]
Jul 15 13:06:46 vps1.zkservidores.com mysqld[6987]: /usr/sbin/mysqld(+0x97f3bf)[0x55ff6dd563bf]
Jul 15 13:06:46 vps1.zkservidores.com mysqld[6987]: /usr/sbin/mysqld(+0x94f7ba)[0x55ff6dd267ba]
Jul 15 13:06:46 vps1.zkservidores.com mysqld[6987]: /usr/sbin/mysqld(+0x9513b5)[0x55ff6dd283b5]
Jul 15 13:06:46 vps1.zkservidores.com mysqld[6987]: /usr/sbin/mysqld(+0x83e641)[0x55ff6dc15641]
Jul 15 13:06:46 vps1.zkservidores.com mysqld[6987]: /usr/sbin/mysqld(_Z24ha_initialize_handlertonP13st_plugin_int+0x64)[0x55ff6da7ce54]
Jul 15 13:06:46 vps1.zkservidores.com mysqld[6987]: /usr/sbin/mysqld(+0x51f0a0)[0x55ff6d8f60a0]
Jul 15 13:06:46 vps1.zkservidores.com mysqld[6987]: /usr/sbin/mysqld(_Z11plugin_initPiPPci+0x9a2)[0x55ff6d8f7962]
Jul 15 13:06:46 vps1.zkservidores.com mysqld[6987]: /usr/sbin/mysqld(+0x46c8c7)[0x55ff6d8438c7]
Jul 15 13:06:46 vps1.zkservidores.com mysqld[6987]: /usr/sbin/mysqld(_Z11mysqld_mainiPPc+0x4be)[0x55ff6d8498ce]
Jul 15 13:06:46 vps1.zkservidores.com mysqld[6987]: /lib64/libc.so.6(__libc_start_main+0xf5)[0x7ffa21292555]
Jul 15 13:06:46 vps1.zkservidores.com mysqld[6987]: /usr/sbin/mysqld(+0x46653d)[0x55ff6d83d53d]
Jul 15 13:06:46 vps1.zkservidores.com mysqld[6987]: The manual page at https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mysqld/ contains
Jul 15 13:06:46 vps1.zkservidores.com mysqld[6987]: information that should help you find out what is causing the crash.
Jul 15 13:06:46 vps1.zkservidores.com mysqld[6987]: Writing a core file...
Jul 15 13:06:46 vps1.zkservidores.com mysqld[6987]: Working directory at /var/lib/mysql
Jul 15 13:06:46 vps1.zkservidores.com mysqld[6987]: Resource Limits:
Jul 15 13:06:46 vps1.zkservidores.com mysqld[6987]: Limit Soft Limit Hard Limit Units
Jul 15 13:06:46 vps1.zkservidores.com mysqld[6987]: Max cpu time unlimited unlimited seconds
Jul 15 13:06:46 vps1.zkservidores.com mysqld[6987]: Max file size unlimited unlimited bytes
Jul 15 13:06:46 vps1.zkservidores.com mysqld[6987]: Max data size unlimited unlimited bytes
Jul 15 13:06:46 vps1.zkservidores.com mysqld[6987]: Max stack size 8388608 unlimited bytes
Jul 15 13:06:46 vps1.zkservidores.com mysqld[6987]: Max core file size 0 unlimited bytes
Jul 15 13:06:46 vps1.zkservidores.com mysqld[6987]: Max resident set unlimited unlimited bytes
Jul 15 13:06:46 vps1.zkservidores.com mysqld[6987]: Max processes 62987 62987 processes
Jul 15 13:06:46 vps1.zkservidores.com mysqld[6987]: Max open files 16384 16384 files
Jul 15 13:06:46 vps1.zkservidores.com mysqld[6987]: Max locked memory 65536 65536 bytes
Jul 15 13:06:46 vps1.zkservidores.com mysqld[6987]: Max address space unlimited unlimited bytes
Jul 15 13:06:46 vps1.zkservidores.com mysqld[6987]: Max file locks unlimited unlimited locks
Jul 15 13:06:46 vps1.zkservidores.com mysqld[6987]: Max pending signals 514862 514862 signals
Jul 15 13:06:46 vps1.zkservidores.com mysqld[6987]: Max msgqueue size 819200 819200 bytes
Jul 15 13:06:46 vps1.zkservidores.com mysqld[6987]: Max nice priority 0 0
Jul 15 13:06:46 vps1.zkservidores.com mysqld[6987]: Max realtime priority 0 0
Jul 15 13:06:46 vps1.zkservidores.com mysqld[6987]: Max realtime timeout unlimited unlimited us
Jul 15 13:06:46 vps1.zkservidores.com mysqld[6987]: Core pattern: core
Jul 15 13:06:46 vps1.zkservidores.com systemd[1]: mariadb.service: main process exited, code=killed, status=6/ABRT
Jul 15 13:06:46 vps1.zkservidores.com systemd[1]: Failed to start MariaDB 10.2.36 database server.
-- Subject: Unit mariadb.service has failed
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit mariadb.service has failed.
--
-- The result is failed.
Jul 15 13:06:46 vps1.zkservidores.com systemd[1]: Unit mariadb.service entered failed state.
Jul 15 13:06:46 vps1.zkservidores.com systemd[1]: mariadb.service failed.
Jul 15 13:06:49 vps1.zkservidores.com named[428]: client @0x7fe1b4042e70 104.169.74.143#80 (pizzaseo.com): query (cache) 'pizzaseo.com/RRSIG/IN' denied
6
MySQL / Re: Start MySQL server, please wait
« on: July 15, 2021, 03:57:24 PM »
I believe it's not a disk problem, but here's a print with the information: https://prnt.sc/1bgg2u1
It would be 20GB in total, using 8GB currently.
I don't know if it helps, but I use a CentOS 7
It would be 20GB in total, using 8GB currently.
I don't know if it helps, but I use a CentOS 7
7
MySQL / Start MySQL server, please wait
« on: July 13, 2021, 01:11:42 PM »
CWP stopped working, I try to access the admin panel, root access got the following error:
I've already run the command sh /scripts/restart_cwpsrv to restart mysql server, but nothing to go.
Code: [Select]
Warning: mysqli_connect(): (HY000/2002): Connection refused in /usr/local/cwpsrv/htdocs/resources/admin/include/functions.php on line 0
Warning: mysqli_connect(): (HY000/2002): Connection refused in /usr/local/cwpsrv/htdocs/resources/admin/include/functions.php on line 0
Warning: mysqli_connect(): (HY000/2002): Connection refused in /usr/local/cwpsrv/htdocs/admin/admin/index.php on line 0
Warning: mysqli_connect(): (HY000/2002): Connection refused in /usr/local/cwpsrv/htdocs/admin/admin/index.php on line 0
Trying to start mysql server, please wait!
Try to restart CentOS Web Panel with command: sh /scripts/restart_cwpsrv
**Check your MySQL root password in: /usr/local/cwpsrv/htdocs/resources/admin/include/db_conn.php and /root/.my.cnf
Warning: mysqli_error() expects exactly 1 parameter, 0 given in /usr/local/cwpsrv/htdocs/admin/admin/index.php on line 0
Could not connect:I've already run the command sh /scripts/restart_cwpsrv to restart mysql server, but nothing to go.
8
Installation / Re: Doubts with installation | phpByAdmin
« on: January 30, 2021, 02:47:53 PM »It displays like that if the user only has a single database. Try adding another one or copying the existing one.Damn, shame, you're correct.
Thank you, now I learned.
I'm closing the topic and marking it resolved.
9
Installation / Re: Doubts with installation | phpByAdmin
« on: January 30, 2021, 02:11:13 PM »
Come on, try to explain it better.
The first time I installed CWP when I created a user, example "admin" and he created a database in his phpMyAdmin account, who has root access showed this:
As you can see all the databases of the admin user are within a table exclusive to him.
However after I installed the CWP again, now all the features working when a user creates a database no longer looks like this, as you can see:
Is there any way to fix this? Would that be a mistake?
The first time I installed CWP when I created a user, example "admin" and he created a database in his phpMyAdmin account, who has root access showed this:
As you can see all the databases of the admin user are within a table exclusive to him.
However after I installed the CWP again, now all the features working when a user creates a database no longer looks like this, as you can see:
Is there any way to fix this? Would that be a mistake?
10
Installation / Doubts with installation | phpByAdmin
« on: January 29, 2021, 11:30:30 PM »
I did the CWP installation, in this case again from scratch to correct errors I made during the first installation, now everything is fine, but I noticed an error, so I believe, in phpMyAdmin:
https://prnt.sc/xu3u6i
As you can see in the print I have a database created, everything works fine, but this access I made in phpMyAdmin was by root, so it shows all databases, but before it showed users' databases inside a folder so to speak as his username, and inside this folder it showed his databases, something like the postfix database.
Any way to fix it? Do you leave the databases inside a folder with his username? This makes it easier to find databases.
https://prnt.sc/xu3u6i
As you can see in the print I have a database created, everything works fine, but this access I made in phpMyAdmin was by root, so it shows all databases, but before it showed users' databases inside a folder so to speak as his username, and inside this folder it showed his databases, something like the postfix database.
Any way to fix it? Do you leave the databases inside a folder with his username? This makes it easier to find databases.
11
MySQL / Re: PhpMyAdmin | Configuration storage is not completely configured
« on: January 29, 2021, 01:51:11 PM »
Outro dúvida, estou tentando acessar o phpMyAdmin direto pelo painel admin e até mesmo pelo do usuário, ambos mostra o mesmo erro: https://prnt.sc/xtadtd
Researching the error I found some solutions:
Is it located elsewhere?
Quote
Login without a password is forbidden by configuration (see AllowNoPassword)
Researching the error I found some solutions:
Quote
Copy config.sample.inc.php to config.inc.php.But what would be the problem, this phpmyadmin folder does not exist in CentOS 7, nothing inside the etc folder about phpmyadmin.
In most cases you will find the config file
on linux: /etc/phpmyadmin/config.inc.php
on mac: /Library/WebServer/Documents/phpmyadmin/config.inc.php
If you are trying to log in as root, you should have the following lines in your config:
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['AllowNoPassword'] = true;
Is it located elsewhere?
12
E-Mail / Re: I don't receive emails | Relay access denied
« on: January 29, 2021, 01:38:59 PM »do you this is resolved?Yes, apparently, doing tests here I can both send emails and receive emails now.
Solutions that I applied were, correction of MX records and some others that I asked to do by performing the email test on this site: https://www.mail-tester.com/test-b0e600ggs
So far so good, I'm giving the problem as resolved anything return the contact.
Thanks.
13
MySQL / Re: PhpMyAdmin | Configuration storage is not completely configured
« on: January 28, 2021, 11:51:56 AM »it will not create any issue as i mentioned earlier we didn't use pmadbOK, thank you.
14
MySQL / Re: PhpMyAdmin | Configuration storage is not completely configured
« on: January 28, 2021, 11:48:45 AM »is this new installation?Yes, it would be a new installation, I installed CWP yesterday in case of scratch. When I finished installing CWP, the only changes I made was changing PHP to the latest version of 7.3.
looks like installation wasnt done properly or the database might have been deleted
Then I added a user and his domain to the admin panel. Accessing phpMyAdmin with root is all right, but when users access phpMyAdmin through their accounts it shows this error.
Any way to fix this? Or should I install CWP from scratch again?
NOTE: WebServer Settings leaves Nginx & Varnish & Apache active.
15
MySQL / PhpMyAdmin | Configuration storage is not completely configured
« on: January 28, 2021, 02:46:54 AM »
All users I am adding to the CWP are having problems when creating a mysql database.
Can do the whole process, but always shows an error that he needs to finalize a phpMyAdmin configuration, here's a print: https://prnt.sc/xqfy3l
Clicking to know more about this error I have this: https://prnt.sc/xqg6k6
Problem would be that when root access this error does not exist, everything is fine. Would there be any way to fix it for all the users you have on the CWP?
Can do the whole process, but always shows an error that he needs to finalize a phpMyAdmin configuration, here's a print: https://prnt.sc/xqfy3l
Clicking to know more about this error I have this: https://prnt.sc/xqg6k6
Problem would be that when root access this error does not exist, everything is fine. Would there be any way to fix it for all the users you have on the CWP?
Pages: [1] 2
