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.
61
E-Mail / Re: Roundcube - Connection to storage server failed.
« on: May 01, 2017, 10:15:00 AM »
This is how you fix it:
Check the log:
tail /var/log/dovecot.log
if you see : Fatal: Unknown database driver 'mysql'
Meaning missing package! Dovecot requires the dovecot-mysql package to run mysql authentication. This problem is simply cured by installing it with yum:
yum install dovecot-mysql
Check the log:
tail /var/log/dovecot.log
if you see : Fatal: Unknown database driver 'mysql'
Meaning missing package! Dovecot requires the dovecot-mysql package to run mysql authentication. This problem is simply cured by installing it with yum:
yum install dovecot-mysql
63
SSL / Re: Can't install Let's Encrypt SSL on admin for CWP7 - need assistance.
« on: April 29, 2017, 04:57:22 PM »
Follow this:
- Go to SSL certificate manager > SSL generator
Then generate your certificate
- Get back to let's encrypt and install it manually
- Go to SSL certificate manager > SSL generator
Then generate your certificate
- Get back to let's encrypt and install it manually
64
MySQL / Re: CWP CentOS 7 installer with MySQL without MariaDB
« on: April 29, 2017, 03:29:16 PM »
No, you should not remove Mariadb, you will get many errors in web panel.
65
Updates / Re: Disable auto-updater
« on: March 28, 2017, 03:09:22 AM »
I come to this topic because I also want to disable the auto-update, this process usually break my custom configuration on my production server. Here is how you disable the updater:
nano /usr/local/cwpsrv/htdocs/resources/scripts/update_cwp
put # at beginning of each lines in it
nano /usr/local/cwpsrv/htdocs/resources/scripts/update_cwp
put # at beginning of each lines in it
66
Postfix / Re: Postfix: Can't add email account
« on: March 27, 2017, 06:10:25 AM »
After an auto-update of CWP, I dont know what is the reason I lost the user postfix in mysql
This is how i fixed it, run this SQL as root
GRANT ALL PRIVILEGES ON postfix.* TO 'postfix'@'localhost' IDENTIFIED BY 'YOUR_PASSWORD' WITH GRANT OPTION;
Then, the configuration of postfix file was also changed its location, we need to copy from old location and put it back in right place
put your new password in the file
This is how i fixed it, run this SQL as root
GRANT ALL PRIVILEGES ON postfix.* TO 'postfix'@'localhost' IDENTIFIED BY 'YOUR_PASSWORD' WITH GRANT OPTION;
Then, the configuration of postfix file was also changed its location, we need to copy from old location and put it back in right place
Quote
sudo chattr -i /usr/local/cwpsrv/htdocs/admin
mkdir /usr/local/cwpsrv/htdocs/admin/include/
mv /usr/local/cwpsrv/htdocs/resources/admin/include/postfix.php /usr/local/cwpsrv/htdocs/admin/include/postfix.php
nano /usr/local/cwpsrv/htdocs/admin/include/postfix.php
put your new password in the file
67
MySQL / Re: CWP INSTALL without MARIADB as default
« on: March 26, 2017, 11:06:13 AM »you can manually install mysql by removing mariadb
Not compatible!
http://prnt.sc/eolgxk , and may other errors in CWP version: 0.9.8.196 + MySQL 5.7
68
MySQL / Re: CWP CentOS 7 installer with MySQL without MariaDB
« on: March 26, 2017, 10:50:34 AM »
OMG I'm facing this problemtoo ! How come you guys drop support MySQL and replace it by MariaDB ! this is wrong move though.
All my database is in MySQL version 5.7 and it's not easy to convert to MariaDB !
I removed Mariadb, installed MySQL 5.7, and got many weird errors in CWP (on browser)
http://prnt.sc/eolgxk
All my database is in MySQL version 5.7 and it's not easy to convert to MariaDB !
Quote
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json DEFAULT NULL,
I removed Mariadb, installed MySQL 5.7, and got many weird errors in CWP (on browser)
http://prnt.sc/eolgxk
69
CentOS 6 Problems / CWP & Mysql 5.7 bug
« on: March 26, 2017, 10:43:33 AM »
Thank you for your hard work to update the software, however how come you drop support MySQL server and suddenly replace by MariaDB, this is lead to bunch of issues due to all my databases are on Mysql version 5.7
I must remove MariaDB and manually install Mysql SQL 5.7 (MariaDB does not support JSON column data type which is exist in my current databases) , then I got this error is CWP
Please have a look on this screenshot :
http://prnt.sc/eolgxk
I'm trying to convert my database to follow up your update due to MariaDB is default Mysql engine ! Hope this help you to spot the issue of CWP. Thanks
I must remove MariaDB and manually install Mysql SQL 5.7 (MariaDB does not support JSON column data type which is exist in my current databases) , then I got this error is CWP
Please have a look on this screenshot :
http://prnt.sc/eolgxk
I'm trying to convert my database to follow up your update due to MariaDB is default Mysql engine ! Hope this help you to spot the issue of CWP. Thanks
70
CentOS 6 Problems / Re: MySQL Daemon failed to start
« on: March 26, 2017, 05:00:05 AM »
If you are facing the problem 'Access denied for user root' , you need to reset your root password
start mysql service in safe mode
run SQL commands
Note: your password must have enough security level (capital letter, small letter, number,and special character *#..)
update your CWP password, the location of theses files:
/usr/local/cwpsrv/htdocs/resources/admin/include/db_conn.php
/root/.my.cnf
Note: change your password in two files above
Finally, start your mysqld
service mysqld start
Or reboot your server if necessary
start mysql service in safe mode
Quote
service mysqld stop
mysqld_safe --skip-grant-tables
run SQL commands
Quote
use mysql;
SET GLOBAL default_password_lifetime = 0;
SET PASSWORD = PASSWORD('YOUR_PASSWORD_HERE');
FLUSH PRIVILEGES;
Note: your password must have enough security level (capital letter, small letter, number,and special character *#..)
update your CWP password, the location of theses files:
/usr/local/cwpsrv/htdocs/resources/admin/include/db_conn.php
/root/.my.cnf
Quote
nano /usr/local/cwpsrv/htdocs/resources/admin/include/db_conn.php
nano /root/.my.cnf
Note: change your password in two files above
Finally, start your mysqld
service mysqld start
Or reboot your server if necessary
71
CentOS 6 Problems / Re: MySQL Daemon failed to start
« on: March 25, 2017, 08:39:39 PM »
Just remove mysql and reinstall it
Go ahead if you want to Upgrage to 5.7
Quote
service mysqld stop
yum remove mysql
yum --enablerepo=remi install mysql-server
service mysqld start
Go ahead if you want to Upgrage to 5.7
Quote
service mysqld stop
yum install http://dev.mysql.com/get/mysql57-community-release-el6-7.noarch.rpm
yum install mysql
service mysqld start
mysql_upgrade
chkconfig mysqld on
72
FTP / Re: how to change ftp port
« on: March 23, 2017, 03:08:40 PM »
nano /etc/pure-ftpd/pure-ftpd.conf
It's in there
It's in there
73
FTP / Re: Access Denied for the user after be reactived
« on: March 23, 2017, 03:00:13 PM »
I also had same issue
Centos 6.8
Apache version: Apache/2.4.25
PHP version: 5.6.30
MySQL version: 10.1.22-MariaDB
FTP version: 1.0.30
You try to do this
Comment out this line (Added # at begining of the line)
Enable UNIX authentication
Restart
Then you try to change the password of the user in CWP (on browser)
Centos 6.8
Apache version: Apache/2.4.25
PHP version: 5.6.30
MySQL version: 10.1.22-MariaDB
FTP version: 1.0.30
You try to do this
Quote
nano /etc/pure-ftpd/pure-ftpd.conf
Comment out this line (Added # at begining of the line)
Quote
#PAMAuthentication yes
Enable UNIX authentication
Quote
UnixAuthentication yes
Restart
Quote
service pure-ftpd restart
Then you try to change the password of the user in CWP (on browser)
74
Installation / Re: Installation FAILED at pure-ftpd
« on: March 22, 2017, 02:47:31 AM »
I think you should try
yum update -y
reboot
then install CWP
yum update -y
reboot
then install CWP
75
Installation / Re: How to install ruby and rails
« on: March 22, 2017, 02:45:05 AM »
Install Ruby
install ruby gem
Ruby on rail
Or check this URL for latest version : http://rubyonrails.org/
Quote
sudo yum install -y ruby
install ruby gem
Quote
yum install -y ruby-devel ruby-irb ruby-rdoc ruby-ri
wget https://rubygems.org/rubygems/rubygems-2.6.11.zip
unzip https://rubygems.org/rubygems/rubygems-2.6.11.zip
cd rubygems-2.6.11
ruby setup.rb
Ruby on rail
Quote
gem install rails -v 5.1.0.rc1
Or check this URL for latest version : http://rubyonrails.org/
