手工创建 kamailio database tables

ops/2024/10/21 11:29:32/

有些场景可能需要手工创建 kamailio database table,可参考下面的命令序列:

use mysql

select user,host from user;

drop user 'kamailio'@'%';
flush privileges;

drop database kamailio;

create database kamailio;
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
 


http://www.ppmy.cn/ops/39946.html

相关文章

iphone进入恢复模式怎么退出?分享2种退出办法!

iPhone手机莫名其妙的进入到了恢复模式&#xff0c;或者是某些原因需要手机进入恢复模式&#xff0c;但是之后我们不知道如何退出恢复模式怎么办&#xff1f; 通常iPhone进入恢复模式的常见原因主要是软件问题、系统升级失败、误操作问题等导致。那iphone进入恢复模式怎么退出&…

-i https://pypi.tuna.tsinghua.edu.cn/simple

-i https://pypi.tuna.tsinghua.edu.cn/simple

无障碍Web开发:遵循WCAG标准构建包容性用户体验

无障碍Web开发旨在确保所有用户&#xff0c;无论其身体条件或能力如何&#xff0c;都能轻松、有效地访问和使用Web内容。遵循Web Content Accessibility Guidelines (WCAG) 标准是实现这一目标的关键。以下是一些基于WCAG标准的无障碍Web开发实践&#xff0c;以构建更具包容性的…

证券基金信创联盟研讨会:YashanDB分享金融核心数据库技术实践

4月26日&#xff0c;由证券基金行业信息技术应用创新联盟主办、WG3稽核风控系统工作组承办、国信证券股份有限公司协办的信创联盟2024年度系列研讨会第三期-稽核风控系统信创实践成功举办。国内头部企业国信证券、申万宏源证券、信达证券、国金证券、广发证券等单位共计300余人…

【Python】io_backend参数简介

在许多编程框架和库中&#xff0c;尤其是涉及到数据处理和深度学习的应用程序中&#xff0c;io_backend 参数常用于配置输入/输出&#xff08;I/O&#xff09;操作的后端类型和其他相关设置。这个参数通常通过字典&#xff08;dict&#xff09;的形式提供&#xff0c;使得可以灵…

K8S性能优化(一)-集群调优

1 sysctl参数 1.1 参数调优实践 # Kubernetes Settings vm.max_map_count 262144 kernel.softlockup_panic 1 kernel.softlockup_all_cpu_backtrace 1 net.ipv4.ip_local_reserved_ports 30000-32767# Increase the number of connections net.core.somaxconn 32768# Ma…

大屏分辨率适配插件v-scale-screen

前言&#xff1a;大屏分辨率适配繁多&#xff0c;目前我认为最简单且问题最少的的方案就是使用v-scale-screen插件&#xff0c;无需考虑单位转换&#xff0c;position定位也正常使用。 1. 效果 填充满屏幕的效果 保持宽高比的效果 2. 插件原理 原理是通过css transfom 实现…

Gateway基础配置指南

Gateway基础配置指南 一、引言 随着微服务架构的普及&#xff0c;API网关&#xff08;Gateway&#xff09;作为微服务架构中的关键组件&#xff0c;其重要性日益凸显。Gateway作为系统的唯一入口&#xff0c;负责处理所有客户端的请求&#xff0c;并根据业务规则将请求转发到…