当前位置：首页 > news >正文

手工创建 kamailio database tables

news 2025/8/9 18:56:31

有些场景可能`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