有些場景可能`kamdbctl create`不好使,可能需要手工創建 kamailio database tables,可參考下面的命令序列:
USE mysql
# 刪除之前創建的用戶
SELECT user,host FROM user;
DROP USER 'kamailio'@'%';
FLUSH PRIVILEGES;# 刪除之前創建的數據庫
DROP DATABASE kamailio;# 創建數據庫,創建用戶等
# mysql8
CREATE DATABASE kamailio CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;?
CREATE USER 'kamailio'@'%' IDENTIFIED BY 'PASSWORD';GRANT ALL ON kamailio.* TO 'kamailio'@'%';
mysql -h127.0.0.1 -uroot -p'password' kamailio < ?/usr/share/kamailio/mysql/standard-create.sql
mysql -h127.0.0.1 -uroot -p'password' kamailio < ?/usr/share/kamailio/mysql/acc-create.sql
mysql -h127.0.0.1 -uroot -p'password' kamailio < ?/usr/share/kamailio/mysql/alias_db-create.sql
mysql -h127.0.0.1 -uroot -p'password' kamailio < ?/usr/share/kamailio/mysql/auth_db-create.sql
mysql -h127.0.0.1 -uroot -p'password' kamailio < ?/usr/share/kamailio/mysql/avpops-create.sql
mysql -h127.0.0.1 -uroot -p'password' kamailio < ?/usr/share/kamailio/mysql/carrierroute-create.sql
mysql -h127.0.0.1 -uroot -p'password' kamailio < ?/usr/share/kamailio/mysql/cpl-create.sql
mysql -h127.0.0.1 -uroot -p'password' kamailio < ?/usr/share/kamailio/mysql/dialog-create.sql
mysql -h127.0.0.1 -uroot -p'password' kamailio < ?/usr/share/kamailio/mysql/dialplan-create.sql
mysql -h127.0.0.1 -uroot -p'password' kamailio < ?/usr/share/kamailio/mysql/dispatcher-create.sql
mysql -h127.0.0.1 -uroot -p'password' kamailio < ?/usr/share/kamailio/mysql/domain-create.sql
mysql -h127.0.0.1 -uroot -p'password' kamailio < ?/usr/share/kamailio/mysql/domainpolicy-create.sql
mysql -h127.0.0.1 -uroot -p'password' kamailio < ?/usr/share/kamailio/mysql/drouting-create.sql
mysql -h127.0.0.1 -uroot -p'password' kamailio < ?/usr/share/kamailio/mysql/group-create.sql
mysql -h127.0.0.1 -uroot -p'password' kamailio < ?/usr/share/kamailio/mysql/htable-create.sql
mysql -h127.0.0.1 -uroot -p'password' kamailio < ?/usr/share/kamailio/mysql/lcr-create.sql
mysql -h127.0.0.1 -uroot -p'password' kamailio < ?/usr/share/kamailio/mysql/matrix-create.sql
mysql -h127.0.0.1 -uroot -p'password' kamailio < ?/usr/share/kamailio/mysql/mohqueue-create.sql
mysql -h127.0.0.1 -uroot -p'password' kamailio < ?/usr/share/kamailio/mysql/msilo-create.sql
mysql -h127.0.0.1 -uroot -p'password' kamailio < ?/usr/share/kamailio/mysql/mtree-create.sql
mysql -h127.0.0.1 -uroot -p'password' kamailio < ?/usr/share/kamailio/mysql/pdt-create.sql
mysql -h127.0.0.1 -uroot -p'password' kamailio < ?/usr/share/kamailio/mysql/permissions-create.sql
mysql -h127.0.0.1 -uroot -p'password' kamailio < ?/usr/share/kamailio/mysql/pipelimit-create.sql
mysql -h127.0.0.1 -uroot -p'password' kamailio < ?/usr/share/kamailio/mysql/presence-create.sql
mysql -h127.0.0.1 -uroot -p'password' kamailio < ?/usr/share/kamailio/mysql/purple-create.sql
mysql -h127.0.0.1 -uroot -p'password' kamailio < ?/usr/share/kamailio/mysql/registrar-create.sql
mysql -h127.0.0.1 -uroot -p'password' kamailio < ?/usr/share/kamailio/mysql/rls-create.sql
mysql -h127.0.0.1 -uroot -p'password' kamailio < ?/usr/share/kamailio/mysql/rtpengine-create.sql
mysql -h127.0.0.1 -uroot -p'password' kamailio < ?/usr/share/kamailio/mysql/rtpproxy-create.sql
mysql -h127.0.0.1 -uroot -p'password' kamailio < ?/usr/share/kamailio/mysql/sca-create.sql
mysql -h127.0.0.1 -uroot -p'password' kamailio < ?/usr/share/kamailio/mysql/secfilter-create.sql
mysql -h127.0.0.1 -uroot -p'password' kamailio < ?/usr/share/kamailio/mysql/siptrace-create.sql
mysql -h127.0.0.1 -uroot -p'password' kamailio < ?/usr/share/kamailio/mysql/speeddial-create.sql
mysql -h127.0.0.1 -uroot -p'password' kamailio < ?/usr/share/kamailio/mysql/topos-create.sql
mysql -h127.0.0.1 -uroot -p'password' kamailio < ?/usr/share/kamailio/mysql/uac-create.sql
mysql -h127.0.0.1 -uroot -p'password' kamailio < ?/usr/share/kamailio/mysql/uid_auth_db-create.sql
mysql -h127.0.0.1 -uroot -p'password' kamailio < ?/usr/share/kamailio/mysql/uid_avp_db-create.sql
mysql -h127.0.0.1 -uroot -p'password' kamailio < ?/usr/share/kamailio/mysql/uid_domain-create.sql
mysql -h127.0.0.1 -uroot -p'password' kamailio < ?/usr/share/kamailio/mysql/uid_gflags-create.sql
mysql -h127.0.0.1 -uroot -p'password' kamailio < ?/usr/share/kamailio/mysql/uid_uri_db-create.sql
mysql -h127.0.0.1 -uroot -p'password' kamailio < ?/usr/share/kamailio/mysql/uri_db-create.sql
mysql -h127.0.0.1 -uroot -p'password' kamailio < ?/usr/share/kamailio/mysql/userblocklist-create.sql
mysql -h127.0.0.1 -uroot -p'password' kamailio < ?/usr/share/kamailio/mysql/usrloc-create.sql
有個腳本叫 kamdbctl.mysql,`kamdbctl create` 調用的就是它。入口是?kamailio_create () ,一查便知。