mysql> create database asterisk;
ERROR 1007: Can't create database 'asterisk'; database exists
mysql> GRANT SELECT,INSERT,UPDATE,DELETE on asterisk.* TO cron@'%' IDENTIFIED BY '1234';
Query OK, 0 rows affected (0.00 sec)
mysql> GRANT SELECT,INSERT,UPDATE,DELETE on asterisk.* TO cron@localhost IDENTIFIED BY '1234';
Query OK, 0 rows affected (0.00 sec)
mysql> UPDATE mysql.user set password=OLD_PASSWORD('1234') where user='cron';
Query OK, 2 rows affected (0.00 sec)
Rows matched: 2 Changed: 2 Warnings: 0
mysql> use asterisk;
Database changed
mysql> \. /usr/src/astguiclient/MySQL_AST_CREATE_tables.sql
ERROR:
Failed to open file '/usr/src/astguiclient/MySQL_AST_CREATE_tables.sql', error: 2
mysql>\. /usr/src/astguiclient/astguiclient/MySQL_AST_CREATE_tables.sql
ERROR:
Failed to open file '/usr/src/astguiclient/astguiclient/MySQL_AST_CREATE_tables.sql', error: 2
mysql> GRANT SELECT on asterisk.phones TO idcheck@'%' IDENTIFIED BY '1234';
ERROR 1146: Table 'asterisk.phones' doesn't exist
mysql> GRANT SELECT on asterisk.phones TO idcheck@localhost IDENTIFIED BY '1234';
ERROR 1146: Table 'asterisk.phones' doesn't exist
mysql> insert into servers (server_id,server_description,server_ip,active,asterisk_version)values('TESTasterisk','Test install of Asterisk server', '192.168.0.3','Y','1.2.14');
ERROR 1146: Table 'asterisk.servers' doesn't exist
mysql> insert into server_updater values('192.168.0.3','');
ERROR 1146: Table 'asterisk.server_updater' doesn't exist
mysql> insert into phones (extension, dialplan_number, voicemail_id, phone_ip, computer_ip, server_ip, login, pass, status, active, phone_type, fullname, company, picture, messages, old_messages, protocol) values('gs102','102','102','10.10.10.16','10.10.9.16','10.10.10.15','gs102','test', 'ADMIN','Y','Grandstream BT 102','Test Admin Phone','TEST','','0','0','SIP');
ERROR 1146: Table 'asterisk.phones' doesn't exist
what's going on here?.... did i miss something?...
In advance:
MANY THANKS for all of your HELP...
