Send SMS failed after upgrading from rc8 to 1.0

playSMS Install and Upgrade
1

Hi everyone,

As written in the title of this post, I have just upgraded my perfectly working playSMS installation from rc8 to version 1.0 stable. But after the upgrade, I tried to send SMS and got failed. How can I solve it ?

Best regards,

Edouard.

2

I think you have failed to insert the update sql file and didnt notice it and continue

which manual did you followed ?

anton

3

I followed that one : Upgrade from playSMS 1.0-rc8 or 1.0-rc9 to 1.0
Yeah, in fact I got some issues tempting to update sql file and following your advice, I removed the lines causing me troubles. Is there any way to restart updating the sql file to see what is wrong ?

Edouard

4

drop the db, re insert your old sql file, then insert the upgrade sql file (from rc8.to 1.0)

anton

5

Hi @anton,

I’ve just dropped the db and reinsertes my old sql file. And then, looking at the playsms_tblRegistry table, I notice that I’m trying to upgrade to 1.0 coming from rc7 ! :worried:

So the point is that how could I upgrade from rc7 to 1.0 ?

Best,

Edouard.

6

ok, so its not from rc8 as you said ? confirm me

anton

7

Yes @anton. I confirm.

Edouard

8

do you remember the step how to insert upgrade sql ?

now, instead of using rc8 file, use this sql file instead:
https://raw.githubusercontent.com/antonraharja/playSMS/master/db/playsms-upgrade_1.0-rc7_to_1.0.sql

anton

9

I did it and got this error : ERROR 1060 (42S21) at line 7: Duplicate column name ‘p_smsc’

Edouard

10

edit the file, and remove form the top until the line containing p_smsc

from top until this one:

ALTER TABLEplaysms_tblSMSOutgoingCHANGEp_gatewayp_smscVARCHAR(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';

and then re-insert

anton

11

by re-insert I meant after you edit, remove those line I asked you, save the file, then insert that file again, no need to drop db and all again

anton

12

I dit it and got this time this error : ERROR 1060 (42S21) at line 1: Duplicate column name ‘p_gateway’ :worried:

Edouard

13

do exactly like before, just remove form the top until that line (its 1 line after previous error), then re insert again

anton

14

Doing so, I ended up again with an error. This time the error is : ERROR 1091 (42000) at line 33: Can’t DROP ‘uid_mobile’; check that column/key exists.

I guess I must remove the problematic line again and again till it’s OK. Right ?

15

Yup. Until the import finishes cleanly, no error. Always remove from the top until the line causing the error.

anton

1 Like
16

Done. Import finished. Now, when I send SMS, it failed. :worried:

Edouard

17

for all we know now your server is using playSMS 1.0, so lets start debugging

please set logstate to 3 on your config.php, and restart your playsmsd, playsmsd restart

and then watch the log:

tail -f /var/log/playsms/playsms.log | tee test1.txt

and then send single SMS (which will fail)

ctrl+c the tail command above and send me the test1.txt (sanitize first for numbers and private info, and then attach the file)

anton

18

Please, find attached the debug file. test1.txt (8.2 KB)

Edouard

19

it looks like Kannel drop your SMS, I see no error on playSMS part

see this part:

- - 2015-06-08 10:47:12 PID55755690a30d7 - L2 sendsms # saving smslog_id:114 u:1 g:0 gw:kannel smsc:mobiweb s:EDOUARD d:22966477832 type:text unicode:0 status:0
- - 2015-06-08 10:47:12 PID55755690a30d7 - L2 sendsms_process # saved smslog_id:114 id:112
- - 2015-06-08 10:47:12 PID55755690a30d7 - L3 sendsms # final smslog_id:114 gw:kannel smsc:mobiweb message:Hi u there, good morning!! len:26
- - 2015-06-08 10:47:12 PID55755690a30d7 - L3 kannel_hook_sendsms # enter smsc:mobiweb smslog_id:114 uid:1 to:22966477832
- - 2015-06-08 10:47:12 PID55755690a30d7 - L3 kannel_hook_sendsms # URL: http://localhost:13131/cgi-bin/sendsms?username=playsms&password=playsms&from=EDOUARD&to=22966477832&dlr-mask=31&dlr-url=http%3A%2F%2Flocalhost%2Fplaysms%2Findex.php%3Fapp%3Dcall%26cat%3Dgateway%26plugin%3Dkannel%26access%3Ddlr%26type%3D%25d%26smslog_id%3D114%26uid%3D1&account=admin&text=Hi+u+there%2C+good+morning%21%21&smsc=MobiWEB
- - 2015-06-08 10:47:12 PID55755690a30d7 - L3 dlr # isdlrd:1 smslog_id:114 p_status:2 uid:1
- - 2015-06-08 10:47:12 PID55755690a30d7 - L3 kannel__outgoing # end smslog_id:114 p_status:2

your Kannel reject/denied playSMS (meaning playSMS has done its job).

you can try submit this from browser (change localhost if your Kannel server IP):

http://localhost:13131/cgi-bin/sendsms?username=playsms&password=playsms&from=EDOUARD&to=22966477832&dlr-mask=31&dlr-url=http%3A%2F%2Flocalhost%2Fplaysms%2Findex.php%3Fapp%3Dcall%26cat%3Dgateway%26plugin%3Dkannel%26access%3Ddlr%26type%3D%25d%26smslog_id%3D114%26uid%3D1&account=admin&text=Hi+u+there%2C+good+morning%21%21&smsc=MobiWEB

anton

1 Like
20

Yeah ! I did it !

Indeed, playSMS has done its job. Trying to submit from lynk browser, it failed. Then, I checked config files and everything was ok except that smsbox was off. I restarted it and everything is working fine now.

Thank you very much for the assistance. Great software, great forum ! :smile:

Edouard