This article gives a step by step set of instructions to set up Eclipse to run a Jetty application container using Jersey RESTful annotations and talk to a MySQL database. You would have thought that with all these technologies being really popular ther… more »
Category: "MySQL"
CentOS 5.5 is dependant on Python 2.4. Everything will break if you change it, so we must install a newer version of Python in a different place.
Surprisingly my 1&1 CentOS didn't come with gcc installed so I had to install it myself.
yum -y i… more »
1&1's documentation is pretty awful but to be fair they only expect real system administrators to be using their dedicated servers. They give you a copy of Plesk 10 but it doesn't have any capabilities to alter the disk or volume group layouts. 1&1 layout their default image in a way that only gives you 4GB on each of the major partitions and it leaves the other 212GB as unallocated. So in order to use the server properly you have to get interested in the Logical Volume Manager. more »
Ever come across the situation where you need to search for sets of values in a (MySQL) database? SQL along the lines of: SELECT col1, col2 FROM table1 WHERE (col3 = 5 and col4 = 6) or (col3 = 10 and col4 = 12) or (col3 = 15 and col4 = 3) more »
Creating a MySQL user that can only access a particular database instance, is a bit tricky to do from the MySql command line. Fortunately, the people at Plesk have added it into the appliance administration software.
Previous incantations of the Plesk… more »