Plesk 11.5: autoresponders created in previous Plesk version (9.x) do not work!

[Nikolay.]

Home>Subscriptions>mydomain.com>Mail>[email protected]
and select 'auto-reply' button

Then simply Click OK. The autoresponder starts to work again.

OK, so this helps, but mchk does not? Extremely weird.

Is it possible that you can make a dump of psa MySQL DB before and after such actions and then run diff on them to see what changed (might not be the greatest idea, but I don't have better ones now)? Enabling MySQL query logging will also help, but I suspect it will yield less information.

 

[halliday]

OK, so this helps, but mchk does not? Extremely weird.

Is it possible that you can make a dump of psa MySQL DB before and after such actions and then run diff on them to see what changed (might not be the greatest idea, but I don't have better ones now)? Enabling MySQL query logging will also help, but I suspect it will yield less information.

I will do that and report the finding(s).

This might take sometime, because I need to find out the right commands to do the above.
Many thanks.

 

[Nikolay.]

Basically something like this (writing from the top of my head):

# mysqldump -uadmin -p`cat /etc/psa/.psa.shadow` -D psa > before.sql

<do stuff that fixes other stuff>

# mysqldump -uadmin -p`cat /etc/psa/.psa.shadow` -D psa > after.sql

# diff -u before.sql after.sql

The latter may not produce very good results if all inserts for a table are on one line. In this case it would be easier to add some newlines between groups of values in the sql files where the issue is.

Be aware that mysqldump may generate increased load and produce large files.

 

[halliday]

Thank you ever so much.

diff -u before.sql after.sql produced a huge amount of data, and it kept on scrolling down.
It was difficult to read.

Using -q --brief Output only whether files differ
It confirmed they are different.

The sizes of the two files are actually different:
after.sql 16,634,644
before.sql 16,633,086

Have tried diff --help to look for a switch that can show the difference briefly but could not find one.

This is great help. At least one knows that simply clicking OK in the auto-reply screen did make a difference (in terms of database content) without changing anything.

I wonder if you know of a command that does something like this:-
UPDATE ALL auto-reply entries in the database.

Because there are about 4000 of them and it would be a big job to do each manually from PLESK.

Thank you once again

 

[Nikolay.]

I read man mysqldump a bit and think following should help actually detect the differences. Use following command for dumping DB both times:

# mysqldump --order-by-primary --opt --compact --skip-extended-insert -uadmin -p`cat /etc/psa/.psa.shadow ` psa

Then use the same # diff -u before.sql after.sql

It will contain a number of useless entries for exp_event, log_components, log_actions, and sessions tables, but the output would be much smaller. We are interested in the entries for all the other tables.

 

[halliday]

I read man mysqldump a bit and think following should help actually detect the differences. Use following command for dumping DB both times:

# mysqldump --order-by-primary --opt --compact --skip-extended-insert -uadmin -p`cat /etc/psa/.psa.shadow ` psa

Then use the same # diff -u before.sql after.sql

It will contain a number of useless entries for exp_event, log_components, log_actions, and sessions tables, but the output would be much smaller. We are interested in the entries for all the other tables.

Thanks. To cut a long story short: The command diff -u before.sql after.sql yielded a big result again. So I downloaded both sql files and used a windows program (WinMerge) to compare them.

There are few differences butdiscarding the exp_event, log_components, log_actions, and sessions tables, there are 2 differences only:-

BEFORE:
INSERT INTO `dom_param` VALUES (2,'lastVisitTime','2013-08-02T05:12:51+01:00');

AFTER
INSERT INTO `dom_param` VALUES (2,'lastVisitTime','2013-08-02T09:25:30+01:00');


And this one:-

BEFORE
INSERT INTO `mail_resp` VALUES (1333,1337,'default','','no','Re: <request_subject>','[email protected]','text/html','WINDOWS-1256','<BODY><FONT size=3 face=Tahoma>\n<DIV align=center>\n<CENTER>\n<TABLE border=9 cellSpacing=1 borderColor=#3586d7 cellPadding=15 width=520>\n<TBODY>\n<TR>\n<TD style=\"BORDER-BOTTOM: 1px ridge; BORDER-LEFT: 1px ridge; BORDER-TOP: 1px ridge; BORDER-RIGHT: 1px ridge\" width=439>\n<DIV align=justify>\n<DIV align=center>\n<CENTER><FONT size=3 face=Tahoma>\n<TABLE style=\"BORDER-COLLAPSE: collapse\" dir=rtl border=0 cellSpacing=0 borderColor=#4d94db cellPadding=3 width=490>\n<TBODY>\n<TR>\n<TD dir=rtl align=middle>\n<DIV align=justify><A href=\"http://www.mydomain.com\" target=_blank><IMG border=0 src=\"http://www.mydomain.com/media/mydomain.jpg\" width=204 height=85></A></DIV></TD>\n<TD width=1 align=middle><BR> </TD>\n<TD dir=rtl align=middle>\n<P dir=rtl align=center><BR><BR> </P></TD></TR>\n<TR>\n<TD colSpan=3 align=middle>\n<HR color=#d6d6d6 SIZE=4>\n</TD></TR>\n<TR>\n<TD style=\"PADDING-BOTTOM: 5px; PADDING-LEFT: 10px; PADDING-RIGHT: 10px; PADDING-TOP: 5px\" dir=rtl bgColor=#f8f8f8 colSpan=3>\n<P dir=rtl><FONT size=2 face=Tahoma>\n<P align=right><FONT size=2>
\n
*** TEXT HERE ***
</FONT><BR><BR></P>\n</FONT></TD></TR>\n<TR>\n<TD colSpan=3 align=middle>\n<HR color=#d6d6d6 SIZE=4>\n</TD></TR></TBODY></TABLE></FONT></FONT><FONT size=3 face=Tahoma></FONT></CENTER></DIV></DIV></TD></TR></TBODY></TABLE></CENTER></DIV></FONT></BODY>','true',10,1000,0);


AFTER:
INSERT INTO `mail_resp` VALUES (1333,1337,'default','','no','Re: <request_subject>','[email protected]','text/html','WINDOWS-1256','<BODY><FONT size=3 face=Tahoma>\r\n<DIV align=center>\r\n<CENTER>\r\n<TABLE border=9 cellSpacing=1 borderColor=#3586d7 cellPadding=15 width=520>\r\n<TBODY>\r\n<TR>\r\n<TD style=\"BORDER-BOTTOM: 1px ridge; BORDER-LEFT: 1px ridge; BORDER-TOP: 1px ridge; BORDER-RIGHT: 1px ridge\" width=439>\r\n<DIV align=justify>\r\n<DIV align=center>\r\n<CENTER><FONT size=3 face=Tahoma>\r\n<TABLE style=\"BORDER-COLLAPSE: collapse\" dir=rtl border=0 cellSpacing=0 borderColor=#4d94db cellPadding=3 width=490>\r\n<TBODY>\r\n<TR>\r\n<TD dir=rtl align=middle>\r\n<DIV align=justify><A href=\"http://www.mydomain.com\" target=_blank><IMG border=0 src=\"http://www.mydomain.com/media/mydomain.jpg\" width=204 height=85></A></DIV></TD>\r\n<TD width=1 align=middle><BR> </TD>\r\n<TD dir=rtl align=middle>\r\n<P dir=rtl align=center><BR><BR> </P></TD></TR>\r\n<TR>\r\n<TD colSpan=3 align=middle>\r\n<HR color=#d6d6d6 SIZE=4>\r\n</TD></TR>\r\n<TR>\r\n<TD style=\"PADDING-BOTTOM: 5px; PADDING-LEFT: 10px; PADDING-RIGHT: 10px; PADDING-TOP: 5px\" dir=rtl bgColor=#f8f8f8 colSpan=3>\r\n<P dir=rtl><FONT size=2 face=Tahoma>\r\n<P align=right><FONT size=2>
\r\n
*** TEXT HERE ***
</FONT><BR><BR></P>\r\n</FONT></TD></TR>\r\n<TR>\r\n<TD colSpan=3 align=middle>\r\n<HR color=#d6d6d6 SIZE=4>\r\n</TD></TR></TBODY></TABLE></FONT></FONT><FONT size=3 face=Tahoma></FONT></CENTER></DIV></DIV></TD></TR></TBODY></TABLE></CENTER></DIV></FONT></BODY>','true',10,1000,0);


The last one is intereting:-
Every NEW LINE (\n) in "before.sql" was replaced with
NEW LINE and Carriage Return (\r\n) in "after.jpg".

However, I accessed PSA db from Plesk and checked "mail_resp" table and checked the "text" fields.
In there they look identical WITHPOUT (\n) or (\r\n)

If this is likely to be the cause, then I wonder if one could either through Plesk or SSH update all text messages

Something like this:-
UPDATE mail_resp SET text ="bla bla" etc...

Thank you!

 

[halliday]

Plesk 11.5: autoresponders created in previous Plesk version do not work! [SOLVED]

Hello,

The SSH command:-
./autoresponder --update -mail [email protected] (just like that)

got the autoresonder to work again.

So I just created an array of the old emails accounts, applied the bove command to all, and they work okay now.

Thank you igor.A. + Nikolay. for your input. I have learnt a lot from you.