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.
31
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
And now CWP panel is not working
Quote
[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
32
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.
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.
33
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
34
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
35
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
36
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
37
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
38
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
I have encountered many times many renewals have failed.
If we can run renew automatically once in a while, it wlll be useful
39
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
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
40
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
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
41
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.
42
MySQL / Re: mySQL user
« on: April 12, 2025, 08:05:00 AM »
Yes. This is happening as you mentioned.
But when I login with a db user at https://yourserver.tld:2087/pma/, I am getting access to all other users DBs
But when I login with a db user at https://yourserver.tld:2087/pma/, I am getting access to all other users DBs
Definitely not how my server behaves. I login to the /pma link as a user account with their password and I can only see the DB that the user owns, not the extent of the full server-wide DB.
When under a user control panel, you go to the Databases > phpMyAdmin link:
https://yourserver.tld:2083/cwp_SESSIONID/username/?module=pma
should forward you to:
https://yourserver.tld:2087/pma/index.php?route=/&route=%2F
Is that what you see happening? And what if you directly load PMA?
https://yourserver.tld:2087/pma/
Do you get a login screen where you can login as a user?
43
E-Mail / Re: Email ids under 1 user not receiving emails
« on: April 11, 2025, 04:09:59 PM »
Tried after seeing your message
No luck
No luck
And you tried suspending, then un-suspending the account?
44
CentOS-WebPanel GUI / MySQL db and user creation error
« on: April 11, 2025, 03:46:46 PM »
Logged in as a user. Tried adding a new database along with user. Got successfully created database message (green). But the list of databases and list of users shower empty.
Curiously logged in as admin to see database _test and user _test is created without username prefix
Please suggest
https://ibb.co/Z1wM1vw7
Curiously logged in as admin to see database _test and user _test is created without username prefix
Please suggest
https://ibb.co/Z1wM1vw7
45
E-Mail / Email ids under 1 user not receiving emails
« on: April 10, 2025, 06:06:51 AM »
All was working fine
Suddenly all email ids under a user stopped recieving emails (Has multiple domains)
I checked for quota, increased quota. No use
The folder permissions under var/vmail/domainname has
user | mail | 751
maillog do not have the record of missing incoming emails
Please guide
Suddenly all email ids under a user stopped recieving emails (Has multiple domains)
I checked for quota, increased quota. No use
The folder permissions under var/vmail/domainname has
user | mail | 751
maillog do not have the record of missing incoming emails
Please guide
