Re: Avantfax 3.3.5 new Notify.php error Call to undefined function: MDB2_Driver_mysql::raiseError()?

On 02/21/2019 01:22 PM, David C. Rankin wrote:
> David, all
> 
>   This is really weird, Hylafax/Avantfax has been working fine, but it seems
> in the past week or so there have been failures importing from the
> hylafax/doneq by notify.php, e.g.
> 
> # bin/notify.php "doneq/q164" "done" "0:02:30"
> notify> Executing: doneq/q164 done 0:02:30  (4)
> totpages: 4
> external: 2059163
> mailaddr: [email protected]
> jobid: 164
> receiver:
> company:
> location:
> voice:
> regarding:
> owner: david
> groupid: 164
> status:
> Found file: docq/doc155.pdf
> PHP Fatal error:  Call to undefined function: MDB2_Driver_mysql::raiseError().
> in /usr/share/php56/pear/MDB2.php on line 1936
> 
> The link in bin is fine, e.g.
> 
> notify.php -> /srv/http/avantfax/includes/notify.php
> 
>   The strange part is the recvq is working and I'm getting faxes, but
> sometimes it seems that avantfax doesn't reload the page to show the new
> faxes. Clicking outbox and back to inbox the new faxes show.
> 
>   The doneq worked once this morning, but has since stopped. The only updates
> recently were to systemd last night. So since I have had notiify.php work
> putting one fax in the archive, but not fails with 2 faxes left in the doneq
> and one not showing in the archive.
> 
>   I'm stumped on this one, but I can be a talented monkey on this end of the
> keyboard to get you any diagnostics you need. Thanks.
> 

The problem seems to stem from an invalid integer being (sent/received?) from
AddressBook, e.g.


The relevant portion of the strace of the notify command is:

sendto(3, "\353\0\0\0\3UPDATE AddressBookFAX SET a"..., 239, MSG_DONTWAIT,
NULL, 0) = 239
poll([{fd=3, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd=3,
revents=POLLIN}])
recvfrom(3, "_\0\0\1\377V\5#2200", 12, MSG_DONTWAIT, NULL, NULL) = 12
poll([{fd=3, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd=3,
revents=POLLIN}])
recvfrom(3, "7Incorrect integer value: '' for"..., 97, MSG_DONTWAIT, NULL,
NULL) = 87
write(2, "PHP Fatal error:  Call to undefi"..., 126PHP Fatal error:  Call to
undefined function: MDB2_Driver_mysql::raiseError(). in
/usr/share/php56/pear/MDB2.php on line 1936
) = 126

You got me. The command sends an "...UPDATE AddressBookFAX SET a" and then
gets back a ".Incorrect integer value: '' for". What is bizarre is an outgoing
fax earlier got to the archive without a hitch.

The full strace beginning with the SELECT on AddressBook is:

sendto(3, "=\0\0\0\3SELECT * FROM AddressBookFA"..., 65, MSG_DONTWAIT, NULL,
0) = 65
poll([{fd=3, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd=3,
revents=POLLIN}])
recvfrom(3, "\1\0\0\1\fP\0\0\2\3def\10avantfax\16AddressBo"..., 53,
MSG_DONTWAIT, NULL, NULL) = 53
poll([{fd=3, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd=3,
revents=POLLIN}])
recvfrom(3, "abookfax_id\vabookfax_id\f?\0\v\0\0\0\3\3"..., 97, MSG_DONTWAIT,
NULL, NULL) = 97
poll([{fd=3, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd=3,
revents=POLLIN}])
recvfrom(3, "k_id\f?\0\v\0\0\0\3\0\0\0\0\0L\0\0\4\3def\10avantf"..., 97,
MSG_DONTWAIT, NULL, NULL) = 97
poll([{fd=3, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd=3,
revents=POLLIN}])
recvfrom(3, "D\0\0\5\3def\10avantfax\16AddressBookFAX"..., 97, MSG_DONTWAIT,
NULL, NULL) = 97
poll([{fd=3, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd=3,
revents=POLLIN}])
recvfrom(3, "BookFAX\16AddressBookFAX\vdescripti"..., 97, MSG_DONTWAIT, NULL,
NULL) = 97
poll([{fd=3, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd=3,
revents=POLLIN}])
recvfrom(3, "ssBookFAX\tto_person\tto_person\f!\0"..., 97, MSG_DONTWAIT, NULL,
NULL) = 97
poll([{fd=3, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd=3,
revents=POLLIN}])
recvfrom(3, "tion\vto_location\f!\0\302\1\0\0\375\0\0\0\0\0V\0\0"..., 97,
MSG_DONTWAIT, NULL, NULL) = 97
poll([{fd=3, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd=3,
revents=POLLIN}])
recvfrom(3, "icenumber\f!\0\302\1\0\0\375\0\0\0\0\0J\0\0\n\3def\10a"..., 97,
MSG_DONTWAIT, NULL, NULL) = 97
poll([{fd=3, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd=3,
revents=POLLIN}])
recvfrom(3, "\0\0\0H\0\0\v\3def\10avantfax\16AddressBook"..., 97,
MSG_DONTWAIT, NULL, NULL) = 97
poll([{fd=3, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd=3,
revents=POLLIN}])
recvfrom(3, "AddressBookFAX\16AddressBookFAX\5fa"..., 97, MSG_DONTWAIT, NULL,
NULL) = 97
poll([{fd=3, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd=3,
revents=POLLIN}])
recvfrom(3, "kFAX\7printer\7printer\f!\0,\1\0\0\375\0\0\0\0"..., 97,
MSG_DONTWAIT, NULL, NULL) = 85
mmap(NULL, 266240, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) =
0x7f7b32051000
sendto(3, "\353\0\0\0\3UPDATE AddressBookFAX SET a"..., 239, MSG_DONTWAIT,
NULL, 0) = 239
poll([{fd=3, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd=3,
revents=POLLIN}])
recvfrom(3, "_\0\0\1\377V\5#2200", 12, MSG_DONTWAIT, NULL, NULL) = 12
poll([{fd=3, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd=3,
revents=POLLIN}])
recvfrom(3, "7Incorrect integer value: '' for"..., 97, MSG_DONTWAIT, NULL,
NULL) = 87
write(2, "PHP Fatal error:  Call to undefi"..., 126PHP Fatal error:  Call to
undefined function: MDB2_Driver_mysql::raiseError(). in
/usr/share/php56/pear/MDB2.php on line 1936
) = 126
close(2)                                = 0
close(1)                                = 0
close(0)                                = 0
rt_sigaction(SIGPIPE, {sa_handler=SIG_IGN, sa_mask=[PIPE],
sa_flags=SA_RESTORER|SA_RESTART, sa_restorer=0x7f7b3750de00},
{sa_handler=SIG_IGN, sa_mask=[PIPE], sa_flags=SA_RESTORER|SA_RESTART,
sa_restorer=0x7f7b3750de00}, 8) = 0
sendto(3, "\1\0\0\0\1", 5, MSG_DONTWAIT, NULL, 0) = 5
close(3)                                = 0
rt_sigaction(SIGPIPE, {sa_handler=SIG_IGN, sa_mask=[PIPE],
sa_flags=SA_RESTORER|SA_RESTART, sa_restorer=0x7f7b3750de00},
{sa_handler=SIG_IGN, sa_mask=[PIPE], sa_flags=SA_RESTORER|SA_RESTART,
sa_restorer=0x7f7b3750de00}, 8) = 0

  I'll keep working with it.. The irony of it being a time-critical day with
subpoena and witness acceptances going and coming.... Murphy..


-- 
David C. Rankin, J.D.,P.E.


____________________ HylaFAX(tm) Users Mailing List _______________________
  To subscribe/unsubscribe, click http://lists.hylafax.org/cgi-bin/lsg2.cgi
 On UNIX: mail -s unsubscribe [email protected] < /dev/null
  *To learn about commercial HylaFAX(tm) support, mail [email protected].*