Topics

1

Backup / Backup command

« on: November 13, 2014, 07:08:22 PM »

When the backup script is running, the following recursive rsync command is used if a remote connection is available and enabled:

Code: [Select]

ionice -c 3 nice -n +19 /usr/bin/rsync -avzr --deletebut if a remote connection is not available or not enabled, the following non recursive command is used without ionice:

Code: [Select]

/usr/bin/rsync -avz --no-o --no-g --deleteThe latter needs to be fixed as:

Code: [Select]

ionice -c 3 nice -n +19 /usr/bin/rsync -avzr --no-o --no-g --deleteThis happens when we observe the cwp cron running the file:

Code: [Select]

/usr/local/cwpsrv/resources/admin/include/cron_backup.php

2

Installation / Roundcube Apache Config is missing

« on: November 09, 2014, 08:15:03 PM »

The following stanza is missing in cwp-latest script:

Code: [Select]

cat <<'EOF' > /usr/local/apache/conf.d/roundcube.conf
Alias /webmail /usr/local/apache/htdocs/roundcube

<Directory /usr/local/apache/htdocs/roundcube>
  Options -Indexes
  AllowOverride All
</Directory>

<Directory /usr/local/apache/htdocs/roundcube/config>
  Order Deny,Allow
  Deny from All
</Directory>

<Directory /usr/local/apache/htdocs/roundcube/temp>
  Order Deny,Allow
  Deny from All
</Directory>

<Directory /usr/local/apache/htdocs/roundcube/logs>
  Order Deny,Allow
  Deny from All
</Directory>
EOF


The above has been adapted from:
http://trac.roundcube.net/wiki/Howto_Install

The RoundCube WebMail link in the Web Interface can be adjusted for uniformity or left as is since the URL http://domain.or.ip/webmail is only an alias.

Furthermore, the RoundCube v1.0.3 and the one from the GitHub master are working as well with two variables being different for sed substitution and two config files clubbed as one new one instead.

3

CentOS-WebPanel Bugs / Error on blank file edit

« on: November 05, 2014, 06:43:42 PM »

On the demo page, the following URL gives an error on missing file or blank file:
https://185.4.149.65:2031/index.php?module=file_editor&file=/usr/local/apache/conf.d/empty.conf

Warning: fread(): Length parameter must be greater than 0 in /usr/local/cwpsrv/htdocs/resources/admin/modules/file_editor.php(1) : eval()'d code(1) : eval()'d code on line 18
Could not read file!

There is a confusion between 0 length and boolean false in some if check.

4

Installation / settings table to be pivoted

« on: November 05, 2014, 05:57:34 PM »

The settings table in root_cwp db has only 1 record having 1 field for each setting. As settings increase, these fields will soon increase. Best to have 3 fields - param_name, param_value, param_attribute where the last can be a json/serialised value. Then there can be several records - 1 for each param_name. hence we can have specific queries like "SELECT * FROM settings WHERE param_name='shared_ip';". Pivoting the table this way will make for other relationships later.

5

Installation / Install time reduction

« on: November 05, 2014, 05:52:37 PM »

The apache and php source files take time to download and along with apr and apr-util are being downloaded twice - once for the apache (/tmp/apache-build and /tmp/php-build) and another time for the cwpsrv (/usr/local/src). These files can be copied over if they exist in the first download locations to the second one. Compilation too takes upto 40 minutes for a full install on a VPS with a fast internet connection. Any RPM based installs to save time?

6

Installation / Redundant MySQL queries

« on: November 05, 2014, 05:48:14 PM »

There are atleast two sets of "SELECT * FROM settings;" and a subsequent resultset taken into a $row variable in the cwpsrv php files in each module's page even when there is no use for them. Turn on MySQL logging and you will see a huge flurry of SQLs churning out.

This slows down access to the Panel.

7

CentOS-WebPanel Bugs / cwp-latest fix for file deletion

« on: November 04, 2014, 10:31:14 PM »

Line 286 in cwp-latest script file:

Code: [Select]

rm -f cwp_test.zip
should be

Code: [Select]

rm -f cwp_test_093.zip

There is a cwp_test_094.zip file also available but it does not have the jcterm.jar and other jar files.
jcterm bundled in is v0.0.10 whereas v0.0.11 was out a couple of years ago!

sinfo.sh checks for "php -v" even when php is not installed as yet....

apr_util v1.5.3 is used. apr_util v1.5.4 works okay.

phpMyAdmin v4.0.8 is used. phpMyAdmin v4.0.10.5 (LTS till Jan 2017) works and so does v4.1.14.6 but the v4.2.x series does not work as it expects MySQL v5.5 where mysqli is no longer used.

RoundCube v0.8.5 is used. v0.9.5 works fine on it. Why can the root user's mail not be accessible in RoundCube?

We need atleast 1 domain to add a user. We need atleast 1 user to assign a domain. Chcken and egg? Which is optional?

If a service is running, why provide the start button (better grey it out). Same for when it is stopped.


Why are the cwp_test_093.zip's php file obfuscated? It really slows things a lot when regular files like phpinfo.php have to be used frequently. Just encrypt the files that have the salt and other rkey type stuff. This also makes debugging difficult.