Critical bug inside /script/fix-mail-all

[Spacedust]

When rebuilding mail database it's not rebuilding all domains but just skipping a lot of domains. Why is this happenning ? Only about 30 domains were rebuild.

It's not getting bigger than this:

Code: [Select]

[root@nowosci kloxo]# ls -l | grep mmmail
-rw-rw---- 1 mysql mysql  14K lip  3 09:22 mmail.frm
-rw-rw---- 1 mysql mysql 9,0K lip  3 22:02 mmail.MYD
-rw-rw---- 1 mysql mysql  10K lip  3 22:02 mmail.MYI


Code: [Select]

- 'postmaster@interkursy.xxx.pl' ('bysior') at 'localhost'
- 'postmaster@plotki.xxx.pl' ('bysior') at 'localhost'
- 'postmaster@damianek.xxx.pl' ('damianek') at 'localhost'
- 'postmaster@domeny.damianek.xxx.pl' ('damianek') at 'localhost'
- 'postmaster@domeny.xxx.pl' ('damianek') at 'localhost'
- 'admin@domenyxxx.pl' ('damianek') at 'localhost'
--------------------------
Preparing Horde database
- Fix MySQL commands in import files of Horde
- Generating password
- Add password to configuration file
- Database installed
Initialize Horde files
- Initialize process
Preparing RoundCube database
- Fixing MySQL commands in import files
- Generating password
- Add Password to configuration file
- Database installed
Initialize Roundcube files
- Initialize process
Preparing T-Dah Database
- No need database
Initialize T-Dah files
- Initialize process
Preparing Afterlogic database
- Fixing MySQL commands in import files
- Generating password
- Add Password to configuration file
- Database installed
Initialize Afterlogic files
- Initialize process
Preparing Squirrelmail Database
- No need database
Initialize Squirrelmail files
- Initialize process
Telaen webmail no exists
Install Webmail chooser
- Install process


[Spacedust]

Tried again and now it failed with:

Code: [Select]

Notice : The resource you have requested doesn't exist. The server returned the error message: <br>  could_not_add_mail mailpserver  <br>


[Spacedust]

Another try and another bug:

Code: [Select]

- 'postmaster@finanse.xxx.pl' ('justyna') at 'localhost'
Notice : The resource you have requested doesn't exist. The server returned the error message: <br>  could_notadd_mail mailpserver NOTICE: Out of order entries found in /var/qmail/control/virtualdomains
   Sorting...

 <br>

[MRatWork]

Fix-mail-all not rebuild mailaccount data.

See inside code:

Code: [Select]

#!/bin/sh

ULLKFPATH="/usr/local/lxlabs/kloxo/file"
VQSPATH="/var/qmail/supervise"
ERIPATH="/etc/rc.d/init.d"
HVBPATH="/home/vpopmail/bin"
VQCPATH="/var/qmail/control"
ECPATH="/etc/courier"

echo ""
echo "Change qmail.init"
cp -rf $ULLKFPATH/qmail.init $ERIPATH/qmail
chmod -f 0755 $ERIPATH/qmail

echo "--------------------------"

echo "Set '$HVBPATH/vchkpw' for root:root ownership"
chown -f root:root $HVBPATH/vchkpw

echo "Set '$HVBPATH/vchkpw' for 4751 permissions"
chmod -f 4755 $HVBPATH/vchkpw

echo "--------------------------"
echo "Set '$VQCPATH/locals' with 'localhost' only"
echo 'localhost' > $VQCPATH/locals

echo "--------------------------"

sh /script/fixvpop

echo "--------------------------"

sh /script/fix-qmail-assign

echo "--------------------------"

sh /script/fixmail

echo "--------------------------"

sh /script/fixwebmail

echo ""Where:
1. fix-vpop - fix vpopmail database password and need mysql root password to process (also panel not accessed)
2. fix-qmail-assign - fix mail domain path in /var/qmail/users/assign (and then create cdb) based on info from vpopmail database
3. fixmail - fix directory of mail account based on mailaccount table on kloxo database.

We have a trouble if:
1. Not able to access to vpopmail and it's make not able to add/delete mailaccount and login process
2. domain not the same between vpopmail table in vpopmail database and mailaccount table in kloxo database

So, it's not Kloxo-MR bug but something wrong before.

Remember, Kloxo Official not have fixmail-all and fix-qmail-assign and an effect if qmail-assign not exists is to say goodbye for mailaccount!.

[Spacedust]

Removed old entries from mmail table, but still does not help :/

[Spacedust]

This mmail bug inside Kloxo-MR that happened somewhere before or after the final version. I've sen't you all details about this issue via PM.

[MRatWork]

Nothing wrong I tried add 10 domain under admin and then deleted them. No error when running 'sh /script/fixmail-all' after that, also when 'sh /script/restart-all'.

Beside 'mmail' table, you must see 'mailaccount' table on kloxo database.

[Spacedust]

Nothing wrong I tried add 10 domain under admin and then deleted them. No error when running 'sh /script/fixmail-all' after that, also when 'sh /script/restart-all'.

Beside 'mmail' table, you must see 'mailaccount' table on kloxo database.

There are no errors, but removing each domain takes 30 seconds, while normally it's just 4-6 seconds.

[MRatWork]

Because your domains more then 1500, with assumption without data error/missing.

[Spacedust]

Because your domains more then 1500, with assumption without data error/missing.

It was working much faster in the past with more than 2000. I need to check old versions of Kloxo-MR.

CPU is bombared with some horrible JavaScript which never happened before.

[Spacedust]

Wow just restored my old image of Kloxo 6.1.12 and:

Adding domain - 4 seconds
Removing domain - 2 seconds

1741 domains inside Kloxo !!!

[MRatWork]

How about if you have inconsistance data?.

Let try below code:

1. Create /etc/clients file with content:

Code: [Select]

#!/bin/sh

. /script/directory
lxphp.exe ../bin/fix/clients.php $*
and /usr/local/lxlabs/kloxo/bin/fix/clients.php with content:

Code: [Select]

<?php 

include_once "htmllib/lib/include.php";
initProgram('admin');

$login->loadAllObjects('client');
$list = $login->getList('client');

$results = print_r($list, true);

file_put_contents('/tmp/clients.txt', $results);
2. And then run 'sh /script/clients'
3. Inform here how big the /tmp/clients.txt file?.

[Spacedust]

How about if you have inconsistance data?.

Let try below code:

1. Create /etc/clients file with content:

Code: [Select]

#!/bin/sh

. /script/directory
lxphp.exe ../bin/fix/clients.php $*
and /usr/local/lxlabs/kloxo/bin/fix/clients.php with content:

Code: [Select]

<?php 

include_once "htmllib/lib/include.php";
initProgram('admin');

$login->loadAllObjects('client');
$list = $login->getList('client');

$results = print_r($list, true);

file_put_contents('/tmp/clients.txt', $results);
2. And then run 'sh /script/clients'
3. Inform here how big the /tmp/clients.txt file?.

Here you are:

[root@nowosci tmp]# ls -l clients.txt
-rw-r--r-- 1 root root 299M lip  5 00:54 clients.txt

[MRatWork]

User for hosting this forum have 10 domains and testing give /etc/clients.txt as 0.7MB. If hosting 2000 domains will be have (0.7 x 2000 /10) = 140MB. Only half of 299M.

[Spacedust]

User for hosting this forum have 10 domains and testing give /etc/clients.txt as 0.7MB. If hosting 2000 domains will be have (0.7 x 2000 /10) = 140MB. Only half of 299M.

Most of my users have about 10 domains. But there are some who has 100.