Ticket #403 (assigned defect)

Opened 1 year ago

Last modified 5 months ago

Use of uninitialized value Hashing.pm errors

Reported by: Russ Assigned to: decoder (accepted)
Priority: minor Milestone:
Component: Configuration Version: SVN
Keywords: Use of uninitialized value Hashing.pm Cc:

Description

Hi There

Fuzzyocr seems to be running correctly on my setup, I'm getting spam hits and word tags out of spamassassin, however I seem to be getting the following error in my mail logs:

Jun 25 17:25:56 mta1 spamd[629]: Use of uninitialized value in string eq at /etc/mail/spamassassin/FuzzyOcr/Hashing.pm line 245. Jun 25 17:25:56 mta1 spamd[629]: Use of uninitialized value in string eq at /etc/mail/spamassassin/FuzzyOcr/Hashing.pm line 248. Jun 25 17:25:56 mta1 spamd[629]: Use of uninitialized value in string eq at /etc/mail/spamassassin/FuzzyOcr/Hashing.pm line 251. Jun 25 17:25:56 mta1 spamd[629]: Use of uninitialized value in numeric eq (==) at /etc/mail/spamassassin/FuzzyOcr/Hashing.pm line 254. Jun 25 17:25:56 mta1 spamd[629]: Use of uninitialized value in numeric eq (==) at /etc/mail/spamassassin/FuzzyOcr/Hashing.pm line 257. Jun 25 17:25:56 mta1 spamd[629]: Argument "" isn't numeric in numeric eq (==) at /etc/mail/spamassassin/FuzzyOcr/Hashing.pm line 260. Jun 25 17:25:56 mta1 spamd[629]: Use of uninitialized value in numeric eq (==) at /etc/mail/spamassassin/FuzzyOcr/Hashing.pm line 260. Jun 25 17:25:56 mta1 spamd[629]: Use of uninitialized value in string eq at /etc/mail/spamassassin/FuzzyOcr/Hashing.pm line 245. Jun 25 17:25:56 mta1 spamd[629]: Use of uninitialized value in string eq at /etc/mail/spamassassin/FuzzyOcr/Hashing.pm line 248. Jun 25 17:25:56 mta1 spamd[629]: Use of uninitialized value in string eq at /etc/mail/spamassassin/FuzzyOcr/Hashing.pm line 251. Jun 25 17:25:56 mta1 spamd[629]: Use of uninitialized value in numeric eq (==) at /etc/mail/spamassassin/FuzzyOcr/Hashing.pm line 254. Jun 25 17:25:56 mta1 spamd[629]: Use of uninitialized value in numeric eq (==) at /etc/mail/spamassassin/FuzzyOcr/Hashing.pm line 257. Jun 25 17:25:56 mta1 spamd[629]: Argument "" isn't numeric in numeric eq (==) at /etc/mail/spamassassin/FuzzyOcr/Hashing.pm line 260. Jun 25 17:25:56 mta1 spamd[629]: Use of uninitialized value in numeric eq (==) at /etc/mail/spamassassin/FuzzyOcr/Hashing.pm line 260.

I'm using SA 3.2.1 and the latest version of fuzzyocr from SVN. My fuzzyocr config is pretty much stock. I've tried running one of the messages that cause this error through spamassassin -D fuzzyocr and I do not get the error outputted there.I don't think the error is flagging up on every message with an image that fuzzyocr scans, just some.

I'm piping the messages to spamd from spamc and a custom script being called from postfix MTA.

Do do you have any idea where I can look to track down this error? Let me know if you need anymore info.

Thanks

Russ

Attachments

Change History

26.06.2007 12:12:13 changed by decoder

  • status changed from new to assigned.

This seems to be a problem with your mysql database, the plugin is trying to use mysql but some error must be occuring that is not catched properly.

Try inserting the following statements for further investigation:

After line 242:

my $rowlen = scalar(@data); infolog("Row length is $rowlen"); infolog("RaiseError? is $ddb->{RaiseError?}");

and then run the plugin with the correct verbose logging level in config so you see all the infolog messages. Once you reproduced the problem, check what these infologs output, my theory is that @data remains undefined because an SQL error occurs that is not catched properly at this point.

Best regards,

Chris

26.06.2007 12:14:18 changed by decoder

btw, thats RaiseError and not RaiseError?, damn wiki formatting. So thats 

my $rowlen = scalar(@data);
infolog("Row length is $rowlen");
infolog("RaiseError is $ddb->{RaiseError}");

26.06.2007 15:45:32 changed by anonymous

I've tried to add an attachment to the bug report, but I'm getting an Internal Server Error.

Here are the bits that the code you've gave me outputted (I also added a bit record the SQL query used) 

2007-06-26 13:51:38 [887] Hash already in mail.fuzzyocr_safe updating...
2007-06-26 13:51:38 [887] Row length is 1
2007-06-26 13:51:38 [887] RaiseError is  
2007-06-26 13:51:38 [887] SQL is select basic from mail.fuzzyocr_safe where fuzzyocr_safe.key='23:26:15:24:511::22:25:14:23:420::21:24:13:22:289::25:28:17:26:250::24:27:16:25:242::27:30:21:28:240'
2007-06-26 13:51:38 [887] update mail.fuzzyocr_safe set basic=127023:168:252:24329,fname=image009.jpg,ctype=image/jpeg,ftype=2 where fuzzyocr_safe.key='23:26:15:24:511::22:25:14:23:420::21:24:13:22:289::25:28:17:26
2007-06-26 13:51:38 [887] Digest: 127023:168:252:24329::23:26:15:24:511::22:25:14:23:420::21:24:13:22:289::25:28:17:26:250::24:27:16:25:242::27:30:21:28:240
2007-06-26 13:51:38 [887] Adding Hash to table: "mail.fuzzyocr_safe" with score "0"
2007-06-26 13:51:38 [887] insert into mail.fuzzyocr_safe values (241:222:58:209:6674::2:2:4:2:6294::243:221:58:209:676::241:222:57:209:400::241:221:60:209:344::243:221:57:209:340,105855:144:245:24329,image002.jpg,i
2007-06-26 13:51:38 [887] Digest: 105855:144:245:24329::241:222:58:209:6674::2:2:4:2:6294::243:221:58:209:676::241:222:57:209:400::241:221:60:209:344::243:221:57:209:340
2007-06-26 13:51:38 [887] Adding Hash to table: "mail.fuzzyocr_safe" with score "0"
2007-06-26 13:51:38 [887] insert into mail.fuzzyocr_safe values (49:82:133:78:19::51:83:134:79:14::50:87:139:82:12::38:137:202:115:12::51:84:135:80:11::106:155:195:145:11,111318:149:249:30268,image005.jpg,image/jpe
2007-06-26 13:51:38 [887] Digest: 111318:149:249:30268::49:82:133:78:19::51:83:134:79:14::50:87:139:82:12::38:137:202:115:12::51:84:135:80:11::106:155:195:145:11
2007-06-26 13:51:38 [887] Adding Hash to table: "mail.fuzzyocr_safe" with score "0"
2007-06-26 13:51:38 [887] insert into mail.fuzzyocr_safe values (254:254:254:254:3258::255:253:254:254:197::253:253:253:253:125::254:254:252:254:100::253:254:255:254:100::255:254:255:254:89,118788:159:249:30268,ima
2007-06-26 13:51:38 [887] Digest: 118788:159:249:30268::254:254:254:254:3258::255:253:254:254:197::253:253:253:253:125::254:254:252:254:100::253:254:255:254:100::255:254:255:254:89
2007-06-26 13:51:38 [887] Adding Hash to table: "mail.fuzzyocr_safe" with score "0"
2007-06-26 13:51:38 [887] Hash already in mail.fuzzyocr_safe updating...
2007-06-26 13:51:38 [887] Row length is 1
2007-06-26 13:51:38 [887] RaiseError is 
2007-06-26 13:51:38 [887] SQL is select basic from mail.fuzzyocr_safe where fuzzyocr_safe.key='255:255:255:255:20619::254:254:254:254:603::255:254:255:254:586::254:255:255:255:365::255:255:253:255:288::255:253:255:
2007-06-26 13:51:38 [887] update mail.fuzzyocr_safe set basic=112587:118:318:30268,fname=image001.jpg,ctype=image/jpeg,ftype=2 where fuzzyocr_safe.key='255:255:255:255:20619::254:254:254:254:603::255:254:255:254:58
2007-06-26 13:51:38 [887] Digest: 112587:118:318:30268::255:255:255:255:20619::254:254:254:254:603::255:254:255:254:586::254:255:255:255:365::255:255:253:255:288::255:253:255:254:254
2007-06-26 13:51:38 [887] Remove DIR: /tmp/.spamassassin887hUcgoCtmp
2007-06-26 13:51:38 [887] Remove DIR: /tmp/.spamassassin88799oIBqtmp
2007-06-26 13:51:38 [887] Remove DIR: /tmp/.spamassassin887JbeREHtmp
2007-06-26 13:51:38 [887] Remove DIR: /tmp/.spamassassin887PAzpk5tmp
2007-06-26 13:51:38 [887] Remove DIR: /tmp/.spamassassin887YiMFWitmp
2007-06-26 13:51:38 [887] Remove DIR: /tmp/.spamassassin887Ue3g6Vtmp
2007-06-26 13:51:38 [887] FuzzyOcr ending successfully...

If you want me to email you the whole log let me know. Can't really see from that where the error is happening.

26.06.2007 15:47:14 changed by anonymous

Opps, forgot :set wrap in vim, here we go: 

2007-06-26 13:51:38 [887] Not enough OCR Hits without space stripping, doing second matching pass...
2007-06-26 13:51:38 [887] Message is ham, saving...
2007-06-26 13:51:38 [887] Adding Hash to table: "mail.fuzzyocr_safe" with score "0"
2007-06-26 13:51:38 [887] Hash already in mail.fuzzyocr_safe updating...
2007-06-26 13:51:38 [887] Row length is 1
2007-06-26 13:51:38 [887] RaiseError is  
2007-06-26 13:51:38 [887] SQL is select basic from mail.fuzzyocr_safe where fuzzyocr_safe.key='23:26:15:24:511::22:25:14:23:420::21:24:13:22:289::25:28:17:26:250::24:27:16:25:242::27:30:21:28:240'
2007-06-26 13:51:38 [887] update mail.fuzzyocr_safe set basic=127023:168:252:24329,fname=image009.jpg,ctype=image/jpeg,ftype=2 where fuzzyocr_safe.key='23:26:15:24:511::22:25:14:23:420::21:24:13:22:289::25:28:17:26
:250::24:27:16:25:242::27:30:21:28:240'
2007-06-26 13:51:38 [887] Digest: 127023:168:252:24329::23:26:15:24:511::22:25:14:23:420::21:24:13:22:289::25:28:17:26:250::24:27:16:25:242::27:30:21:28:240
2007-06-26 13:51:38 [887] Adding Hash to table: "mail.fuzzyocr_safe" with score "0"
2007-06-26 13:51:38 [887] insert into mail.fuzzyocr_safe values (241:222:58:209:6674::2:2:4:2:6294::243:221:58:209:676::241:222:57:209:400::241:221:60:209:344::243:221:57:209:340,105855:144:245:24329,image002.jpg,image/jpeg,2,1,1182862298,1182862298,0,)
2007-06-26 13:51:38 [887] Digest: 105855:144:245:24329::241:222:58:209:6674::2:2:4:2:6294::243:221:58:209:676::241:222:57:209:400::241:221:60:209:344::243:221:57:209:340
2007-06-26 13:51:38 [887] Adding Hash to table: "mail.fuzzyocr_safe" with score "0"
2007-06-26 13:51:38 [887] insert into mail.fuzzyocr_safe values (49:82:133:78:19::51:83:134:79:14::50:87:139:82:12::38:137:202:115:12::51:84:135:80:11::106:155:195:145:11,111318:149:249:30268,image005.jpg,image/jpeg,2,1,1182862298,1182862298,0,)
2007-06-26 13:51:38 [887] Digest: 111318:149:249:30268::49:82:133:78:19::51:83:134:79:14::50:87:139:82:12::38:137:202:115:12::51:84:135:80:11::106:155:195:145:11
2007-06-26 13:51:38 [887] Adding Hash to table: "mail.fuzzyocr_safe" with score "0"
2007-06-26 13:51:38 [887] insert into mail.fuzzyocr_safe values (254:254:254:254:3258::255:253:254:254:197::253:253:253:253:125::254:254:252:254:100::253:254:255:254:100::255:254:255:254:89,118788:159:249:30268,image006.jpg,image/jpeg,2,1,1182862298,1182862298,0,)
2007-06-26 13:51:38 [887] Digest: 118788:159:249:30268::254:254:254:254:3258::255:253:254:254:197::253:253:253:253:125::254:254:252:254:100::253:254:255:254:100::255:254:255:254:89
2007-06-26 13:51:38 [887] Adding Hash to table: "mail.fuzzyocr_safe" with score "0"
2007-06-26 13:51:38 [887] Hash already in mail.fuzzyocr_safe updating...
2007-06-26 13:51:38 [887] Row length is 1
2007-06-26 13:51:38 [887] RaiseError is 
2007-06-26 13:51:38 [887] SQL is select basic from mail.fuzzyocr_safe where fuzzyocr_safe.key='255:255:255:255:20619::254:254:254:254:603::255:254:255:254:586::254:255:255:255:365::255:255:253:255:288::255:253:255:254:254'
2007-06-26 13:51:38 [887] update mail.fuzzyocr_safe set basic=112587:118:318:30268,fname=image001.jpg,ctype=image/jpeg,ftype=2 where fuzzyocr_safe.key='255:255:255:255:20619::254:254:254:254:603::255:254:255:254:586::254:255:255:255:365::255:255:253:255:288::255:253:255:254:254'
2007-06-26 13:51:38 [887] Digest: 112587:118:318:30268::255:255:255:255:20619::254:254:254:254:603::255:254:255:254:586::254:255:255:255:365::255:255:253:255:288::255:253:255:254:254
2007-06-26 13:51:38 [887] Remove DIR: /tmp/.spamassassin887hUcgoCtmp
2007-06-26 13:51:38 [887] Remove DIR: /tmp/.spamassassin88799oIBqtmp
2007-06-26 13:51:38 [887] Remove DIR: /tmp/.spamassassin887JbeREHtmp
2007-06-26 13:51:38 [887] Remove DIR: /tmp/.spamassassin887PAzpk5tmp
2007-06-26 13:51:38 [887] Remove DIR: /tmp/.spamassassin887YiMFWitmp
2007-06-26 13:51:38 [887] Remove DIR: /tmp/.spamassassin887Ue3g6Vtmp
2007-06-26 13:51:38 [887] FuzzyOcr ending successfully...

15.08.2007 02:26:49 changed by anonymous

Furniture Ashley Furniture Store

01.04.2008 06:33:35 changed by anonymous

徐州辉煌钢结构工程有限公司是一家集网架钢结构设计、制作、安装及技术服务为一体的大型专业化企业。公司坐落于有网架之乡美誉的江苏省徐州市，这里是全国优质网架原材料供应基地，也是全国网架技术熟练工人培训基地，有着人才，技术和原材料的地域优势。企业创办多年来，本着"求实创新、开拓进取"的精神，不断引进吸收国内外先进技术经验，汇集来自全国各地从事专业管理，专业设计、制造、检测试验等高级优秀人才，配置了各种先进的成套生产和检测设备，能满足制造生产能力要求的流水生产线。公司始终本着“诚信为本、信守合同、用户至上”的理念，坚持贯彻实践三个“第一”——质量第一、信誉第一，服务第一，企业不断深化改革，深挖潜力，降低成本，以最低的价格吸引客户，以最好的质量服务客户，让辉煌网架钢构建设遍布全国各地，多年来深受广大客户及建设单位的一致好评。 　　竭诚欢迎各界新老朋友真诚合作、共创辉煌、共享绩效，公司将一如既往地为各界朋友提供优秀的服务！

01.04.2008 09:26:50 changed by anonymous

徐州辉煌钢结构工程有限公司是一家集网架钢结构设计、制作、安装及技术服务为一体的大型专业化企业。公司坐落于有网架之乡美誉的江苏省徐州市，这里是全国优质网架原材料供应基地，也是全国网架技术熟练工人培训基地，有着人才，技术和原材料的地域优势。企业创办多年来，本着"求实创新、开拓进取"的精神，不断引进吸收国内外先进技术经验，汇集来自全国各地从事专业管理，专业设计、制造、检测试验等高级优秀人才，配置了各种先进的成套生产和检测设备，能满足制造生产能力要求的流水生产线。公司始终本着“诚信为本、信守合同、用户至上”的理念，坚持贯彻实践三个“第一”——质量第一、信誉第一，服务第一，企业不断深化改革，深挖潜力，降低成本，以最低的价格吸引客户，以最好的质量服务客户，让辉煌网架钢构建设遍布全国各地，多年来深受广大客户及建设单位的一致好评。 　　竭诚欢迎各界新老朋友真诚合作、共创辉煌、共享绩效，公司将一如既往地为各界朋友提供优秀的服务！

09.04.2008 08:38:08 changed by anonymous

电子地磅解码器,吨位遥控器/本吨位遥控器引进日本先进技术研制而成，完全采用数字式集成电路技术，采用万能解码数据处理线路，适用于10----150吨以下吨位，无须对地磅作任何改动 具有防拦截，防扫描等优点，解码器安装于车上或离地磅8米以内，在电子称旁40米或60米以内，能控制电子称的数码数据，最小值20公斤，规格10 /15/20，此产品主要产生电子磁场干扰和控制，从而使吨位变大或变小，性能稳定可靠，体积小，遥控主机 解码处理器 如烟盒大小，遥控器配两种型号，隐蔽性强，附件含使用光盘一套，

Add/Change #403 (Use of uninitialized value Hashing.pm errors)