Messages

16

PHP / Re: Does anybody knows how?

« on: March 27, 2018, 12:06:55 AM »

I've figured out to install the module by login into ssh and type (centos 6.7 64 bits)

 pecl install stats

installation went ok.
in fact it showed the following:
"Build process completed successfully
 Installing '/usr/local/lib/php/extensions/no-debug-non-zts-20131226/stats.so'
 install ok: channel://pecl.php.net/stats-1.0.5
 configuration option "php_ini" is not set to php.ini location
 You should add "extension=stats.so" to php.ini"

I've added at the end of php.ini (in Centoswebpanel at the php.ini configuration) this: extensions=stats.so
then restarted httpd service and Voila!
hope this helps to others!

17

PHP / Does anybody knows how?

« on: March 26, 2018, 11:14:38 PM »

Hi!
Need to install this php lib http://php.net/manual/en/book.stats.php
how should I do it? using php selector and adding it in flags " with--stats" ?
or there is another way?

any help will be apreciated!

Thanks!
freddo

18

Apache / how to switch from mpm_event_module to mpm_prefork

« on: July 18, 2017, 04:36:26 PM »

Hi,
I´ve got to solve this..

Installed 3 servers with  CWP version: 0.9.8.259 on Centos 6.9 2  unsing Apache 2.4.26 each server has 2 cores & 8 gb RAM (all the same)

Their main task: just webserver 1 site, mysql is installed in another server and I´m using CloudFlares CDN and a LoadBalancer.. all works fine.. but im having this issue...

Initially I´ve left the three servers with default configs, so each server only has apache and mpm_envent_module with default config..

Suddenly apache stop to work, the cpu usage drops near to 0% (when running normaly they are between 10-15% cpu use).. this happened on differnt times on the three servers..

so I stop apache service..(takes a minute or two to stop) and when try to start it just stands there... so I have no other choice to reboot server..and then return to normal..  all this from from ssh.. not from cwp.
 
Checking apache error logs. I´ve spoted this "[mpm_event:error][pidxxxx]Script timeout before returning headers: index.php
[mpm_event:error]AH00484 server Reached MaxRequestsWorkers setting, Consider raising the MaxRequestsWorkes setting]

so, I´ve uncoment '#' at the Include/conf/extra/httpd-mpm.conf at httpd.conf and then edited the httpd-mpm.conf.. there I´ve set this values.. ThreadsPerChild 50 and MaxRequestsWorkers 800 (default was 400)

restarted apache.. hoping this might solve the issue.. but after a few hours got the same behaviour..

so, in only one of the servers I´ve installed Ngnix and apache... hoping this solves it..

Installation went ok.. but now this server shows me a Bad Gateway (502) screen after 1 hour of running... and I have to reboot it..

Reading on the web mentioned that this could be a bug..of the mpm_event.. so decide to try with mpm_prefork.. but I´m unable to find a way to enable it? how can I do that? I´m just trying this only on one server, the one who has ngnix .. and if it fixes the issue then I´ll update the others..

Can anyone assit? or give me a hint regarding my issue?


thanks!







if I try to access to the webpage located at the server I just got a blank page..eventually a cloudflares showsme that my server is down...

19

FTP / Re: sftp for a ftp users

« on: June 29, 2017, 09:13:46 PM »

Hi I´ve installed CWP, created an User and a domain..

I can connect via FTP and SFTP using the CWP account user (I also enabled the  /usr/libexec/openssh/sftp-server at SECURITY )

I´ve created 2 FTP users for the account.. (so now I have a total of three users: CWP account user, ftp_user1 and ftp_user2 )
with ftp_user1 and ftp_user2 I can connect via FTP with NO problem..

But, I can´t connect via SFTP with those users.. How can I fix that?  I keep having access denied, and in the secure logs its says: unknown user ... so Im guessing that the ftp user I´ve created is not been validated to use SFTP.. ??

Need those 2 ftp users access through sftp..

Thanks!

Anyone ? really need to fix this.. thanks!

20

FTP / sftp for a ftp users

« on: June 29, 2017, 04:05:43 PM »

Hi I´ve installed CWP, created an User and a domain..

I can connect via FTP and SFTP using the CWP account user (I also enabled the  /usr/libexec/openssh/sftp-server at SECURITY )

I´ve created 2 FTP users for the account.. (so now I have a total of three users: CWP account user, ftp_user1 and ftp_user2 )
with ftp_user1 and ftp_user2 I can connect via FTP with NO problem..

But, I can´t connect via SFTP with those users.. How can I fix that?  I keep having access denied, and in the secure logs its says: unknown user ... so Im guessing that the ftp user I´ve created is not been validated to use SFTP.. ??

Need those 2 ftp users access through sftp..

Thanks!

21

Installation / Re: ayuda envió de correos

« on: May 26, 2017, 06:09:14 PM »

hola..
Por lo q estas describiendo, el problema no es del CWP sino del tipo de configuración q tenes en los DNS q estas usando para el o los dominios en cuestion.. Estas usando el DNS de cwp u otro? tenes creado registro mx? spf?

El mail te llega  a otras cuentas que no esten alojadas en gmail? yahoo? Si llegan a destino, pero no a gmail y yahoo es porque debe estarte faltando configuraciones como ser registro spf.. sino te esta llegando ningun mail corrobora q tenes habilitado los puertos 25,465,110.. en firewall..

saludos

22

MySQL / Re: Instructions for fixing roundcube issues

« on: May 26, 2017, 01:58:14 PM »

If you get this error message on your roundcube link:

Code: [Select]

DATABASE ERROR: CONNECTION FAILED!
Unable to connect to the database!
Please contact your server-administrator.
Check roundcube logs in file: /usr/local/cwpsrv/var/services/roundcube/logs/errors

In case that your error looks like this

Code: [Select]

[17-May-2017 20:18:11 +0000]: <gv4343g> DB Error: SQLSTATE[HY000] [1045] Access denied for user 'roundcube'@'localhost' (using password: YES) in /usr/local/cwpsrv/var/services/roundcube/program/lib/Roundcube/rcube_db.php on line 173 (GET /roundcube/)
[17-May-2017 20:18:11 +0000]: <gv4343g> DB Error: SQLSTATE[HY000] [1045] Access denied for user 'roundcube'@'localhost' (using password: YES) (GET /roundcube/)
Check the password set in roundcube config in file /usr/local/cwpsrv/var/services/roundcube/config/config.inc.php

Code: [Select]

grep db_dsnw /usr/local/cwpsrv/var/services/roundcube/config/config.inc.php
Output will be like this

Code: [Select]

$config['db_dsnw'] = 'mysqli://roundcube:42Etn3fd7skc@localhost/roundcube';** This means that your password is 42Etn3fd7skc

Now lets set the same in mysql.

Code: [Select]

mysql -e "SET PASSWORD FOR 'roundcube'@'localhost' = PASSWORD('42Etn3fd7skc');"
mysql -e "FLUSH PRIVILEGES;"
Now again check if roundcube works.

In case you get this error:

Code: [Select]

[17-May-2017 20:29:09 +0000]: <gv91fd30g> DB Error: [1146] Table 'roundcube.session' doesn't exist (SQL Query: SELECT `vars`, `ip`, `changed`, now() AS ts FROM `session` WHERE `sess_id` = 'gv93bfdsfdffdfdj3') in /usr/local/cwpsrv/var/services/roundcube/program/lib/Roundcube/rcube_db.php on line 539 (GET /roundcube/)

run this command

Code: [Select]

mysql -u root 'roundcube' < /usr/local/cwpsrv/var/services/roundcube/SQL/mysql.initial.sqlthat is it, enjoy your roundcube.

HI, I´ve ran the command # mysql -u root 'roundcube' < /usr/local/cwpsrv/var/services/roundcube/SQL/mysql.initial.sql
but i get..
ERROR 1146 (42S02) at line 8: Table 'roundcube.session' doesn't exist

how can I fix this?
Thanks (Im using Centos 6.8 CWP 0.9.8.239 (with mysql not maria db)

I´ve fix the roundcube issue... it turned out that although roundcube database existed in the server.. I couldn´t access to any of it´s tables.. so I´ve erased the rondcube table, then created a new one and the I executed the script..mysql -u root 'roundcube' < /usr/local/cwpsrv/var/services/roundcube/SQL/mysql.initial.sql

and voila! now it's working! hope this update help others...

Cheers!

23

MySQL / Re: Instructions for fixing roundcube issues

« on: May 24, 2017, 02:42:56 PM »

If you get this error message on your roundcube link:

Code: [Select]

DATABASE ERROR: CONNECTION FAILED!
Unable to connect to the database!
Please contact your server-administrator.
Check roundcube logs in file: /usr/local/cwpsrv/var/services/roundcube/logs/errors

In case that your error looks like this

Code: [Select]

[17-May-2017 20:18:11 +0000]: <gv4343g> DB Error: SQLSTATE[HY000] [1045] Access denied for user 'roundcube'@'localhost' (using password: YES) in /usr/local/cwpsrv/var/services/roundcube/program/lib/Roundcube/rcube_db.php on line 173 (GET /roundcube/)
[17-May-2017 20:18:11 +0000]: <gv4343g> DB Error: SQLSTATE[HY000] [1045] Access denied for user 'roundcube'@'localhost' (using password: YES) (GET /roundcube/)
Check the password set in roundcube config in file /usr/local/cwpsrv/var/services/roundcube/config/config.inc.php

Code: [Select]

grep db_dsnw /usr/local/cwpsrv/var/services/roundcube/config/config.inc.php
Output will be like this

Code: [Select]

$config['db_dsnw'] = 'mysqli://roundcube:42Etn3fd7skc@localhost/roundcube';** This means that your password is 42Etn3fd7skc

Now lets set the same in mysql.

Code: [Select]

mysql -e "SET PASSWORD FOR 'roundcube'@'localhost' = PASSWORD('42Etn3fd7skc');"
mysql -e "FLUSH PRIVILEGES;"
Now again check if roundcube works.

In case you get this error:

Code: [Select]

[17-May-2017 20:29:09 +0000]: <gv91fd30g> DB Error: [1146] Table 'roundcube.session' doesn't exist (SQL Query: SELECT `vars`, `ip`, `changed`, now() AS ts FROM `session` WHERE `sess_id` = 'gv93bfdsfdffdfdj3') in /usr/local/cwpsrv/var/services/roundcube/program/lib/Roundcube/rcube_db.php on line 539 (GET /roundcube/)

run this command

Code: [Select]

mysql -u root 'roundcube' < /usr/local/cwpsrv/var/services/roundcube/SQL/mysql.initial.sqlthat is it, enjoy your roundcube.

HI, I´ve ran the command # mysql -u root 'roundcube' < /usr/local/cwpsrv/var/services/roundcube/SQL/mysql.initial.sql
but i get..
ERROR 1146 (42S02) at line 8: Table 'roundcube.session' doesn't exist

how can I fix this?
Thanks (Im using Centos 6.8 CWP 0.9.8.239 (with mysql not maria db)

24

CentOS 6 Problems / Re: Fresh Centos 6 and CWP install

« on: April 23, 2017, 02:37:00 PM »

All looks good, uninstalled MODSECURITY, subdomain started to work. Havent got any Not found link yet, but its Friday, so will check  later this weekend or on Monday.

So I guess ther is a need to add the rules for mod security....

Thank you fredo for trying to understand my problem... 

You´re Welcome..! glad that you could solve it!

25

CentOS 6 Problems / Re: Fresh Centos 6 and CWP install

« on: April 21, 2017, 01:18:06 PM »

Tested on 2 domain, created new subdomain, the problem is the same...

Why this happens? Do I need to delete all my domains and user accounts to fix this???

it's hard to say.. I´m trying to follow you.. but I don´t understand if what you say about that "the problem is the same" you are tellling that when you access to a subdomain, it redirects to the main domain... or when you try to access to the subdomain it says 404 not found... which one is it?

If you have the domain and subdomain active, what does your apache logs shows??

26

CentOS 6 Problems / Re: Fresh Centos 6 and CWP install

« on: April 20, 2017, 06:53:07 PM »

Of course I tryed fix permissions.
Yes, I have added 5-7 domains, they work. Problem is with the subdomains.
I have a fixed IP and a local ip set.

The strange part was that domain starting with a and my subdomain started with w, so a first and w subdomain last, I got redirected from subdomain w to domain a.

Deleted domain a. So now having Not found for that subdomain.... strange... DNS issue?
Delete all data (domains, mysql, dns records) and add them once again? I think it wont help.

One more thing that I did at mysql was that there was a warning about that you need to set something at operational layout... dont remember, but it created automaticaly when I pressed fix or something that it was offering...

More Ideas what to try???

mmm... sorry to ask, but ... did you use the correct path for the subdomain? what you´ve mentioned about being redirected it clearly states that something is not well set.. try with something simple.. create a domain.. like for example "test1.com" and then add a subdomain to that site, like site.test1.com..

Add a php file w/something to show U that you are at the main page and place it to the HOME/USER/PUBLIC_HMTL directory
then add another php file but to the subdomain directory.. depending what path you have created on the CWP as I´m
showing you below, the path could be HOME/USER/PUBLIC_HTML/SUBDOMAIN (if you have used the last opption mentioned below)



Path must be /home/USERNAME eg. /home/mywebsite/...
If you enter / than the home path will be eg. /home/mywebsite/
If you enter /public_html/subdomain1 than the path will be /home/mywebsite/public_html/subdomain1

27

CentOS 6 Problems / Re: Fresh Centos 6 and CWP install

« on: April 20, 2017, 05:03:09 PM »

So changed php one version before to 7.1.3.
Uninstalled modsecurity, no effect with or without.

So the strange part is that subdomain page works, then not found, after 5-8 time F5 it starts again, then responds, after some while it hand, works, hangs and so on... and also with fresh install it is the same....

Any solution, ideas were to look or how to fix it??? Can someone reply a bit earlier then 12-24h...

mmm.. I don´t think that your issue is a php problem..

Did you use the "fix permission" module in CWP (its in users accounts)? also have you already delegated a domain on your server? or you are accesing via IP ?

28

CentOS 6 Problems / Re: Fresh Centos 6 and CWP install

« on: April 19, 2017, 06:07:04 PM »

Hello

Just installed centos 6.5, updated to 6.9 final, installed cwp (now CWPpro version: 0.9.8.219), everything was fine until added subdomains.

They just brake, the links show

Not Found

The requested URL /wp-admin/admin.php was not found on this server.

Added NAT, rebuild apache...before, fresh wordpress install.... any ideas? help?

Not found... checked the apache logs? could be a permission issue.

29

MySQL / Re: CWP INSTALL without MARIADB as default

« on: April 18, 2017, 08:41:08 PM »

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

did you ran mysql upgrade command ?

Hi, Sandeep.. I´ve installed latest cwp on a testing vps on AWS..just to try this..

Of course it installed MariaDB as default..once it finished and rebooted..I went again via ssh..

Then I ran yum remove MariaDb-*

it removed Mariadb server, client, etc from server..ok..

Then I've installed MySql in server.. after it finished, started the service..

after that, I enter "mysql_upgrade --upgrade-system-tables"..

once it finished that, I entered to the mysql console...

typed "SELECT COUNT(1) column_count FROM information_schema.columns WHERE table_schema='mysql' AND table_name='user';"

I know I should have a 43 columns count.. but instead I got, 46.. the "extra" rows are the following...

mysql user is_role 44
mysql user default_role 45
mysql user max_statement_time 46

After seeing that.. I entered to CWP, and saw that pure-ftp has a sort of yellow moon icon..and it didn´t state that service was runnning.. only showed that icon.. so, I followed instructions to reinstall pure-ftpd server.. via ssh... once it finished.. went back to cwp,pure-ftpd has no longer that "moon Icon" and was up and running...  so I created a new account, (after created a package of course) set the password for that account...tried to access via FTP... "wrong user or password".. mmm tried again after changing users pass..same story... then I checked mysqld.log.. it showed that /usr/sbin/mysqld: column count of mysql.user is wrong expected 43, found 46 The table is probably corrupted...

So, I've figured that changing MariaDB to MySQL also affected CWP services..
 
Tried a couple of things.. like, removing mysql server again, reinstall it, then ran mysql upgrade but that didn´t fix the count column number, nor the pure-ftpd... so to make story short...

Although MariaDB was removed, and Mysql server installed in CWP latest version,and it was up and running... I kept having on mysqld.log those warnings mentioned above.. also I was not able to connect to pure-ftpd server with the user and pass of the account I made before.

So, is there a solution for this? in many topics it was suggested here that if we don´t want MariaDB, we can always uninstall it, and install Mysql instead.. though never thought I would have so much trouble with this..

Thanks for the help..

30

Installation / Re: Using CWP with Amazon RDS

« on: April 18, 2017, 01:47:14 PM »

Hi Pramod,
No, I haven´t done that yet.. but I guess, that you shouldn´t have any sort trouble, as long as you open port 3306 to connect the EC2 to the RDS..
What I´ve done is very similar.. I had 4 EC2 instances, (1 web server with CWP installed, 2 web servers - only with apache  - and 1 ec2 With MySql).. It worked all fine!

cheers!