I’ve recently moved a project to a live VM instance, it worked perfectly during development and testing on my macOS box using XAMPP. Essentially the web app has 3 export options: XML, PDF and CSV. XML works fine and is created using a SELECT statement then looping through the results and pushing that in…
Tag: mysql
Stream data for users
I want to build a server that could stream data from multiple endpoints simultaneously for analytics purposes. Scenario: users registered on our platform will provide credentials of their IoT device. E.g https://stream.example.com/user1 & https://stream.example.com/user2 Our responsibility is to monitor t…
Poco C++ Libraries: “Not found: mysql”
I am using poco-1.7.7 with MySQL. I am building with g++ on Ubuntu. Building, linking and running works fine. However, when a Data Session is created, an exception “Not found: mysql” is thrown: The mysql client is installed and is part of $PATH. Additional information: I am running Ubuntu using Do…
apply configured wordpress theme / plugins to multiple websites
I am wondering if there is an ability to apply my configured custom wordpress cms theme that I customized, and configured (including use of several plugins) and apply this completed configured theme to multiple domains or websites through a shared hosting – without going in one by one installing and re-…
MySQL ODBC – How to connect Access 2016 to remote server via SSH
I have a Linux-based web server running with the LAMP package. For security reasons, the sever only allows logins via SSH and denies regular password login attempts. I want to use the MySQL ODBC driver within Microsoft Access 2016 to connect to this server for data analysis purposes, but I do not see an optio…
Can not connect to MySQL with Eclipse java IDE on linux ubuntu, but with a code that worked perfectly on windows
I was working on a small project (mostly for fun) on java with Eclipse Neon (and window builder), in which I had to connect to MySQL and retrieve certain info. In windows it worked great, I was able to connect, get the info, etc. But then I switched to Linux Ubuntu 16.04 and it just won’t connect to MyS…
mcafee mysql audit plugin version vs mysql version
Actually I was searching a opensource tool/plugin/command by which I can get some logs suppose who executed a truncate command at which time from which IP etc. but not getting such type a feature in open source (don’t want to enable general log as wants specific/limited logs). Fortunately I got informat…
Convert UTC to MDT via MySQL
I’m having trouble changing my queries to use the my current MDT timezone. The server and MySQL are UTC When I try to run CONVERT_TZ() to US/Mountain, my time is way off. Returns 2016-08-08 18:00:00 Not sure what I’m doing wrong here. Answer Instead of curdate, you should use now like you did in y…
How to make MySQL colum name case insensitive in Cent OS?
I am using Cent OS 6.5 and MySQL 5.1.73 and I know database name and table name and also column names are case sensitive in Cent os Now, I want to make MySQL work as case insensitive in Cent OS. I have tried the below link its worked for the table name. But i need to case sensitive for the
Correct way to set a crontab to stop and start mysql and httpd
i’m trying to create a shell script to stop and start mysql and httpd every saturday on 3am, i’m doing it: myscript.sh: and setting the crontab to: It’s correct way to do it? i’m stopping and starting mysql and httpd cuz use of memory, should i do some check before stop them? or i can …