Can't get Inbox into MySQL

Can't get Inbox into MySQL SearchSearch

SMS & MMS Technical Forum » NowSMS Support - MMS & Advanced Issues (Product Support Only) » Can't get Inbox into MySQL « Previous || Next »
Author Message
tantomi yahya
New member
Username: Thantomy

Post Number: 1
Registered: 01-2016
Posted on Tuesday, January 26, 2016 - 08:27 am:   

Hello,

I can not get inbox into MySQL, i already follow the instruction but i still don't get the inbox on MySQL.

If there's some PHP script that i have to made, please give the instruction.

Thank you



this is the input..mysql
tantomi yahya
New member
Username: Thantomy

Post Number: 2
Registered: 01-2016
Posted on Tuesday, January 26, 2016 - 08:42 am:   

by the way, I'm using Android include NowSMS apk that i downloaded on this site.
Des - NowSMS Support
Board Administrator
Username: Desosms

Post Number: 5558
Registered: 08-2008
Posted on Tuesday, January 26, 2016 - 02:46 pm:   

Hi,

Here are 3 suggestions/tips:

1.) Remove the extra http:// from your command. It should start http://localhost/ and NOT http://http://localhost

2.) Test your script directly from a browser to make sure it is working as expected.

In other words, simulate what you expect to see from the 2-way command using a web browser, as this will make testing easier.

For example, use parameter strings like:


?si=99999&message=test1
?si=99998&message=test2
?si=%2B1111111111&message=test3
?si=%2B1111111111&message=test4%20more%20text

Once your script is working correctly from a web browser, go back to trying the script as a 2-way command in NowSMS.

3.) To better troubleshoot a 2-way command, enable the SMSDEBUG.LOG (checkbox on the Serial # page).

The SMSDEBUG.LOG is a little difficult to follow, but it will show information about 2-way command processing, showing the exact URL that NowSMS creates when it processes the message.

I strongly recommend running the web browser tests before progressing to this step.


--
Des
NowSMS Support
tantomi yahya
New member
Username: Thantomy

Post Number: 3
Registered: 01-2016
Posted on Monday, February 22, 2016 - 07:19 am:   

Sorry sir i don't really understand.
My code already can send message using mobilephone with php. But i can't get new message that received by my handphone.
So then point my question is
how can i receive sms information that sended to my mobile phone that already installed nowsms to database or maybe i can show it with my php code.
Thanks before
Des - NowSMS Support
Board Administrator
Username: Desosms

Post Number: 5580
Registered: 08-2008
Posted on Wednesday, February 24, 2016 - 04:26 pm:   

OK. It would help if you would explain what part of my response you do not understand.

But I will try again...and will try to explain more clearly...

1.) Your screen captures show the following 2-way command:

http://http://localhost/buku%20tamu%20tes/indextest.php?isi=sender=@@SENDER@@&me ssage=@@FULLSMS@@

That URL is invalid. Remove the extra http://, like this:

http://localhost/buku%20tamu%20tes/indextest.php?isi=sender=@@SENDER@@&message=@ @FULLSMS@@

2.) I am confused by the variables in your URL:

?isi=sender=@@SENDER@@&message=@@FULLSMS@@

Do you wish to set the @@SENDER@@ variable to isi or sender? I will assume isi= is a mistake, and the URL should be:

http://localhost/buku%20tamu%20tes/indextest.php?sender=@@SENDER@@&message=@@FUL LSMS@@

3.) Forget about NowSMS for this step. Test your script directly from a browser to make sure it is working as expected.

In other words, simulate what you expect to see when NowSMS receives a message, as this will make testing easier.

Using a web browser, simulate receiving a test message from 999999, by entering the following URL into a web browser:

http://localhost/buku%20tamu%20tes/indextest.php?sender=999999&message=test

Do not go back to NowSMS until you are successful with these tests from a web browser.


4.) After your script is working correctly from a web browser, go back to trying the script as a 2-way command in NowSMS.

To better troubleshoot a 2-way command, enable the SMSDEBUG.LOG (there is a checkbox on the "Serial #" page).

The SMSDEBUG.LOG is a little difficult to follow, but it will show information about 2-way command processing, showing the exact URL that NowSMS creates when it processes the message.

If you are still having problems, show me what is in this SMSDEBUG.LOG when you send a message to NowSMS.

--
Des
NowSMS Support
tantomi yahya
New member
Username: Thantomy

Post Number: 4
Registered: 01-2016
Posted on Monday, March 07, 2016 - 07:42 am:   

sorry i take your time to understand what do you mean..
i already test the script
using http://localhost/NUI/inboxscript.php?phone=0932871492&text=testasdsadwd
for my script and its work..
and then http://localhost/NUI/inboxscript.php?phone=@@SENDER@@&text=@@FULLSMS@@
in the nowsms.. it didn't give any result..

this is the result of SMSDEBUG.LOG
15:36:06:176 [0] UseRouteCache: Yes
15:40:30:995 [2] ThreadListenForConnections: Before accept
15:40:30:995 [2] ThreadListenForConnections: After accept
15:40:30:996 [18] ThreadProcessConnection: Processing connection from 127.0.0.1...
15:40:31:005 [18] ThreadProcessConnection: Processing request /?Phone=085741344875&Text=gogoogogog
15:40:31:005 [18] Debug: 1 recipient entries
15:40:31:006 [18] CheckPreferredRouteMulti: Default Route Available
15:40:31:006 [18] CheckPreferredRouteMulti: NowSMSModem - tantomi
15:40:31:006 [18] MessageRoutesAdd: 56A4B19C.req
15:40:31:006 [18] MessageRoutesAdd: NowSMSModem - tantomi
15:40:31:006 [16] Debug: Signaled
15:40:31:007 [18] WaitForSocketClose: WinSock reported ioctlsocket complete
15:40:31:007 [18] ThreadProcessConnection: Request processing complete
15:40:31:058 [16] ThreadProcessModem: Processing 56A4B19C.req...
15:40:31:136 [16] InetServerConnect: Connected to nowsmsmodem_tantomi (192.168.0.101:80)
15:40:31:136 [16] ThreadProcessModem: POST / HTTP/1.1
Content-Type: application/x-nowsms-outboundmessage-sms
Host: nowsmsmodem_tantomi
User-Agent: Now SMS/MMS Gateway v2015.06.24
X-NowSMS-ReceiveSMS: Yes
X-NowSMS-ReceiveSMSPort: 8990
X-NowSMS-ReceiveMMS: No
Accept: */*
Connection: close
Content-Length: 79


15:40:31:136 [16] ThreadProcessModem: ¸]¥5î|cxoYx}gjst@5W,'U,X,.!YWzG@QPAh
15:40:36:015 [16] HttpResponseWait: Ok
15:40:36:015 [16] ThreadProcessModem: HTTP/1.1 200 OK
X-NowSMS-DeviceID: 352414061416761
X-NowSMS-DeviceName: tantomi
Content-Type: text/html
Date: Mon, 07 Mar 2016 08:40:15 GMT+00:00
Content-Length: 71
Connection: close

<html><head></head><body><p>OK,Recipient=085741344875</p></body></html>
15:40:36:016 [16] WaitForSocketClose: WinSock reported ioctlsocket complete
15:40:36:065 [1] ThreadListenForInboundConnections: Before accept
15:40:36:065 [1] ThreadListenForInboundConnections: After accept
15:40:36:065 [18] ThreadProcessInboundConnection: Processing connection from 192.168.0.101...
15:40:36:068 [18] ProcessInboundRequest: POST /InboundSMS/NowSMSModem HTTP/1.1
X-NowSMS-DeviceID: 352414061416761
X-NowSMS-DeviceName: tantomi
User-Agent: NowSMS Modem
Connection: close
Content-Type: application/x-nowsms-inboundmessage-sms
Content-Length: 37
Host: 192.168.0.102:8990

³«ÒA2Ë<qŸn7thZ)%&*' &'#/,")*_,:LMQb
15:40:36:068 [18] ProcessInboundRequest: tantomi
15:40:36:068 [18] ProcessInboundRequest: 352414061416761
15:40:36:069 [18] ProcessInboundRequest: From
15:40:36:069 [18] ProcessInboundRequest: +6285741344875
15:40:36:069 [18] ProcessInboundRequest: Text
15:40:36:069 [18] ProcessInboundRequest: gogoogogog
15:40:36:069 [18] ProcessInboundRequest: NowSMSModem - tantomi
15:40:36:074 [18] WaitForSocketClose: WinSock reported ioctlsocket complete
15:40:36:074 [18] ThreadProcessInboundConnection: Request processing complete
Des - NowSMS Support
Board Administrator
Username: Desosms

Post Number: 5594
Registered: 08-2008
Posted on Monday, March 07, 2016 - 10:29 am:   

Hmm...after that, there should be more activity as the 2-way command is processed for the received message.

Does your 2-Way configuration still look similar to the first message here? One command with keyword *

Is "Process received SMS Messages" still checked? (Like shown above) Does the View button show the message or a blank list?

On the SMSC page, select "Properties" for the Android modem, make sure that "Route SMS to local user" is blank, as if non-blank, the message would bypass NowSMS.

If still not working, please share SMSGW.INI

--
Des
NowSMS Support
tantomi yahya
New member
Username: Thantomy

Post Number: 5
Registered: 01-2016
Posted on Tuesday, March 08, 2016 - 03:06 am:   

its like this, i little confused abaout the keyword
and receive phone number use for. Process received SMS Messages is checked



on SMSC


A little Out of topic where i can find information about what's inside smsc properties? thanks
Des - NowSMS Support
Board Administrator
Username: Desosms

Post Number: 5596
Registered: 08-2008
Posted on Tuesday, March 08, 2016 - 11:39 am:   

Hi,

Ok, that is what I expected. "Route SMS to local user" is the problem.

This causes the message to get routed to a user inbox instead of the system level 2-way command.

Clear this (set as blank) and it will work.

"Receive Phone Number" can be blank, or match "Phone Number" in modem/SMSC Properties.

--
Des
NowSMS Support
Des - NowSMS Support
Board Administrator
Username: Desosms

Post Number: 5597
Registered: 08-2008
Posted on Tuesday, March 08, 2016 - 11:47 am:   

Our online docs are a bit out of date. Some missing pieces:

It is possible to configure NowSMS to route all SMS messages received via this SMSC connection to a user account on the NowSMS server by selecting the user account in the “Route SMS to local user” setting. It is possible for a user to connect to the NowSMS server either using SMPP (an SMS specific protocol), POP3 (an e-mail protocol), or a web browser interface. These user accounts are defined on the “SMS Users” page of the NowSMS configuration dialog.

Routing settings are described here: http://www.nowsms.com/doc/configuring-smsc-connections/routing-options

Add Your Message Here, or click here to create a new discussion topic.
Post:
Bold text Italics Underline Create a hyperlink Insert a clipart image
Posting Information:
This is a private posting area. Only registered users and moderators may post messages here.
Click here to create an account.
Username:
Password:
Options: Automatically activate URLs in message
Action:

Login Login / Register Logout Logout Search Last 30 Days Topics Topics