How to install MySQL 5.5 on Ubuntu

Posted by on Jul 25, 2011 in Computers, Open Dental | 17 comments

I have been beating my head against the wall for almost a year now, trying to figure out how to install MySQL 5.5 on Ubuntu since there is still not a .deb package to use. OpenDental software makes use of MySQL as it’s database and since my servers have always run Ubuntu, I didn’t really want to switch to an RPM based distro and have to learn new tricks for that system just for this reason. MySQL 5.1 was giving off and on errors and the time had come that I to either get it to work or ditch Ubuntu for and RPM based distro (probably OpenSuse/Fedora/Mandriva).

Finally, after trying it seems like twenty or thirty tutorials on the net and having problem at one point or another with all of them, I succeeded and got MySQL 5.5.14 running on Ubuntu 11.04 “lucid!”

If you follow the steps below from a standard Ubuntu/MySQL LAMP server install, you should be able to have a working v5.5 server in no time!

(help from this thread: https://code.launchpad.net/~clint-fewbar/ubuntu/natty/mysql-5.1/mysql-5.5-packaging)

64bit Machine w/ MySQL 5.5.14

sudo apt-get purge mysql-server
sudo apt-get purge mysql-client
sudo apt-get purge mysql-common
sudo apt-get autoremove
sudo apt-get autoclean


sudo rm -fr /var/lib/mysql


sudo wget -O MySQL-server-5.5.14-1.linux2.6.x86_64.rpm http://dev.mysql.com/get/Downloads/MySQL-5.5/MySQL-server-5.5.14-1.linux2.6.x86_64.rpm/from/http://mysql.mirrors.hoobly.com/


 


sudo wget -O MySQL-client-5.5.14-1.linux2.6.x86_64.rpm http://dev.mysql.com/get/Downloads/MySQL-5.5/MySQL-client-5.5.14-1.linux2.6.x86_64.rpm/from/http://mysql.mirrors.hoobly.com/


 


 sudo apt-get install alien 


sudo alien -i MySQL-server-5.5.14-1.linux2.6.x86_64.rpm --scripts


sudo alien -i MySQL-client-5.5.14-1.linux2.6.x86_64.rpm --scripts


 


sudo apt-get install libaio1 libaio-dev


sudo /usr/sbin/mysqld --skip-grant &


sudo /etc/init.d/mysql start




If you want to secure the installation and put a password on the root user:


/usr/bin/mysql_secure_installation

		Read More
	
 	
	

				
Install Virtual Box 4 on Ubuntu with PhpVirtualBox4

			
Posted  by  on May 27, 2011 in Computers, Open Dental | 4 comments

		
				
This is assuming Ubuntu 11.04 64 bit


Edit the source list


sudo nano /etc/apt/sources.list


Add the following line



deb http://download.virtualbox.org/virtualbox/debian natty contrib



Save and exit the file


Add gpg key


wget -q http://download.virtualbox.org/virtualbox/debian/oracle_vbox.asc -O- | sudo apt-key add -


sudo apt-get update


To make sure your kernel is updated properly with virtualbox:


sudo apt-get install dkms


wget http://download.virtualbox.org/virtualbox/4.0.8/virtualbox-4.0_4.0.8-71778~Ubuntu~natty_amd64.deb

sudo dpkg -i virtualbox-4.0_4.0.8-71778~Ubuntu~natty_amd64.deb


you will get dependency errors, so run the following to install the dependencies:


sudo apt-get -f install

		Read More
	
 	
	

				
Fix Out of Resource Problem with MySQL

			
Posted  by  on Mar 1, 2011 in Computers, Open Dental | 0 comments

		
				
Update:


This did not seem to work, and the only solution seems to be to upgrade to MySQL 5.5 11/27/2011


______________________________________________________________________


Possible errors you might be having:


mysqldump: Couldn't execute 'show fields from `tablename`': Out of resources when opening file './databasename/tablename#P#p125.MYD' (Errcode: 24) (23)


I started having problems with this when I upgraded to Ubuntu 10.10 with MySQL 5.1 installed. I am running a large database for the Open Dental Software in my office and was having the hardest time figuring out how to fix the problem. Finally I figured out it was not a MySQL problem, but a limit put on the number of files MySQL or my user could open by Ubuntu “security.”


View the problem


Here is how to test to see if this might be an issue:


sudo -u mysql bash


mysql@ubuntu:~$ ulimit -a



		Read More
	
 	
	

				
Install MySQL 5.5 on Ubuntu 10.10

			
Posted  by  on Feb 26, 2011 in Computers | 1 comment

		
				
UPDATED


I finally got it to work using “alien” and converting the .RPM to .deb. Then I installed it on Ubuntu 11.04 See how I did it HERE… 07/26/2011


________________________________________________________________________________________


Previously my tuorial did not seem to work completely, so I am trying again with a new source:


http://geek.co.il/wp/2011/03/02/mysql-5-5-on-ubuntu-10-10

		Read More
	
 	
	

				
Rsync and SSH – Passwordless Login

			
Posted  by  on Jan 25, 2011 in Computers | 2 comments

		
				
Making remote copies


What if you want to copy files offsite to a remote host? No problem — all you need to do is add the host and user information. So, for instance, if you want to copy the same directory to a remote host, you’d use:


rsync -ave ssh –delete /home/user/dir/ user@remote.host.com:dir/


If you want to know how fast the transfer is going, and how much remains to be copied, add the –progress option:

		Read More
	
 	
	

				
Install VirtualBox 3.2 with PHPVirtualBox on Ubuntu

			
Posted  by  on Dec 16, 2010 in Computers | 0 comments

		
				
original help from http://nerdoftherings.net/wp/?p=90


Using Ubuntu Server 10.10 (“Maverick Meerkat”)


1) Install the system (select options a. LAMP b.OpenSSH c.Samba)


2) Create a user named “vbox”  as your main user to follow this example


Type the following in a “putty” shell so you can copy and paste and you don’t have to type these out


sudo sh -c ‘echo deb http://download.virtualbox.org/virtualbox/debian maverick non-free >> /etc/apt/sources.list’

sudo apt-get update (you will get a key verification error, so then put the line below) 

wget -q http://download.virtualbox.org/virtualbox/debian/oracle_vbox.asc -O- | sudo apt-key add – 

sudo apt-get update 

sudo apt-get install virtualbox-3.2 (hit Y when asked if you want to download the 50mb)

		Read More
	
 	
	

				
Install Webmin on Ubuntu 10.10

			
Posted  by  on Dec 12, 2010 in Computers | 1 comment

		
				
sudo aptitude -y install perl libnet-ssleay-perl openssl libauthen-pam-perl libpam-runtime libio-pty-perl libmd5-perl apt-show-versions libapt-pkg-perl

sudo wget http://ftp.debian.org/pool/main/libm/libmd5-perl/libmd5-perl_2.03-1_all.deb

sudo dpkg -i libmd5-perl_2.03-1_all.deb

sudo wget http://downloads.sourceforge.net/project/webadmin/webmin/1.530/webmin_1.530_all.deb

sudo dpkg -i webmin_1.530_all.deb

		Read More
	
 	
	

				
Open Dental Plugin Renewed!

			
Posted  by  on Oct 3, 2010 in Computers, office, Open Dental | 0 comments

		
				
Version 7.3 of Open Dental is out in Beta testing now, so my plugin to enhance its already cool features is now functioning with Version 7.3.3 and later.


Check out version v1.1.1 of DrTech’s Plugin by reading more here or by downloading it here.

		Read More
	
 	
	

				
Open Dental Software Plugin – Payment plans & Referrals

			
Posted  by  on Apr 27, 2010 in Computers, Open Dental | 3 comments

		
				

$post_id = 2553;

$queried_post = get_post($post_id);

$content = $queried_post->post_content;

$content = apply_filters(‘the_content’, $content);

$content = str_replace(‘]]>’, ‘]]>’, $content);

echo $content;

?>

		Read More
	
 	
	

				
Video and Photos in one Gallery: WordPress , NextGen, jquery, and shadowbox

			
Posted  by  on Feb 12, 2010 in Computers | 48 comments

		
				
The Problem:


After searching far and wide for a gallery script that would allow me to show my photos and videos inline, one after another, in a simple to use shadowbox or similar viewer, I finally come up with a solution. The problem is most galleries are only set up to handle photos and not videos. Or if they do, they don’t show in the same sideshow or thumbnail view. WPG2 is the only one out there that does this halfway, but to see the videos, you have to actually leave the page you put the video thumbnail on and view the actually gallery2 page which is painfully slow and clunky.


This is the file to use to overlay video thumbnails 75x75 (thumbnails)
Or use this one (120x120 thumbnails)


The NextGen gallery plugin for WordPress seems to do a nice job with photos, but alas is still lacking video support. Along comes this post where I finally got started learning jquery: http://blog.creonfx.com/javascript/wordpress-video-galleries-with-nextgen-and-jquery Now with this code, the video thumbnails show on your posting of a gallery, but, the videos don’t show in sequence when you are thumbing through the photos in shadowbox. You must instead click individually on the thumbnail representing the video. But how do you know which one is the video? Another problem.


Now, for the solution.




Summary:


    

  • 1) Install NextGen Gallery and the Shadowbox js plugin on your wordpress site
    • 

  • 2) Place the javascript code below into the footer.php of your theme near the end but before the < /body?> tag
    • 

  • 3) Place the film.php and film.gif files into your “/wp-content/gallery/” folder
    • 

  • 4) Go to the “Effects” tab in the NextGen Gallery|Options, Set “JavaScript Thumbnail effect” to “Custom” and put code below in the box
    • 

  • 5) Change the settings in the Shadowbox js plugin to support *.flv files
    • 







 class="shadowbox" rel="shadowbox[%GALLERY_NAME%]" 








**Now Every Time you want to use the feature**


    

  • 1) Upload your photos, including an image for the thumbnail of your video, to a new NextGen Gallery (I use Picasa and it automatically creates a video thumbnail on export for you)
    • 

  • 2) Upload your video(s) to your normal WordPress gallery and copy the URL(s) (you may want to use an FTP program for this)
    • 

  • 3) Put the URL(s) for your video in the “alt” textfield of each video’s thumbnail when you edit the NextGen gallery
    • 

  • 4) Start your “descriptions” with the text “Video” when you edit your NextGen gallery on each thumbnail with a corresponding URL
    • 



 




 


Details:


I modified the above script from Peter Velichkov to modify the “rel” tag 

		Read More
	
 	
	

				
Getting network drives usable on Windows7

			
Posted  by  on Dec 26, 2009 in Computers | 0 comments

		
				
Windows 7 is great. But for some reason Microsoft disabled indexing for network drives. This is a real problem when you store all your documents on a central server or network drive. To work around this and put your network drive in your “libraries” follow the instructions below:


1. Create a folder on your hard drive for shares. i.e. c:\shares

2. Create another folder in the above share. i.e. c:\shares\documents

2. Link the Library to this folder.

3. Delete the folder.

4. Use the mklink in an elevated command prompt  (ie, run CMD with administrator privileges) to make a symbolic link between the local directory you linked earlier and the network share you are trying to link. Name the link the same as the folder you created above.

i.e – mklink /d c:\shares\documents \\server\mydocuments 

5. Done. Now you have non-indexed UNC path as a library.


Now you have the folder listed, but you can’t search it. For this, you need to install a patch released by Microsoft:


windows7 desktop search – UNCFATPHInstaller (will not work on 64bit according to Microsoft…but I haven’t tried it)


Then you should be able to go to Control Panel > Indexing Options > Advanced Button > UNC Tab and add the path for indexing.

		Read More
	
 	
	

				
Passwordless SSH Login for Backup on Linux computers

			
Posted  by  on Dec 2, 2009 in Computers | 0 comments

		
				
Because OpenSSH allows you to run commands on remote systems, showing you the results directly, as well as just logging in to systems it’s ideal for automating common tasks with shellscripts and cronjobs. One thing that you probably won’t want is to do though is store the remote system’s password in the script. Instead you’ll want to setup SSH so that you can login securely without having to give a password.


Thankfully this is very straightforward, with the use of public keys.


To enable the remote login 

		Read More
	
 	
	

				
Automatic SSH Login for Auto Backups

			
Posted  by  on Jul 4, 2009 in Computers | 0 comments

		
				
This if simple and a great asset if you are trying to do automatic backups with rsync or anything else where you need unattended backups or login. This is for Ubuntu Distributions of Linux: 


1) Generate RSA Key



ssh-keygen -t rsa



2) Copy the key to the computer you wish to login to automatically without a password:




sudo scp ~/.ssh/id_rsa.pub USERNAME@IP:~/.ssh/authorized_keys

(replace your username and IP address with your correct info)




That’s it! Now you should be able to use SSH and not have to enter a password to login.

		Read More