Messages

46

E-Mail / Re: Stop forwarding SPAM emails

« on: April 24, 2025, 06:10:13 AM »

- Ensure SpamAssassin is enabled, and set it to drop spam or send to spambox (do not use "deliver to inbox"). At a minimum, use "drop high scoring spam".

Any Guidance on how to set these in CWP?

47

E-Mail / Stop forwarding SPAM emails

« on: April 23, 2025, 10:31:54 AM »

Some of my users have created email forwards

I see in postfix q that many SPAM emails coming to these emails getting forwarded.

This has resulted in my IP getting blacklisted with email providers like Microsoft

How to stop SPAM emails getting forwarded?

48

MySQL / Re: mySQL user

« on: April 17, 2025, 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

49

MySQL / Re: mySQL user

« on: April 17, 2025, 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.

50

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

« on: April 17, 2025, 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

51

MySQL / Re: root password change

« on: April 17, 2025, 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

52

MySQL / root password change

« on: April 17, 2025, 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

53

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.

54

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

55

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

 

56

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

57

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

58

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

59

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

60

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