有些场景可能`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 () ,一查便知。