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
Obtaining pfsense 2.2.4 as ISO October 17, 2015 PFSense is a very strong firewall as my alternative for Endian (BSD Vs. Redhat-Linux) Here’s the direct download link- http://files.nl.pfsense.org/mirror/downloads/pfSense-LiveCD-2.2.4-RELEASE-amd64.iso.gz How to extract? gzip -d pfSense-LiveCD-2.2.4-RELEASE-amd64.iso.gz Voila! your unzipped ISO is now available. 🙂 Related Read More
Large Database Import Progress Using PV March 24, 2020 PV can report progress for large data imports. In this example I will use a large (7 G) install on Ubuntu. First, download PV (http://linux.die.net/man/1/pv) sudo apt-get install pv A traditional mysql import may be formatted as: mysql -u USER -p DATABASE_NAME < DUMP.mysql but to leverage PV, pass the dump file ,then pipe the… Read More
Updating Webmin Logo January 21, 2021January 21, 2021 On a default installation, your Webmin login page looks like below: To suppress both the Webmin logo and the “Webmin” text from the login page, add below to Webmin > Webmin Configuration > Webmin Themes > Theme Extensions: Related Read More