Hello!
Log says:
[Thu Nov 17 20:22:56.324892 2016] [:error] [pid 3144:tid 1612] [client ::1:50234] PHP Warning: include_once(/var/www/openemr/interface/globals.php): failed to open stream: No such file or directory in C:\xampp\htdocs\openemr\modules\sms_email_reminder\cron_sms_notification.php on line 20
[Thu Nov 17 20:22:56.324892 2016] [:error] [pid 3144:tid 1612] [client ::1:50234] PHP Warning: include_once(): Failed opening â/var/www/openemr/interface/globals.phpâ for inclusion (include_path=â\xampp\php\PEARâ) in C:\xampp\htdocs\openemr\modules\sms_email_reminder\cron_sms_notification.php on line 20
[Thu Nov 17 20:22:56.325892 2016] [:error] [pid 3144:tid 1612] [client ::1:50234] PHP Warning: include_once(/var/www/openemr/modules/sms_email_reminder/cron_functions.php): failed to open stream: No such file or directory in C:\xampp\htdocs\openemr\modules\sms_email_reminder\cron_sms_notification.php on line 21
[Thu Nov 17 20:22:56.325892 2016] [:error] [pid 3144:tid 1612] [client ::1:50234] PHP Warning: include_once(): Failed opening â/var/www/openemr/modules/sms_email_reminder/cron_functions.phpâ for inclusion (include_path=â\xampp\php\PEARâ) in C:\xampp\htdocs\openemr\modules\sms_email_reminder\cron_sms_notification.php on line 21
[Thu Nov 17 20:22:56.325892 2016] [:error] [pid 3144:tid 1612] [client ::1:50234] PHP Fatal error: Call to undefined function cron_getNotificationData() in C:\xampp\htdocs\openemr\modules\sms_email_reminder\cron_sms_notification.php on line 36
[Thu Nov 17 20:23:01.571387 2016] [:error] [pid 3144:tid 1616] [client ::1:50235] SQL Error with statement:could not disconnect from mysql server link==>C:\xampp\htdocs\openemr\modules\sms_email_reminder\cron_email_notification.php at 78:sqlClose
thank you very much!!! Iâm getting closer and closer to this one working !!
Now it is only this error when trying to use cron_sms_notification, the error says in the web browser âError in SMS authorization! (ERR: 108, Invalid or missing api_id)â
Any ideas?
I have the 3 complete fields in twilio of Twilio Account Sid, Twilio Auth Token and
Twilio From name.
Do you have to put the same data in a file? Any other ideas?
Many thanks again!
Something is still wrong, even if you leave all the fields empty in the notification -> Twilio (Twilio Account Sid, Twilio Auth Token and Twilio From name) the same error âError in SMS authorization!â Appears (ERR: 108, Invalid or missing api_id). . Do not put any additional settings in some of the files modified in global.inc or cron_sms_notification or add something in the database?
regards
Yes, I copied all the files from oemrtwilio/openemr at master ¡ fkasmani/oemrtwilio ¡ GitHub. I have a twilio directory where there are many files and folders. But as I say before, even if you have all fields empty in notification-> Twilio, the error 108 of missing or invalid api_id still appears
I have all the files listed on that link. I insist that somewhere something must be configured to not check with clickatell if it is not used. The only change I made looking at the link you sent me, is that the Twilio folder must be copied to library. It is the last post in the link you passed me make that clarification.
in apache/log:
[Mon Nov 21 11:23:57.403168 2016] [:error] [pid 3708:tid 1624] [client 192.168.2.202:45298] PHP Deprecated: mysql_query(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in C:\xampp\htdocs\openemr\modules\sms_email_reminder\cron_sms_notification.php on line 41
[Mon Nov 21 11:23:57.403168 2016] [:error] [pid 3708:tid 1624] [client 192.168.2.202:45298] PHP Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\openemr\modules\sms_email_reminder\cron_sms_notification.php on line 42
but the question is, in that version if it works smoothly Twilio?
I think itâs easier to lose version which function effectively Twilio to be with version 4.2.2 and investigate the oriden the problem I have.
Regards!
retry with these files, youâll have to set values in Globals->Notifications for the newly named globals, and the message goes on line 101 of the cron_sms file
Yesss! Stephenâre a genius! Those were apparently the correct files. I can finally see the message in the browser !!! So I guess I should be failing some of sending message or some other configuration because even the message is not sent, but rather the outlook has improved. When you have your results tell them and how finally stay.
I hope to resolve it quickly. Just need to be send sms.
Thanks for the help.
0 DEBUG :: user=sms username
Total 1 Records Found ----- DEBUG :cron_sms: found patient = Ariel DEBUG :: checkdate=2016-11-22, app_date=2016-11-22 11:45:00, apptime=1479811500 remain_hour=12 â CRON_TIME=0
ERROR: could not disconnect from mysql server link
C:\xampp\htdocs\openemr\modules\sms_email_reminder\cron_sms_notification.php at 127:sqlClose
what are your values for these fields?
SMS Notification Hours
enable twilio
Twilio From name (should be the twilio phone #, you probably shouldnât post it), i followed this https://www.twilio.com/docs/api/rest/test-credentials
These are the data I have completed in notifications -> Twilio. Twilio Account Sid and Twilio Auth Token data are the âLIVE Credentialsâ of Twilio. Is âTwilio From Nameâ the magic number I found in a tutorial, or should I have another magic number provided by Twilio to not use my real number?
The current situation is that sms messages are left in a queue and are not sent.