Messages

1

MySQL / Re: mySQL user

« on: Today at 12:51:34 PM »

Perhaps that came from a cPanel migration? I don't have an "any" user on any of my servers...

Surprised to see that

Hope not a malware / hacking issue

2

MySQL / Re: mySQL user

« on: Today at 12:29:45 PM »

Got answer from here

https://forum.centos-webpanel.com/centos-webpanel-bugs/users-can-see-all-phpmyadmin-user-database-how-to-prevent-it/msg51069/#msg51069

Deleting user "Any" resolved the issue. Not sure if I have created any other issue due to this.

As of now all good.

3

CentOS-WebPanel Bugs / Re: users can see all phpmyadmin user database, how to prevent it?

« on: Today at 12:27:19 PM »

Hi, I got the solution. Some how in my phpmyadmin "User accounts" section added a entry like: Any -->localhost--->yes--->usage--->No, So this entry means anyone can login to main localhost if anyone have a authorized user id & password. So, solution is just remove that user from the table. That's all. Hope it will help any one else. Today full night is gone to investigate this issue.

Thanks a ton. I was struggling with this. SOLVED

4

MySQL / Re: root password change

« on: Today at 12:08:10 PM »

Looks like you have uncovered a bug in the MySQL PW reset script. You may need to manually change the PW via the CLI and then make sure the new PW is in both of these files:

Code: [Select]

/usr/local/cwpsrv/htdocs/resources/admin/include/db_conn.php
/root/.my.cnfhttps://www.digitalocean.com/community/tutorials/how-to-reset-your-mysql-or-mariadb-root-password

Thank you

5

MySQL / root password change

« on: Today at 06:31:16 AM »

I tried following https://wiki.centos-webpanel.com/how-to-reset-mysql-root-password

[root@hosting ~]# sh /scripts/mysql_pwd_reset

Enter the new root password (at least 8 chars).
Or leave it empty if you would like to generate it.
Or press CTRL+C to abort and do not touch it

Enter MySQL root password (NO special characters): abcxyzavcbdFrsg
Shutting down any mysql processes...
/scripts/mysql_pwd_reset: line 14: [: -eq: unary operator expected
Redirecting to /bin/systemctl stop mariadb.service
/scripts/mysql_pwd_reset: line 26: [: -eq: unary operator expected
Redirecting to /bin/systemctl start mariadb.service
Resetting password... hold on
--------------
UPDATE mysql.user SET Password=PASSWORD('abcxyzavcbdFrsg'),Authentication_string=PASSWORD('abcxyzavcbdFrsg') WHERE user='root'
--------------

ERROR 1348 (HY000) at line 1: Column 'Password' is not updatable
Cleaning up...
/scripts/mysql_pwd_reset: line 14: [: -eq: unary operator expected
Redirecting to /bin/systemctl stop mariadb.service

Password reset has been completed

New MySQL root password: abcxyzavcbdFrsg

Remember to store this password safely!

/scripts/mysql_pwd_reset: line 26: [: -eq: unary operator expected
Redirecting to /bin/systemctl start mariadb.service

And now CWP panel is not working

6

MySQL / mysql user issues

« on: April 16, 2025, 06:44:32 AM »

1. I am trying to add an user from user panel.

I am trying to create mysql db 'user_db' with db user 'user_db_usr'

I get success message. But the db and user are not visible.

I logged in as user. I see db '_db' with db user '_db_usr' instead of db 'user_db' with db user 'user_db_usr'

Ignoring this, I created db 'user_db' with db user 'user_db_usr' from admin panel. Now I can see this db and user from user panel login

But if I try to login to phpmyadmin with the crerdentials, I get the error "mysqli::real_connect(): (HY000/1045): Access denied for user 'user_db_usr'@'localhost' (using password: YES)"

I taught maybe I have to add local host or IP. I tried adding an existing user in userpanel with IP / hostname / %. But select user doesnt show the user (I can see the user in "List database and users" and "List Users" options)

Please suggest.

7

MySQL / Re: Can't delete MySQL user after "cPanel Account Restore"

« on: April 14, 2025, 11:29:27 AM »

I've been down that road back when I migrated from cPanel to CWP. I cleaned up the users in PMA, logged in as root.

Got it. Thank you

8

MySQL / Re: Can't delete MySQL user after "cPanel Account Restore"

« on: April 14, 2025, 04:59:09 AM »

And you tried from phpMyAdmin (logged in as root)?

No. Talking about deleting users from database in admin as well as user panels

I imported accounts from cpanel

Now under Admin panel - MySqL Manager - Users I see 2 set of users

User (Localhost)
User (Old Server) - Delete - Error Invalid system user

 

9

E-Mail / Re: Email ids under 1 user not receiving emails

« on: April 14, 2025, 04:55:48 AM »

The storage server is IMAP (dovecot), so not being able to access. Try 770 permissions (which is what one CWP server has; oddly, the other one is 755 which came from a cPanel import):

Code: [Select]

chmod -R 770 /var/vmail
chown -R vmail:mail /var/vmail

Thank you

10

CentOS-WebPanel GUI / Re: Email ids and forwards

« on: April 14, 2025, 04:53:32 AM »

Just as it refers to.  Add the forward address in as one of the comma separated list of emails to be forwarded to.


https://prnt.sc/3Scr75OKwP5n

The moment I do this, email will not get stored in inbox. It only gets forwarded

11

MySQL / Re: Can't delete MySQL user after "cPanel Account Restore"

« on: April 12, 2025, 11:06:06 AM »

Yes. This is an issue. I have all old users linked to my previous server which cant be deleted

12

Information / Re: check all autoSSL (Lets encrypt) that failed

« on: April 12, 2025, 10:54:55 AM »

It will be an useful option.

I have encountered many times many renewals have failed.

If we can run renew automatically once in a while, it wlll be useful

13

CentOS-WebPanel GUI / Email ids and forwards

« on: April 12, 2025, 10:44:26 AM »

If I create a email forward for a email which already has an email created email is getting forwarded but not stored in inbox.

Is this how this works?

I taught having an email id created should store email in server inbox also.

Any update on this?

Create email forward says "*** By using email forwarder you will not receive emails anymore into the mailbox but if you add your email address into Forward to: filed then you will also receive email into mailbox and forward them to the other mail address."

Where is this "Forward to" option? I am unable to find it

14

Dovecot / Re: Dovecot Sieve Error

« on: April 12, 2025, 09:19:50 AM »

I am almso getting errors

Apr 12 17:52:13 lmtp(user@domain.tld)<9519><E+evHb0p+mcvJQAAWIEZlA>: Error: sieve: binary /var/sieve/globalfilter.svbin: save: failed to create temporary file: open(/var/sieve/globalfilter.svbin.) failed: Permission denied (euid=1019(user) egid=12(mail) missing +w perm: /var/sieve, dir owned by 101:12 mode=0755)
Apr 12 17:52:13 lmtp(user@domain.tld)<9519><E+evHb0p+mcvJQAAWIEZlA>: Error: sieve: The LDA Sieve plugin does not have permission to save global Sieve script binaries; global Sieve scripts like `/var/sieve/globalfilter.sieve' need to be pre-compiled using the sievec tool
Apr 12 17:52:13 lmtp(user@domain.tld)<9519><E+evHb0p+mcvJQAAWIEZlA>: Error: sieve: binary /var/sieve/globalfilter.svbin: save: failed to create temporary file: open(/var/sieve/globalfilter.svbin.) failed: Permission denied (euid=1019(muralico) egid=12(mail) missing +w perm: /var/sieve, dir owned by 101:12 mode=0755)
Apr 12 17:52:13 lmtp(user@domain.tld)<9519><E+evHb0p+mcvJQAAWIEZlA>: Error: sieve: The LDA Sieve plugin does not have permission to save global Sieve script binaries; global Sieve scripts like `/var/sieve/globalfilter.sieve' need to be pre-compiled using the sievec tool
Apr 12 18:06:48 lmtp(user@domain.tld)<16280><AMpJFCgt+meYPwAAWIEZlA>: Error: sieve: binary /var/sieve/globalfilter.svbin: save: failed to create temporary file: open(/var/sieve/globalfilter.svbin.) failed: Permission denied (euid=1017(bizzworl) egid=12(mail) missing +w perm: /var/sieve, dir owned by 101:12 mode=0755)
Apr 12 18:06:48 lmtp(user@domain.tld)<16280><AMpJFCgt+meYPwAAWIEZlA>: Error: sieve: The LDA Sieve plugin does not have permission to save global Sieve script binaries; global Sieve scripts like `/var/sieve/globalfilter.sieve' need to be pre-compiled using the sievec tool

15

E-Mail / Re: Email ids under 1 user not receiving emails

« on: April 12, 2025, 08:22:29 AM »

Code: [Select]

chown -R vmail:mail /var/mail
chmod -R 755 /var/vmail

Now getting the bellow errors for all webmail logins

Connection to storage server failed.
Server Error: AUTHENTICATE PLAIN: Authentication failed.