Fetchmail Error in the postfixadmin Webinterface

[Oliver Busch]

Hi,

I have a problem with postfixadmin and fetch mail. When i click on fetch mail on the webinterface i have this error:

DEBUG INFORMATION:
Invalid query: FUNCTION postfix.FROM_BASE64 does not exist

Check your error_log for the failed query.

Please check the documentation and website for more information.

Postfix Admin
Forums

But I can create a new task in the webinterface but nothing happens.

Any idea how i can fix this issue with fetchmail on postfixadmin?

I use version 2.93, is there any patch for this problem?

Error on this link:

postfixadmin/list.php?table=fetchmail

Best regards and thanks for help,

Olli

[Christian Boltz]

Which database do you use? MySQL or MariaDB or PostgreSQL? Which version?

Please also paste the failed query - you'll find it in your apache error_log.

[Oliver Busch]

Thank you for the fast reply!

I use MySQL with Debian 8 Server. MySQL 5.5. And I use a nginx Webserver there is nothing in the logfile. I think it is a problem with fetchmail or so. I download and test version 2.3.8 Postfixadmin. In this version i can use the fetch email tab. but in the 2.93 version i can not use the fetchmail tab in postfixadmin. any idea what i can do?

Is this a bug in 2.93 postfixadmin?

[Christian Boltz]

http://dev.mysql.com/doc/refman/5.6/en/string-functions.html#function_from-base64 says:

[FROM_BASE64] function was added in MySQL 5.6.1

therefore it's not surprising that this fails with MySQL 5.5 ;-)

Workaround: Edit model/PFAHandler.php
search for (around line 572)
$base64_decode = "FROM_BASE64(###KEY###)";
and replace it with
$base64_decode = "###KEY###";

This means the password will not be decoded - but that doesn't hurt because it isn't displayed anyway (base64 is only used for fetchmail right now). Unfortunately it also means that this workaround doesn't qualify as "official" solution, so I won't implement it in the official code.

fetchmail.pl uses decode_base64 from MIME:Base64 and is therefore not affected by this problem.

[Jan Schrutka]

Hello,
where do i find the PFAHandler.php?