Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- by gsavix@gmail for gammu 1.38.4 test for smsd-gammu connection
- a) please read this page for understand mysql smsd
- "mysql backend" [1] https://wammu.eu/docs/manual/smsd/mysql.html
- b) after pass c) please run this step for you get these minimum privileges
- "privileges" [2] https://wammu.eu/docs/manual/smsd/mysql.html#privileges
- c) use this last stable (at 08-2017) version 16 for create sql tables and trigger of gammu;
- "source for mysql.sql" download [3] https://pt-br.wammu.eu/download/gammu/
- look at folder your-download-folder\gammu1384\gammu-1.38.4\docs\sql (\ windows or / linux - mac)
- d) connect your host, database, user, password for display database components;
- at terminal linux - mac or cmd window for windows (now look at lines mysql> prompt for mysql)
- to leave mysql use command quit
- -p prompt for password at connection time
- your-prompt-$ mysql -D your_database-name -h your_host -u your_mysql_user -p
- Enter password:
- Welcome to the MySQL monitor. Commands end with ; or \g.
- Your MySQL connection id is 12345678981
- Server version: 5.5.51-38.2 Percona Server (GPL), Release 38.2, Revision 727
- Copyright (c) 2009-2016 Percona LLC and/or its affiliates
- Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.
- Oracle is a registered trademark of Oracle Corporation and/or its
- affiliates. Other names may be trademarks of their respective
- owners.
- Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
- mysql> show tables;
- Connection id: 12397462
- Current database: dg1384
- +---------------------------+
- | Tables_in_dg1384 |
- +---------------------------+
- | gammu |
- | inbox |
- | outbox |
- | outbox_multipart |
- | phones |
- | sentitems |
- +---------------------------+
- 6 rows in set (0.00 sec)
- mysql> describe outbox;
- Current database: dg1384
- +-------------------+------------------------------------------------------------------------------------------------------------+------+-----+------------------------+-----------------------------+
- | Field | Type | Null | Key | Default | Extra |
- +-------------------+------------------------------------------------------------------------------------------------------------+------+-----+------------------------+-----------------------------+
- | UpdatedInDB | timestamp | NO | | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP |
- | InsertIntoDB | timestamp | NO | | 0000-00-00 00:00:00 | |
- | SendingDateTime | timestamp | NO | MUL | 0000-00-00 00:00:00 | |
- | SendBefore | time | NO | | 23:59:59 | |
- | SendAfter | time | NO | | 00:00:00 | |
- | Text | text | YES | | NULL | |
- | DestinationNumber | varchar(20) | NO | | | |
- | Coding | enum('Default_No_Compression','Unicode_No_Compression','8bit','Default_Compression','Unicode_Compression') | NO | | Default_No_Compression | |
- | UDH | text | YES | | NULL | |
- | Class | int(11) | YES | | -1 | |
- | TextDecoded | text | NO | | NULL | |
- | ID | int(10) unsigned | NO | PRI | NULL | auto_increment |
- | MultiPart | enum('false','true') | YES | | false | |
- | RelativeValidity | int(11) | YES | | -1 | |
- | SenderID | varchar(255) | YES | MUL | NULL | |
- | SendingTimeOut | timestamp | YES | | 0000-00-00 00:00:00 | |
- | DeliveryReport | enum('default','yes','no') | YES | | default | |
- | CreatorID | text | NO | | NULL | |
- | Retries | int(3) | YES | | 0 | |
- | Priority | int(11) | YES | | 0 | |
- +-------------------+------------------------------------------------------------------------------------------------------------+------+-----+------------------------+-----------------------------+
- 20 rows in set (0.00 sec)
- mysql> quit
- Bye
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement