Changeset 1057
- Timestamp:
- 03/14/08 16:42:33
(9 months ago)
- Author:
- rats
- Message:
see CHANGELOG!
ispCP 1.0.0 RC4 ready for release?
-
Files:
-
Legend:
- Unmodified
- Added
- Removed
- Modified
- Copied
- Moved
| r1056 |
r1057 |
|
| 4 | 4 | 2008-03-13 Benedikt Heintel |
|---|
| 5 | 5 | - SETUP: |
|---|
| | 6 | * Fixed #942: ERROR: Undefined intput data, bt: |{PHP_VERSION}|, et: |{PHP_VERSION}|, src ! |
|---|
| | 7 | * Fixed #1097: (quick fix) ispcp-vrl-traff-correction generates high load on mysql db -> DB locked |
|---|
| 6 | 8 | * Fixed #1106: BSDmakefile Setup not copy some of its file |
|---|
| 7 | 9 | * Updated: a lot of Makefiles |
|---|
| r994 |
r1057 |
|
| 20 | 20 | cp ./httpd.conf $(SYSTEM_CONF)/apache/working/ispcp.conf |
|---|
| 21 | 21 | cp ./httpd.conf $(SYSTEM_CONF)/apache/parts/ispcp_base.tpl |
|---|
| | 22 | cp ./fastcgi.conf $(SYSTEM_CONF)/apache/working/fastcgi_ispcp.conf |
|---|
| 22 | 23 | |
|---|
| 23 | 24 | cp -R $(SYSTEM_CONF)/apache/working/fastcgi_ispcp.conf $(ROOT_APACHE_CONF)/mods-available/fastcgi_ispcp.conf |
|---|
| r1011 |
r1057 |
|
| 20 | 20 | cp ./httpd.conf $(SYSTEM_CONF)/apache/working/ispcp.conf |
|---|
| 21 | 21 | cp ./httpd.conf $(SYSTEM_CONF)/apache/parts/ispcp_base.tpl |
|---|
| | 22 | cp ./fastcgi.conf $(SYSTEM_CONF)/apache/working/fastcgi_ispcp.conf |
|---|
| 22 | 23 | |
|---|
| 23 | | cp ./fastcgi.conf $(SYSTEM_CONF)/apache/working/fastcgi_ispcp.conf |
|---|
| 24 | 24 | cp ./fastcgi.conf $(SYSTEM_CONF)/apache/conf.d/fastcgi_ispcp.conf |
|---|
| 25 | 25 | |
|---|
| r998 |
r1057 |
|
| 19 | 19 | cp ./httpd.conf $(SYSTEM_CONF)/apache/working/ispcp.conf |
|---|
| 20 | 20 | cp ./httpd.conf $(SYSTEM_CONF)/apache/parts/ispcp_base.tpl |
|---|
| 21 | | |
|---|
| 22 | 21 | cp ./fastcgi.conf $(SYSTEM_CONF)/apache/working/fastcgi_ispcp.conf |
|---|
| 23 | 22 | |
|---|
| r1007 |
r1057 |
|
| 17 | 17 | cp -R ./parts $(SYSTEM_CONF)/apache |
|---|
| 18 | 18 | cp -R ./working $(SYSTEM_CONF)/apache |
|---|
| | 19 | |
|---|
| 19 | 20 | cp ./httpd.conf $(SYSTEM_CONF)/apache/working/ispcp.conf |
|---|
| 20 | 21 | cp ./httpd.conf $(SYSTEM_CONF)/apache/parts/ispcp_base.tpl |
|---|
| 21 | | cp -R ./working/fastcgi_ispcp.conf ${ROOT_APACHE_CONF}/mods-available/fastcgi_ispcp.conf |
|---|
| | 22 | cp ./fastcgi.conf $(SYSTEM_CONF)/apache/working/fastcgi_ispcp.conf |
|---|
| | 23 | |
|---|
| | 24 | cp -R fastcgi.conf ${ROOT_APACHE_CONF}/mods-available/fastcgi_ispcp.conf |
|---|
| 22 | 25 | |
|---|
| 23 | 26 | uninstall: |
|---|
| r1056 |
r1057 |
|
| 53 | 53 | if ($main::db_pass_key eq '{KEY}' || $main::db_pass_iv eq '{IV}') { |
|---|
| 54 | 54 | |
|---|
| 55 | | print STDERR "\tGenerating database keys, it may take some time, please wait...\n"; |
|---|
| | 55 | print STDOUT "\tGenerating database keys, it may take some time, please wait...\n"; |
|---|
| | 56 | print STDOUT "\tIf it takes to long, please check http://www.isp-control.net/documentation/frequently_asked_questions/what_does_generating_database_keys_it_may_take_some_time_please_wait..._on_setup_mean\n"; |
|---|
| 56 | 57 | |
|---|
| 57 | 58 | $rs = sys_command("perl $main::cfg{'ROOT_DIR'}/keys/rpl.pl $main::cfg{'GUI_ROOT_DIR'}/include/ispcp-db-keys.php $main::cfg{'ROOT_DIR'}/engine/ispcp-db-keys.pl $main::cfg{'ROOT_DIR'}/engine/messager/ispcp-db-keys.pl"); |
|---|
| r912 |
r1057 |
|
| 85 | 85 | push_el(\@main::el, 'vrl_traff_correction_engine()', 'Starting...'); |
|---|
| 86 | 86 | |
|---|
| 87 | | my $sql = "SELECT traff_time, IFNULL( sum( t2.dtraff_mail ) , 0 ) AS dom_mail_sum, IFNULL( sum( t2.dtraff_pop ) , 0 ) AS dom_pop_sum, IFNULL( sum( t2.dtraff_web ) , 0 ) AS dom_web_sum, ifnull( (t1.bytes_mail_in + t1.bytes_mail_out), 0 ) - IFNULL( sum( t2.dtraff_mail ) , 0 ) AS diff_mail, ifnull( (t1.bytes_pop_in + t1.bytes_pop_out), 0 ) - IFNULL( sum( t2.dtraff_pop ) , 0 ) AS diff_pop, ifnull( (t1.bytes_web_in + t1.bytes_web_out), 0 ) - IFNULL( sum( t2.dtraff_web ) , 0 ) AS diff_web FROM server_traffic AS t1 INNER JOIN domain_traffic AS t2 ON t2.dtraff_time = t1.traff_time WHERE t1.correction = 0 and t2.correction = 0 GROUP BY t2.dtraff_time;"; |
|---|
| | 87 | # Select traffic for only two hour. |
|---|
| | 88 | my $time = time() - (60 * 120); |
|---|
| | 89 | |
|---|
| | 90 | my $sql = "SELECT traff_time, IFNULL( sum( t2.dtraff_mail ) , 0 ) AS dom_mail_sum, IFNULL( sum( t2.dtraff_pop ) , 0 ) AS dom_pop_sum, IFNULL( sum( t2.dtraff_web ) , 0 ) AS dom_web_sum, ifnull( (t1.bytes_mail_in + t1.bytes_mail_out), 0 ) - IFNULL( sum( t2.dtraff_mail ) , 0 ) AS diff_mail, ifnull( (t1.bytes_pop_in + t1.bytes_pop_out), 0 ) - IFNULL( sum( t2.dtraff_pop ) , 0 ) AS diff_pop, ifnull( (t1.bytes_web_in + t1.bytes_web_out), 0 ) - IFNULL( sum( t2.dtraff_web ) , 0 ) AS diff_web FROM server_traffic AS t1 INNER JOIN domain_traffic AS t2 ON t2.dtraff_time = t1.traff_time WHERE t1.traff_time > $time and t2.dtraff_time > $time and t1.correction = 0 and t2.correction = 0 GROUP BY t2.dtraff_time;"; |
|---|
| 88 | 91 | |
|---|
| 89 | 92 | ($rs, $rdata1) = doSQL($sql); |
|---|
|