192
| SMSEagle MHD-8100
| User’s Manual
Once database access is enabled, it is possible to connect to the database from external application using
the following credentials:
Injecting short SMS using SQL
The simplest example is short text message (limited to 160 chars):
INSERT INTO outbox (
DestinationNumber,
TextDecoded,
CreatorID,
Coding,
Class,
SenderID
) VALUES (
'1234567',
'This is a SQL test message',
'Program',
'Default_No_Compression',
-1,
'smseagle1'
);
INSERT INTO user_outbox (
id_outbox,
id_user
) SELECT CURRVAL(pg_get_serial_sequence('outbox','ID')), 1;
In the above example the message will belong to user with
id_user
1 (default 'admin'). You can find id_user
values for other users in table public."user". Field SenderID contains identification number of SMSEagle
modem. For modem 1 SenderID = smseagle1, SenderID = smseagle2 for modem 2, etc.
P
OSTGRE
SQL
DATABASE CREDENTIALS
Host: IP address of your device
Database name: smseagle
Password: postgreeagle
User: smseagleuser
Summary of Contents for MHD-8100-3G
Page 1: ...SMSEAGLE MHD 8100 3G MHD 8100 4G User s Manual ...
Page 9: ...9 SMSEagle NXS 9700 3G User s Manual GET READY TO START I ...
Page 21: ...21 SMSEagle MHD 8100 User s Manual USING OF SMSEAGLE II ...
Page 76: ...76 SMSEagle MHD 8100 User s Manual Screenshot from Blacklist Define STOP word feature ...
Page 207: ...207 SMSEagle MHD 8100 User s Manual TROUBLESHOOTING I I I I I I ...
Page 210: ...210 SMSEagle MHD 8100 User s Manual SERVICE REPAIR IV I ...
Page 212: ...212 SMSEagle MHD 8100 User s Manual TECH SPECS SAFETY INFORMATION V I ...