Ozeki NG MySQL Connectivity Parameters Rumi, July 5, 2012July 5, 2012 Databse connection =========================== Driver={mySQL ODBC 5.1 Driver};Server=192.168.0.100;Port=3306;Option=4;Database=mydb;Uid=userdb;Pwd=putmypwd; Sending-Polling ============ SELECT id,sender,receiver,msg,msgtype,operator FROM ozekimessageout WHERE status=’send’ Sending-sending ============= UPDATE ozekimessageout SET status=’sending’ WHERE id=’$id’ Sending-Sent ============== UPDATE ozekimessageout SET status=’sent’, senttime=’$senttime’ WHERE id=’$id’ Sending-Not sent =========== UPDATE ozekimessageout SET status=’notsent’ WHERE id=’$id’ SQL for receiving ============== INSERT INTO ozekimessagein (sender, receiver, msg, senttime, receivedtime, msgtype, operator) VALUES (‘$originator’,’$recipient’,’$messagedata’,’$senttime’,’$receivedtime’,’$messagetype’,’$operatornames’) Related Administrations Configurations (Windows) Ozeki
Set Up Apache Virtual Hosts on Debian 7 July 29, 2019 Step One— Create a New Directory First, it is necessary to create a directory where we will keep the new website’s information. This location will be your Document Root in the Apache virtual configuration file. By adding a -p to the line of code, the command automatically generates all the… Read More
Install Varnish on CentOS/RedHat/SL 5 or 6 December 5, 2012December 5, 2012 Varnish Cache is a web application accelerator also known as a caching HTTP reverse proxy. It is installed in front of the web application and it speeds up the web application significantly. Since varnish is not available in CentOS repo, you have to add the EPEL repo. However Varnish suggests… Read More
Configure Additional IP Addresses January 18, 2009 Let’s assume our network interface is eth0. Then there is a file /etc/sysconfig/network-scripts/ifcfg-eth0 which contains the settings for eth0. We can use this as a sample for our new virtual network interface eth0:0: cp /etc/sysconfig/network-scripts/ifcfg-eth0 /etc/sysconfig/network-scripts/ifcfg-eth0:0 Now we want to use the IP address 192.168.0.101 on the virtual interface eth0:0…. Read More