phpmyadmin access problem and change server from URL

2012-09-30 1 min read Database Fedora
I was having issues with one of the phpmyadmin setups. The first server defined in the config file was not accessible and the theme that I was using was not allowing me to change the server from the first page. This resulted in a state where I was not able to access phpmyadmin in any way. I could not connect to any of the servers. And thus had to hack my way in to phpmyadmin to find out how to connect to other servers from URL. Continue reading

find duplicate entry in a list in bash with sed

2010-06-25 1 min read bash Fedora Learning
Here I will take an example of rss2email list, but I guess I will be able to pass on the concept. Here is example of the output of the r2e list command: 1: http://blog.amit-agarwal.co.in/feed (default: amitag@localhost) 2: http://feeds2.feedburner.com/AllAboutLinux (default: amitag@localhost) 3: http://feeds2.feedburner.com/Command-line-fu (default: amitag@localhost) 4: http://blogs.members.freewebs.com/Members/Blogs/viewBlogRSS.jsp?userid=29731143 (default: amitag@localhost) Target here is to get the list of all duplicate entries if any. So, first we need to remove the numbers from the begining and the email ID from the end. Continue reading

Change phpMyadmin theme.

2009-12-08 1 min read Linux
Changing the phpMyAdmin theme is as easy as downloading a theme from <a href="http://www.phpmyadmin.net/home_page/themes.php" target="_blank">here. Then look at your /etc/httpd/conf.d/phpMyAdmin.conf file and check the line similar to Alias /phpMyAdmin /phpMyAdmin The second path is the path to your phpMyAdmin installation. Go to that directory and then go to themes directory and unzip the file. Reload your phpMyAdmin page in browser and select the newly installed theme 🙂