Episode 57 - Home Servers Part 3: PHP and MySQL

[Chess]

In this episode: Debian Etch is released; a discussion of the "MP" in "LAMP": PHP and MySQL; audio Listener Tip; audio and email feedback.

Additional notes can be downloaded here.

http://www.linuxreality.com/podcast/episode-57-home-servers-part-3-php-and-mysql/

[jza]

Excelent show, we were just discussing about the average PHP programmer and what makes a true programmer.

PHP is pretty big, PHP classes, PEAR and PECL, also hordes and hordes of classes at PHPClasses.net.

PHP has a ini file that makes the only php with a 'configuration file'. I like the way PHP is pulling it together and I think that PHP is really the language of the web. As opposed of what many people might say about Ruby on Rails, Coldfusion and JSP for the enterprise.

PHP is really the across the board language. From the original 'personal home page' to managing wikipedia and mozilla.org

MySQL on the other hand as been a very controvertial database because of their dual license method.Up until now, mysql is not a deafault native functionality on PHP, Oracle has also have it's share of news head on the direction of mysql vs the corportate database. Since Oracle bought inodb, and the emerge of falcon as the new database engine.

Many database users are like the version of people that think that Linux is like DOS. MySQL 5 has stored procedures, hot and cold sync as well as many other features that most database managers have been ignoring for the longest.

As a tip, here is a howto on how to tunnel MySQL so you can get a GUI mysql app from a remote MySQL server through SSH.

http://highspeedrails.com/Support/Howto/sshTunnelHowto

[jza]

on mysql I usually run the script mysql_secure_installation that sums up the steps on creating users, plugging passwords, getting rid of sample databases etc.

Other useful mysql command is mysqldump so we can import or export database such as:

Code:

mysqldump -u<user> -p  <database> >> file.sql
mysqldump -u<user> -p  <database> < file.sql

The other is the mysqladmin command this allow you to plug commands without having to enter into the mysql prompt. This is a great way to implement in bash scripts.

About the Java servers --- I dont really like Java servers, there are many of them including Tomcat, Jonas, JBoss, Endhyra, etc.

[Pat from TLLTS]

Java application servers that run on Linux:
Sun Java Application Server: http://www.sun.com/software/products/appsrvr/index.xml
JBoss: http://labs.jboss.com/portal/
IBM Websphere: http://www-306.ibm.com/software/webservers/appserv/community/
Borland AppServer: http://www.borland.com/us/products/appserver/index.html
Apache Tomcat (for web based java apps): http://tomcat.apache.org/

Some of these are commercial and cost $$

[rmjb]

Anyone getting partial audio? I tried both the ogg and the mp3 (*shudder*) but I only get about 10mins of audio either way 

- rmjb

[kleptos]

Anyone getting partial audio? I tried both the ogg and the mp3 (*shudder*) but I only get about 10mins of audio either way 

- rmjb

I got mine from iTunes and didnt have any problems.

[Zankul]

Great show again Chess. I use juice and I had the complete download.

[dovad]

I'm very interested in the small computers that Chess mentioned in the 3rd server podcast.  I can't figure out the spelling of the mentioned boxes i.e. "socris" (spelling?).  Any help would be appreciated.

[jza]

I'm very interested in the small computers that Chess mentioned in the 3rd server podcast.  I can't figure out the spelling of the mentioned boxes i.e. "socris" (spelling?).  Any help would be appreciated.

Their name are soekris, I mention here the Norhtec PC which is also very small. There are others such as mini-ITX.

http://www.soekris.com/


http://www.norhtec.com

[rmjb]

I still can't get the entire episode. I'm downloading from home this time instead of work (same ISP though) and I still get only 10 mins.

Anyone has another link I can try?

- rmjb

[sewmyheadon]

Chess, you mentioned maybe walking through the install of an application in your next podcast as a wrap-up to the home server topic,

Wordpress might be a good choice.  As you know, it's a super easy install after you've created your MySQL database and user.