Error 3868

Use this forum if you have installed hMailServer and want to ask a question related to a production release of hMailServer. Before posting, please read the troubleshooting guide. A large part of all reported issues are already described in detail here.
Post Reply
User avatar
bagu
Normal user
Normal user
Posts: 211
Joined: 2005-06-17 03:08
Location: France
Contact:

Error 3868

Post by bagu » 2012-12-07 14:25

Hello,

I receive many error 3868 on my server (hmailserver 5.4-1944 - mysql 5.5.28)

Code: Select all

"ERROR"	3868	"2012-12-06 14:49:03.854"	"Severity: 2 (High), Code: HM5033, Source: DALRecordset::Open, Description: MySQL: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''3026715869272151449' > whiteloweripaddress1 && whiteloweripaddress2 is not null' at line 1 (Additional info: SELECT COUNT(*) as c FROM hm_whitelist WHERE ('3026715869272151449' = whiteloweripaddress1 && '3026715869272151449' >= whiteloweripaddress2 '3026715869272151449' > whiteloweripaddress1 && whiteloweripaddress2 is not null) AND ('16'} = whiteupperipaddress1 && '16' <= whiteupperipaddress2 '16' < whiteupperipaddress1 && whiteupperipaddress2 is not null) AND (whiteemailaddress = '' OR 'telephonie.freebox@freetelecom.fr' LIKE whiteemailaddress ESCAPE '/'))"
"ERROR"	3868	"2012-12-06 15:05:03.758"	"Severity: 2 (High), Code: HM5033, Source: DALRecordset::Open, Description: MySQL: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''3026715869272151449' > whiteloweripaddress1 && whiteloweripaddress2 is not null' at line 1 (Additional info: SELECT COUNT(*) as c FROM hm_whitelist WHERE ('3026715869272151449' = whiteloweripaddress1 && '3026715869272151449' >= whiteloweripaddress2 '3026715869272151449' > whiteloweripaddress1 && whiteloweripaddress2 is not null) AND ('21'} = whiteupperipaddress1 && '21' <= whiteupperipaddress2 '21' < whiteupperipaddress1 && whiteupperipaddress2 is not null) AND (whiteemailaddress = '' OR 'telephonie.freebox@freetelecom.fr' LIKE whiteemailaddress ESCAPE '/'))"
I have a rule wich match to this error, but this rule work fine.
Rule is :
Name : Répondeur
Active : Checked
Criteria : use OR
Field : From
Comparison : Contains
Value : telephonie.freebox@freetelecom.fr
Value 2 (same rule, but only value change) : telephonie.freebox@freetelecom.com

Action : Move to IMAP folder (witch exist - and - the rule work)

Thanks for your help.
hMailServer 5.6.8 With SpamAssassin 3.4.2

Bill48105
Developer
Developer
Posts: 6192
Joined: 2010-04-24 23:16
Location: Michigan, USA

Re: Error 3868

Post by Bill48105 » 2012-12-07 17:58

Hi. I wonder if it doesn't like Name : Répondeur vs Name : Repondeur.. Perhaps the special character with accent is causing charset issue. Just in case did you do a database test & repair? Did you try deleting the rule & adding it back again?
Bill
hMailServer build LIVE on my servers: 5.4-B2014050402
#hmailserver on FreeNode IRC https://webchat.freenode.net/?channels=#hmailserver
*** ABSENT FROM hMail! Those in IRC know how to find me if urgent. ***

User avatar
bagu
Normal user
Normal user
Posts: 211
Joined: 2005-06-17 03:08
Location: France
Contact:

Re: Error 3868

Post by bagu » 2012-12-08 00:58

Bill48105 wrote:Hi. I wonder if it doesn't like Name : Répondeur vs Name : Repondeur.. Perhaps the special character with accent is causing charset issue. Just in case did you do a database test & repair? Did you try deleting the rule & adding it back again?
Bill
Already try Repondeur instead Répondeur
Database test & repair done : no error
I will try deleting the rule and adding it again to see if there is a change.
hMailServer 5.6.8 With SpamAssassin 3.4.2

User avatar
bagu
Normal user
Normal user
Posts: 211
Joined: 2005-06-17 03:08
Location: France
Contact:

Re: Error 3868

Post by bagu » 2012-12-08 14:35

Test done. The error still occured
hMailServer 5.6.8 With SpamAssassin 3.4.2

Bill48105
Developer
Developer
Posts: 6192
Joined: 2010-04-24 23:16
Location: Michigan, USA

Re: Error 3868

Post by Bill48105 » 2012-12-08 19:28

Hard to believe it's tied to that rule because the error says whitelist. Did you check your hmail whitelist?
hMailServer build LIVE on my servers: 5.4-B2014050402
#hmailserver on FreeNode IRC https://webchat.freenode.net/?channels=#hmailserver
*** ABSENT FROM hMail! Those in IRC know how to find me if urgent. ***

User avatar
bagu
Normal user
Normal user
Posts: 211
Joined: 2005-06-17 03:08
Location: France
Contact:

Re: Error 3868

Post by bagu » 2012-12-08 22:21

I have empty the whitelist at the begining of my tests.

I really don't understand.
hMailServer 5.6.8 With SpamAssassin 3.4.2

Bill48105
Developer
Developer
Posts: 6192
Joined: 2010-04-24 23:16
Location: Michigan, USA

Re: Error 3868

Post by Bill48105 » 2012-12-09 09:00

Under Settings->Anti-Spam->White listing do you have anything?
http://www.hmailserver.com/documentatio ... itelisting
I ask because i don't recall any whitelist for rules.
Bill
hMailServer build LIVE on my servers: 5.4-B2014050402
#hmailserver on FreeNode IRC https://webchat.freenode.net/?channels=#hmailserver
*** ABSENT FROM hMail! Those in IRC know how to find me if urgent. ***

User avatar
bagu
Normal user
Normal user
Posts: 211
Joined: 2005-06-17 03:08
Location: France
Contact:

Re: Error 3868

Post by bagu » 2012-12-09 12:25

As i say, this list is empty ;)

...but, i just remove cache...maybe it keep old wrong whitelist ?
hMailServer 5.6.8 With SpamAssassin 3.4.2

Bill48105
Developer
Developer
Posts: 6192
Joined: 2010-04-24 23:16
Location: Michigan, USA

Re: Error 3868

Post by Bill48105 » 2012-12-09 17:16

bagu wrote:As i say, this list is empty ;)

...but, i just remove cache...maybe it keep old wrong whitelist ?
hard to tell what you're saying really when there is a language barrier, is why I'm confirming. ;)

As I said it looks like it's a whitelist problem not a rules problem based on your logs. You might add a test whitelist & check logs for error. Or you might need to check your whitelist table to make sure it is correct.

What is your hmail install history? Did you start on 1944 or have upgrades to it?
hMailServer build LIVE on my servers: 5.4-B2014050402
#hmailserver on FreeNode IRC https://webchat.freenode.net/?channels=#hmailserver
*** ABSENT FROM hMail! Those in IRC know how to find me if urgent. ***

User avatar
bagu
Normal user
Normal user
Posts: 211
Joined: 2005-06-17 03:08
Location: France
Contact:

Re: Error 3868

Post by bagu » 2012-12-09 17:36

I've made many upgrade from V4 to v5.4-1944

The problem appear since i upgrade to v5.4-1944 from v5.4-1931

Here are some screenshots to make it more clear :

http://www.casimages.com/img.php?i=1212 ... 563991.jpg

http://www.casimages.com/img.php?i=1212 ... 579345.jpg

http://www.casimages.com/img.php?i=1212 ... 674683.jpg

http://www.casimages.com/img.php?i=1212 ... 173475.jpg
hMailServer 5.6.8 With SpamAssassin 3.4.2

Bill48105
Developer
Developer
Posts: 6192
Joined: 2010-04-24 23:16
Location: Michigan, USA

Re: Error 3868

Post by Bill48105 » 2012-12-10 03:26

I am not aware of whitelist changes in 1944 but if you are familiar with mysql you could make a backup then drop the hm_whitelist table & create it again using the SQL template from the SQl folder in hmail. Obviously be sure you know what you are doing. ;)
hMailServer build LIVE on my servers: 5.4-B2014050402
#hmailserver on FreeNode IRC https://webchat.freenode.net/?channels=#hmailserver
*** ABSENT FROM hMail! Those in IRC know how to find me if urgent. ***

User avatar
bagu
Normal user
Normal user
Posts: 211
Joined: 2005-06-17 03:08
Location: France
Contact:

Re: Error 3868

Post by bagu » 2012-12-10 12:40

Done, nothing has change.
I have done a complete uninstall/reinstall + backup restore, the problem still appear.

I have done many tests. And there is an error in the mysql query.
The actual query is :

Code: Select all

SELECT COUNT(*) as c FROM hm_whitelist
WHERE 
('3026715869272151449' = whiteloweripaddress1 && '3026715869272151449' >= whiteloweripaddress2 '3026715869272151449' > whiteloweripaddress1 && whiteloweripaddress2 is not null)
AND
('20'} = whiteupperipaddress1 && '20' <= whiteupperipaddress2 '20' < whiteupperipaddress1 && whiteupperipaddress2 is not null) AND (whiteemailaddress = '' OR 'telephonie.freebox@freetelecom.fr' LIKE whiteemailaddress ESCAPE '/'))
But the only query wich work is this :

Code: Select all

SELECT COUNT(*) as c FROM hm_whitelist
WHERE
('3026715869272151449' = whiteloweripaddress1 && '3026715869272151449' >= whiteloweripaddress2 && '3026715869272151449' > whiteloweripaddress1 && whiteloweripaddress2 is not null)
AND
('20' = whiteupperipaddress1 && '20' <= whiteupperipaddress2 && '20' < whiteupperipaddress1 && whiteupperipaddress2 is not null) AND (whiteemailaddress = '' OR 'telephonie.freebox@freetelecom.fr' LIKE whiteemailaddress ESCAPE '/')
So, i don't know from where this query come from, but there are many errors in.
hMailServer 5.6.8 With SpamAssassin 3.4.2

User avatar
bagu
Normal user
Normal user
Posts: 211
Joined: 2005-06-17 03:08
Location: France
Contact:

Re: Error 3868

Post by bagu » 2012-12-12 20:46

I have made an test install of an other b1944 version with a test domain.
The problem still happen when i set my forward rules.

So i try to launch a domain test on my poduction server, and everything seem normal :

Code: Select all

Test: Collect server details
hMailServer version: hMailServer 5.4-B1944
Database type: MySQL

Test: Test IPv6
IPv6 support is available in operating system.

Test: Test outbound port
SMTP relayer not in use. Attempting mail.hmailserver.com:25...
Trying to connect to host mail.hmailserver.com...
Trying to connect to TCP/IP address 46.163.110.124 on port 25.
Received: 220 mail.hmailserver.com ESMTP.
Connected successfully.

Test: Test backup directory
Backup directory F:\Sauvegardes\ServeurMail is writable.

Test: Test MX records
Trying to resolve MX records for bagu.biz...
Host name found: mail.bagu.biz

Test: Test local connect
Connecting to TCP/IP address in MX records for local domain domain bagu.biz...
Trying to connect to host mail.bagu.biz...
Trying to connect to TCP/IP address 88.184.248.105 on port 25.
Received: 220 mail.bagu.biz.
Connected successfully.

Test: Test message file locations
Relative message paths are stored in the database for all messages.

Test: Test IP range configuration
No problems were found in the IP range configuration.

hMailServer 5.6.8 With SpamAssassin 3.4.2

Bill48105
Developer
Developer
Posts: 6192
Joined: 2010-04-24 23:16
Location: Michigan, USA

Re: Error 3868

Post by Bill48105 » 2012-12-13 04:08

Wow those queries aren't really even close. I can't imagine the way the query is being built has been changed though so no idea how it could be formed incorrectly really. And not sure why whitelist would be checked for a rule.. Seriously something doesn't add up.
Bill
hMailServer build LIVE on my servers: 5.4-B2014050402
#hmailserver on FreeNode IRC https://webchat.freenode.net/?channels=#hmailserver
*** ABSENT FROM hMail! Those in IRC know how to find me if urgent. ***

User avatar
bagu
Normal user
Normal user
Posts: 211
Joined: 2005-06-17 03:08
Location: France
Contact:

Re: Error 3868

Post by bagu » 2013-01-09 01:04

The error was gone with hmailserver 5.4-1945

Thanks
hMailServer 5.6.8 With SpamAssassin 3.4.2

User avatar
bagu
Normal user
Normal user
Posts: 211
Joined: 2005-06-17 03:08
Location: France
Contact:

Re: Error 3868

Post by bagu » 2013-01-13 03:12

Shii...... The problem happen again without any action except a server reboot.
hMailServer 5.6.8 With SpamAssassin 3.4.2

Post Reply