on scratch install with MYSQL

[ruben23]

hi im creating data for my asterisk database

GRANT SELECT,INSERT,UPDATE,DELETE on asterisk.* TO cron@'%' ==>OK
IDENTIFIED BY '1234'; ==>OK
GRANT SELECT,INSERT,UPDATE,DELETE on asterisk.* TO cron@localhost
IDENTIFIED BY '1234';
create database asterisk;
use asterisk; ALL ARE WORKING GOOD..

then when i got to input

\. /usr/share/astguiclient/MySQL_AST_CREATE_tables.sql

got this error:

mysql> \. /usr/share/astguiclient/MySQL_AST_CREATE_tables.sql
ERROR:
Failed to open file '/usr/share/astguiclient/MySQL_AST_CREATE_tables.sql', error: 2
mysql> \. /usr/share/astguiclient/MySQL_AST_CREATE_tables.sql
ERROR:
Failed to open file '/usr/share/astguiclient/MySQL_AST_CREATE_tables.sql', error: 2
mysql> \. /usr/share/astguiclient/MySQL_AST_CREATE_tables.sql
ERROR:
Failed to open file '/usr/share/astguiclient/MySQL_AST_CREATE_tables.sql', error: 2
mysql> GRANT SELECT on asterisk.phones TO idcheck@'%' IDENTIFIED BY '1234';
ERROR 1146 (42S02): Table 'asterisk.phones' doesn't exist
mysql> \. /usr/share/astguiclient/MySQL_AST_CREATE_tables.sql
ERROR:
Failed to open file '/usr/share/astguiclient/MySQL_AST_CREATE_tables.sql', error: 2
mysql> \. /usr/share/astguiclient/MySQL_AST_CREATE_tables.sql
ERROR:

what could happen:

i view the directory /usr/share/ls ( no astguiclient directory)

what did i missed..

[mflorell]

Depending on the version of MySQL and the permissions on your system you may have to move the SQL file to the mysql data directory to run it.

[williamconley]

alternate method:

cd /usr/src/astguiclient (use your correct path here)
mysql asterisk < MySQL_AST_CREATE_tables.sql -u UUUU -pXXXXX

replace "UUUU" with the user (root, for instance) and XXXX with the user's mysql password (and no, there isn't a space between -p and XXXXX, and that's not a mistake).

[ruben23]

yes i got it...i just change the directory where the MySQL_AST_CREATE_tables.sql belongs

in me its /usr/src/astguiclient/extras/MySQL_AST_CREATE_tables.sql

then it runs...