Re: Wammu and SGH-J700 with Xenial Xerus 16.04

On Fri, 25 Aug 2017 15:08:13 -0300
gilberto dos santos alves <[email protected]> wrote:

> hi. you have mysql error not gammu errors.

I'm talking about mysql.sql, from doc/gammu/examples/sql directory. However,

> please create a empty database named gammudb;
> insert this sql command for gammudb:
> 
> use gammudb;       <---- this command tells that script will use gammudb
> for create table.
> 

I've created 'gammudb' empty database:

mysql> CREATE DATABASE gammudb;
Query OK, 1 row affected (0,04 sec)

and everything seems normal, as shown:

mysql> SHOW GRANTS;
+-------------------------------------------------------------------------------+
| Grants for cristian@localhost                                                 |
+-------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'cristian'@'localhost'                                  |
| GRANT SELECT, INSERT, UPDATE, DELETE ON `gammudb`.* TO 'cristian'@'localhost' |
+-------------------------------------------------------------------------------+
2 rows in set (0,00 sec)

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| gammudb            |
+--------------------+
2 rows in set (0,04 sec)

After:

mysql> use gammudb;
Database changed

I get:

mysql> show tables;
Empty set (0,00 sec)

If I type 'source mysql.sql' command, I get the following output:

ERROR 1142 (42000): CREATE command denied to user 'cristian'@'localhost' for table 'gammu'
ERROR 1146 (42S02): Table 'gammudb.gammu' doesn't exist
ERROR 1142 (42000): CREATE command denied to user 'cristian'@'localhost' for table 'inbox'
ERROR 1142 (42000): CREATE command denied to user 'cristian'@'localhost' for table 'outbox'
ERROR 1142 (42000): INDEX command denied to user 'cristian'@'localhost' for table 'outbox'
ERROR 1142 (42000): INDEX command denied to user 'cristian'@'localhost' for table 'outbox'
ERROR 1142 (42000): CREATE command denied to user 'cristian'@'localhost' for table 'outbox_multipart'
ERROR 1142 (42000): CREATE command denied to user 'cristian'@'localhost' for table 'phones'
ERROR 1142 (42000): CREATE command denied to user 'cristian'@'localhost' for table 'sentitems'
ERROR 1142 (42000): INDEX command denied to user 'cristian'@'localhost' for table 'sentitems'
ERROR 1142 (42000): INDEX command denied to user 'cristian'@'localhost' for table 'sentitems'
ERROR 1142 (42000): INDEX command denied to user 'cristian'@'localhost' for table 'sentitems'
ERROR 1142 (42000): INDEX command denied to user 'cristian'@'localhost' for table 'sentitems'
ERROR 1142 (42000): TRIGGER command denied to user 'cristian'@'localhost' for table 'inbox'
ERROR 1142 (42000): TRIGGER command denied to user 'cristian'@'localhost' for table 'outbox'
ERROR 1142 (42000): TRIGGER command denied to user 'cristian'@'localhost' for table 'phones'
ERROR 1142 (42000): TRIGGER command denied to user 'cristian'@'localhost' for table 'sentitems'

Anyway, if I run the script as mysql 'root' user in place of mysql 'cristian' user, I continue to get same error messages seen last time (so there are no differences between 'gammu' and 'gammudb' names for the database, in this case):

mysql> show tables;
ERROR 1046 (3D000): No database selected
mysql> use gammudb;
Database changed
mysql> show tables;
Empty set (0,00 sec)

mysql> SHOW GRANTS;
+---------------------------------------------------------------------+
| Grants for root@localhost                                           |
+---------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION |
| GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION        |
+---------------------------------------------------------------------+
2 rows in set (0,00 sec)

mysql> source mysql.sql
Query OK, 0 rows affected (0,10 sec)

Query OK, 1 row affected (0,01 sec)

ERROR 1067 (42000): Invalid default value for 'ReceivingDateTime'
ERROR 1067 (42000): Invalid default value for 'InsertIntoDB'
ERROR 1146 (42S02): Table 'gammudb.outbox' doesn't exist
ERROR 1146 (42S02): Table 'gammudb.outbox' doesn't exist
Query OK, 0 rows affected (0,05 sec)

ERROR 1067 (42000): Invalid default value for 'InsertIntoDB'
ERROR 1067 (42000): Invalid default value for 'InsertIntoDB'
ERROR 1146 (42S02): Table 'gammudb.sentitems' doesn't exist
ERROR 1146 (42S02): Table 'gammudb.sentitems' doesn't exist
ERROR 1146 (42S02): Table 'gammudb.sentitems' doesn't exist
ERROR 1146 (42S02): Table 'gammudb.sentitems' doesn't exist
ERROR 1146 (42S02): Table 'gammudb.inbox' doesn't exist
ERROR 1146 (42S02): Table 'gammudb.outbox' doesn't exist
ERROR 1146 (42S02): Table 'gammudb.phones' doesn't exist
ERROR 1146 (42S02): Table 'gammudb.sentitems' doesn't exist

and, just as seen last time, only two tables are created:

mysql> show tables;
+-------------------+
| Tables_in_gammudb |
+-------------------+
| gammu             |
| outbox_multipart  |
+-------------------+
2 rows in set (0,00 sec)

Any ideas?

I'll expect a reply,

Thanks.

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Gammu-users mailing list - https://lists.sourceforge.net/lists/listinfo/gammu-users