[SR-Users] /mysql/#-create.sql: No such file or directory

[Kurt Mullen]

When attempting to run :

 

/usr/local/sbin/kamdbctl create

 

I get the following results:

 

/usr/local/lib/kamailio//kamctl/kamdbctl.mysql: line 155:
/usr/local/share/kamailio//mysql/#-create.sql: No such file or directory

ERROR: Creating core tables failed!

 

Contents of directory:

root at Kamailio:/usr/local/share/kamailio/mysql# ls

acc-create.sql           drouting-create.sql     purple-create.sql

alias_db-create.sql      group-create.sql        registrar-create.sql

auth_db-create.sql       htable-create.sql       rls-create.sql

avpops-create.sql        imc-create.sql          siptrace-create.sql

carrierroute-create.sql  lcr-create.sql          speeddial-create.sql

cpl-create.sql           matrix-create.sql       standard-create.sql

dialog-create.sql        msilo-create.sql        uac-create.sql

dialplan-create.sql      mtree-create.sql        uri_db-create.sql

dispatcher-create.sql    pdt-create.sql          userblacklist-create.sql

domain-create.sql        permissions-create.sql  usrloc-create.sql

domainpolicy-create.sql  presence-create.sql

 

Contents of kamdbctl.mysql

# path to the database schemas

DATA_DIR="/usr/local/share/kamailio/"

if [ -d "$DATA_DIR/mysql" ] ; then

        DB_SCHEMA="$DATA_DIR/mysql"

else

        DB_SCHEMA="./mysql"

Fi

 

for TABLE in $STANDARD_MODULES; do

        mdbg "Creating core table: $TABLE"

        sql_query $1 < $DB_SCHEMA/$TABLE-create.sql

        if [ $? -ne 0 ] ; then

                merr "Creating core tables failed!"

                exit 1

        fi

done

 

Kurt Mullen

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20101216/33087bd9/attachment.htm>