configure -enable-start-stop-daemon -prefix=/usr/local/kannel -with-mysql To store DLR in MySQL we have to compile Kannel with MySQL support # wget -no-check-certificate ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci Install Kannel with MySQL support `datetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, Two other tables send_sms and sent_sms will be automatically created by Kannel sqlbox process on first run CREATE TABLE `dlr` ( MariaDB > GRANT ALL PRIVILEGES ON kannel.* TO > FLUSH PRIVILEGES Ĭreate dlr table for Kannel DLR. MariaDB > CREATE USER IDENTIFIED BY 'kannelPassword' MariaDB > CREATE DATABASE kannel CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci Remove test database and access to it? YĬreate MariaDB database and user for Kannel. Run mysql_secure_installation to set root password and other security directives as below Set root password? Y # apt-get install –y mariadb-server libmariadb-dev default-libmysqlclient-devĮnable and Start MariaDB service # systemctl enable rvice Update repo and install MariaDB including necessary dependencies # apt-get update Put MariaDB repo info in the file /etc/apt//MariaDB.list # MariaDB 10.3 repository list - created 18:41 UTCĭeb buster main
0 Comments
Leave a Reply. |