SMSEagle NXS-9700-3G, Руководство пользователя

Страница: 201 / 229

201
| SMSEagle NXS-9700 | User’s Manual
Once database access isenabled, 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".
P
OSTGRE
SQL
DATABASE CREDENTIALS
Host: IP address of your device
Database name: smseagle
Password: postgreeagle
User: smseagleuser