This is an ADD-ON of asterisk, is not installed by default and must be downloaded and installed with the asterisk-addons package. However, in Asterisk 1.8 the addons have been integrated back into Asterisk. MYSQL(): Basic MYSQL Database Functionality (note that the help information returned from ‘show application MYSQL’ is a little misleading – what’s shown … Read more
Terminology/Files Driver – A compiled module containing database specific code that accepts the generalized function calls that RealTime makes. As of this writing, only ODBC, MySQL (via asterisk-addons) and LDAP (see http://free.oxymium.net/Asterisk/ and http://bugs.digium.com/view.php?id=5768) drivers are available. Family – A name associated with a RealTime call. Examples: sippeers, sipusers, voicemail. extconfig.conf – The configuration file … Read more
To remove and add access to phpmyadmin in asterisk : Add your IP as follow: vi /etc/httpd/conf.d/phpmyadmin.conf <Directory “/usr/share/phpmyadmin”> Order allow,deny Allow from all </Directory> Here in Allow from all and Allow from 192.168.0.10 Then issue the following command: # service httpd restart Now All done.
CREATE TABLE product ( category INT NOT NULL, id INT NOT NULL, price DECIMAL, PRIMARY KEY(category, id) ) ENGINE=INNODB; CREATE TABLE customer ( id INT NOT NULL, PRIMARY KEY (id) ) ENGINE=INNODB; CREATE TABLE product_order ( no INT NOT NULL AUTO_INCREMENT, product_category INT NOT NULL, product_id INT NOT NULL, customer_id INT NOT NULL, PRIMARY KEY(no), … Read more
CREATE TABLE example_autoincrement ( id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, data VARCHAR(100) ); CREATE TABLE example_innodb ( id INT, data VARCHAR(100) ) TYPE=innodb;