Posts by krok

i have maia mailguard with imscp and it work fine

Hi,

i have this error in /var/log/daemon.log :

Mar 4 05:30:01 vm1 mysqld: 120304 5:30:01 [Warning] Statement may not be safe to log in statement format. Statement: UPDATE
Mar 4 05:30:01 vm1 mysqld: #011#011#011#011#011#011`domain_traffic`
Mar 4 05:30:01 vm1 mysqld: #011#011#011#011#011SET
Mar 4 05:30:01 vm1 mysqld: #011#011#011#011#011#011`dtraff_web` = `dtraff_web` + '4914',
Mar 4 05:30:01 vm1 mysqld: #011#011#011#011#011#011`dtraff_ftp` = `dtraff_ftp` + '0',
Mar 4 05:30:01 vm1 mysqld: #011#011#011#011#011#011`dtraff_mail` = `dtraff_mail` + '22076',
Mar 4 05:30:01 vm1 mysqld: #011#011#011#011#011#011`dtraff_pop` = `dtraff_pop` + '0',
Mar 4 05:30:01 vm1 mysqld: #011#011#011#011#011#011`dtraff_time` = '1330835400'
Mar 4 05:30:01 vm1 mysqld: #011#011#011#011#011WHERE
Mar 4 05:30:01 vm1 mysqld: #011#011#011#011#011#011`domain_id` = '1'
Mar 4 05:30:01 vm1 mysqld: #011#011#011#011#011#011AND
Mar 4 05:30:01 vm1 mysqld: #011#011#011#011#011#011`dtraff_time` >= UNIX_TIMESTAMP(CURRENT_DATE())
Mar 4 05:30:01 vm1 mysqld: #011#011#011#011#011LIMIT 1
Mar 4 05:30:01 vm1 mysqld: 120304 5:30:01 [Warning] Statement may not be safe to log in statement format. Statement: UPDATE
Mar 4 05:30:01 vm1 mysqld: #011#011#011#011#011#011`domain_traffic`
Mar 4 05:30:01 vm1 mysqld: #011#011#011#011#011SET
Mar 4 05:30:01 vm1 mysqld: #011#011#011#011#011#011`dtraff_web` = `dtraff_web` + '16956',
Mar 4 05:30:01 vm1 mysqld: #011#011#011#011#011#011`dtraff_ftp` = `dtraff_ftp` + '0',
Mar 4 05:30:01 vm1 mysqld: #011#011#011#011#011#011`dtraff_mail` = `dtraff_mail` + '0',
Mar 4 05:30:01 vm1 mysqld: #011#011#011#011#011#011`dtraff_pop` = `dtraff_pop` + '0',
Mar 4 05:30:01 vm1 mysqld: #011#011#011#011#011#011`dtraff_time` = '1330835400'
Mar 4 05:30:01 vm1 mysqld: #011#011#011#011#011WHERE
Mar 4 05:30:01 vm1 mysqld: #011#011#011#011#011#011`domain_id` = '12'
Mar 4 05:30:01 vm1 mysqld: #011#011#011#011#011#011AND
Mar 4 05:30:01 vm1 mysqld: #011#011#011#011#011#011`dtraff_time` >= UNIX_TIMESTAMP(CURRENT_DATE())
Mar 4 05:30:01 vm1 mysqld: #011#011#011#011#011LIMIT 1

Normal ?

How many request / s your launch the script ?

i have test 15 req/s and the database grow up , 10 min ago the databasse size > 5 go and mysql use all memory cache.
at this time the server is high load IOPS : HDD drive is 100% load but not CPU.

and for the test
i test SIP call

for php script i use this

<META HTTP-EQUIV="Refresh" CONTENT="1"; URL=test.php">
<?php
function random_str(){

$result="";
for ($i = 1; $i <= 16; $i++) {

$base10Rand = mt_rand(0, 15);
$newRand = base_convert($base10Rand, 10, 36);
$result.=$newRand;
}
return $result;

}

mysql_connect ("127.0.0.1", "test", "password");
mysql_select_db ("test");

$query = "CREATE TABLE IF NOT EXISTS test (test1 int(100) NOT NULL, test2 int(100) NOT NULL, test3 int(100) NOT NULL, test4 int(100) NOT NULL) ENGINE=MyISAM DEFAULT CHARSET=latin1;";
mysql_query($query);
$aa=array();
for ($i=1; $i <= 1000; $i++) {
$a=random_str();
$aa[]=$a;
$b=random_str();
$c=random_str();
$d=random_str();
$query="INSERT INTO test SET test1='$a', test2='$b', test3='$c', test4='$d'";
mysql_query($query);
}

$query="SELECT * FROM test";
mysql_query($query);

foreach ($aa as $value) {
$query="DELETE FROM test WHERE test1='$value'";
mysql_query($query);
}

?>

6 request / s -> the server are 100 % IOPS use

you want stress test mysql or your web server (apache + mysql )

if you want stress your webserver : google chrome with hight refresh page p^^ + 100 pages open

make a test page with hight SQL request (read and write for large table) and PHP page with most FOR)

i test my server with that and it terrible p^^

hello,

I will advice to migrate to ISPCP 1.0.7 and migrate to 1.0.2.1 RC2

if migrate to ISPCP 1.0.7 fail -> correct different problem before migrate to I-MSCP

test into test server for migration ( will prevent correction on production server )

sorry but i don't know how to bring MD5 password in clear password.

what version of i-mscp do you have ?
is a fresh install ?
what system ?

Quote from Paderman

Hmm, the folder /var/mails has root:mail and the virtual and the files are set it to vmail:mail and I saw, that the permissions are 700, is that ok?

it's ok

so your first problem is solve ?

for second problem -> postfix/trivial-rewrite[3921]: warning: do not list domain MYDOMAIN.TLD in BOTH mydestination and virtual_mailbox_domains
or postfix don't read login to the bdd

hi,

i think your problem is euid in dovecot configuration (150 is unknow)

check dovecot config and check right in /var/mail/