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@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