Archive for category Applications

Reset a WordPress password

Posted by Randy in Applications, Internet, technology, Web Development on January 24, 2012

I'll make this post short and sweet. Let's say you've forgotten your login for a WordPress site. To reset the password to something new, you can simply use a SQL query. If you have access to PHPMyadmin or the MySQL command line, this is really straight forward.

From PHPMyAdmin, open the database for the WordPress installation. If you don't know which database to use, check out your wp-config.php file inside your main WordPress installation folder. You'll find constants defined in that file for your database name and database user. Once you've found the database, you can execute a SQL statement by clicking the SQL button. In there, type:

 
UPDATE wp_user SET user_pass = MD5("yourpassword") WHERE user_login = "admin";

That's assuming that your username is "admin". Change it to whatever username you are using. Once you run that SQL statement, your password will be set to whatever you put in "yourpassword". Both the username and password need to be quoted in the SQL statement.

To do the same thing in the MySQL command line, connect to the database with:

mysql -u<username> -p

Substitute <username> with your actual username from the wp-config.php file.
You will be prompted for a password. Use the password from the wp-config.php file.
Once you are logged into the mysql command problem type:

USE &lt;databaseName&gt;

Substitute the actual database name from the wp-config.php file.
Finally, type the update statement above and hit enter.

After you've updated the table via SQL, you should be able to login to your WordPress installation.

, ,

No Comments

Netbean’s Menus Don’t work in Linux Mint 12

Posted by Randy in Linux Stuff, Open Source, Programming on January 11, 2012

Gnome3 has some issues. I really like the look and feel of Linux Mint's Gnome3 + Mate interface. However, looks aren't everything. Functionality is important as well. Almost everything works with it but Netbeans is an exception. The menus are completely unusable with it.

The quick solution is to select "Gnome Classic" when you login. I like the look of it as well, and at least everything works in it.

While I'm on the subject, why did Gnome decide to take the path it did with version 3. It's too much like Unity, and I hate Unity. Why are they moving to this type of desktop? Gnome 2 may not be the prettiest thing available, but it has been the most usable desktop environment for years. They should have just concentrated on improving the look of it, added a few new features, and worked on any bugs they had laying around. Most people don't like Unity or Gnome 3. This doesn't leave much of a choice other than KDE and XFCE4. Of those, I'd pick XFCE4, but if you have a large userbase like Gnome has, why screw that up by making your new version look like and act like the DE most people are wanting to avoid? I just don't get it.

»crosslinked«

, ,

No Comments

Windows 7 Freezes Randomly

Posted by Randy in Applications, Windows on December 28, 2011

I recently reinstalled Windows 7 on my main box because I wanted to do some good screencasts for my PHP Video Tutorials site. After installing a few updates for Windows 7, I started getting a strange issue with audio and video. The OS would glitch. I would get short pauses in video and distortion in the audio.

After killing some processes and services, I soon found out that the problem was with Windows Superfetch. The issue has to do with my SSD drive. So if you have an issue like this and you have a solid state drive, you should try disabling superfetch. After stopping the service, give it a few moments. Play videos and see if you still get the problem.

If you want me to write up a howto on disabling superfetch, leave a comment. If there is any interest, I'll write it up.

, , ,

No Comments

Couldn’t Load XPCOM

Posted by Randy in Applications, Linux Stuff, Open Source, Operating Systems, technology on November 4, 2011

If you are like me, you like to use the latest plugins for Firefox (when you use Firefox). Things like Firebug have become a staple for my web browser usage. I also love using Debian as my OS, and the stable version comes with a much older version of Firefox (sans logos and with the name iceweasel). Unless you download older version of plugins, most of the time you'll have trouble installing the plugins you want.

The simple solution is to download and install the latest version of Firefox directly from Mozilla. There's not much of an install process. Just download and uncompress the file. You'll get a firefox directory, which I moved over to my home directory and proceeded to create shortcuts for on my desktop and menus.

If you are using the 64 bit version of the OS, you will quickly run into the "Couldn't Load XPCOM" error. It's obvious that it is a library issue but the error doesn't give you a big clue as to how to fix it.

Good news, the fix is extremely easy. You are lacking some 32 bit libs that are required to run the program.
Fix is by running the following as root or with sudo:

apt-get install ia32-libs-gtk

After that, you should be able to run Firefox. Enjoy!

No Comments

The Best PHP Framework?

Posted by Randy in Applications, Internet, Programming, Web Development on November 3, 2010

I've been really interested in using a PHP framework. One thing holding me back is deciding which one to work with. It seems that every time I start looking at frameworks, I end up deciding to just code everything manually. The major contenders seem to be Yii, Zend, Symfony, CakePHP, and CodeIgnitor. However, I have no idea which one I'm going to use. It's hard to decide without learning the ins and outs of each one and making a good decision based on that knowledge.

My latest attempt was with the Zend framework. I was getting into it and realized that most of the documentation for setting it up bases the setup from a virtual host in Apache. This would be fine, but it actually makes development and deployment overly complicated for me. My development environment is a Linux machine that is my main desktop. My production server is my own dedicated server with CPanel. Zend doesn't work very well with this setup from what I can tell.

I want my site to transfer easily between the two environments. I like them to be self-contained as well. I want to throw the framework into a lib folder or link to it in some way. I don't like that the forward-facing web site is in the "public" folder. I want the root of the website to be the forward-facing public website.

I would really like to use Zend because it has a lot of good extensions for utilizing various web services.

I'd like to hear from others. Which framework would you recommend and why?

, , , , ,

No Comments

Reddit’s Interview with Richard Stallman

Posted by Randy in Applications, Linux Stuff, Open Source, Operating Systems, Programming on July 30, 2010

Recently, Reddit users were given the opportunity to ask RMS (Richard M. Stallman) questions. The top 25 were answered by RMS here.

For anyone who doesn't know who RMS is, he is the founder of the GNU project. He wrote Emacs and the GCC compiler. Much of what makes up a "GNU/Linux" (don't ever let him hear you call it "Linux"), is the GNU tools. Linux itself is just the operating system kernel. Although the OS kernel is a very important part of the OS, a base GNU/Linux system has a ton of software from the GNU project as well. The OS doesn't work without the kernel, and it doesn't do much without the GNU tools.

RMS answered most of the questions as I would expect. The one question that stood out to me, although I haven't made it through the entire list yet, is number 7. The question relates to how the open source world can't create tax software and games that can compete with proprietary software. It's a very good question. RMS mentions that the Free Software Foundation in Latin America does have free tax software. He also says

I don't know whether our community will make a "high end video game"
which is free software, but I am sure that if you try, you can stretch
your taste for games so that you will enjoy the free games that we
have developed.

Now, this is the part that really made me think. I've always been an advocate of free software, but do I really want to rely on free software to produce video games that compete with some of the games I play on PS3? I truly wish that they could make them, because I'd love it, but I don't see it happening. Another major point to that comment is that games have always been the driving force in computer hardware improvements. The computer systems we have right now are only this good because of games.

That may be hard to believe, but for anyone that's been playing PC games for decades, it's common sense. Video games are it. That's what all of this technology was built on. You were either playing games or writing them. Sure, computers have many other useful features, but games are responsible for these beautiful user interfaces and awesome sound.

Games kept getting better. Hardware kept getting better. A huge majority of the research and design came from game sales. All of that wouldn't have happened without proprietary games.

RMS knows that, but RMS isn't worried about games at all. RMS is worried about software freedom and he has many good points. Those same points could be applied to many industries. To me is seems like the old communism vs. capitalism debate. Extremes on both sides suck. It's the happy medium we should strive for.

, , ,

No Comments

LXDE – The Light-weight Linux Desktop Environment

Posted by Randy in Linux Stuff, Open Source, Operating Systems, technology on July 21, 2010

I was reading a post over at the Linux Mint Blog and found that I'm a bit behind on my Linux news. I've never heard of LXDE. Now my desktop environment of choice is Gnome, usually. I also like XFCE, but Gnome has all the features and rarely lets me down. I like the variety in Linux so I was glad to see yet another desktop environment.

LXDE seems to be geared toward netbooks and other cloud-client computers. Linux has many light-weight desktop environments, and even though I like variety, sometimes I wish that they would all come together and work together.

This leads me to a pitfall of open source. It's also an advantage. Those are complete contradictions, but there's really no other way to explain it. I lean more toward the advantage side of things but sometimes I wonder if the different projects could be merged as much as they are split.

It seems that it's perfectly logical for developers to split from a project and create a fork, but rarely do two projects merge to form a super project. Perhaps open source in general needs more merging to balance out the massive amounts of forks....just a thought.

No Comments

Eclipse issues in Linux Mint

Posted by Randy in Applications, Linux Stuff, Open Source, Operating Systems, Programming, Web Development on January 10, 2010

I've been wrestling with IDEs and OSs for the past few days, trying to decide which would be best for Javascript and PHP development. I had been using Netbeans. I absolutely love Netbeans, but I found that editing Javascript in it was somewhat lacking. I was having trouble keeping up with my nested anonymous functions and thought it'd be a good time to try out other alternatives.

I bounced around between Linux Mint, Mac OS X, and Windows 7. I find that I would really like to program on my Macbook Pro, but it just doesn't feel comfortable. There's something about the keyboard setup or something that just annoys me. It's more of a problem with my familiarity with the keyboard, I think. At any rate, after messing with Eclipse, Netbeans, and Textmate on my Mac, I decided it was going to be a no-go.

Windows 7 presented a problem in the fact that XAMPP seems to have issues with sessions. They work but almost at random, creating a new session will lock up the entire web server. When you are developing a website which uses Sessions for user logins, that creates a problem. So, I decided it would be in my best interest to use Linux, which seems to be made for programmers, because most programming related things work great in it and the fact that you almost have to be a programmer to get some things to work correctly in it. Though, that is an outdated misconception, but everyone still seems to believe it.

I had been using Linux for most of the development of my new project anyway. So, there was no transition there. I'm using SVN on a server machine so it really didn't matter which OS or IDE I decided upon for that. They are all pretty universal in their ability to handle SVN. The major exception was Mac OS X which didn't include the ssh-askpass command needed to tunnel SVN through ssh correctly. I was able to find a shell script that handled the ssh-askpass function, however. Textmate didn't really work well, either, because it didn't really have robust SVN integration. It was pretty much just like manual SVN. I also needed separate programs for Diff and Merge. That was lacking and clunky. I was spoiled by Netbeans' built-in Merge, Diff, SVN, and so forth.

I thought I'd give Aptana a try. It is a PHP developer plugin for Eclipse. It is also available in a standalone package. I had various problems with the standalone version of Aptana so I decided to install Eclipse from the LinuxMint/Ubuntu repositories. Eclipse worked great, and Aptana installed perfectly. However, I needed the SVN tools that are Aptana add-ons. They wouldn't install. There was a version conflict with the version of Eclipse in the LinuxMint/Ubuntu repositories.

So I decided to install the latest version of Eclipse. I downloaded and ran the latest version and found that there were UI issues. This brings me to the subject of this post. The UI issues were a major roadblock, so I searched for a solution. The problem, I believe, stems from compositing inside Gnome. Unlike Ubuntu, I couldn't find an easy way to turn off compositing inside LinuxMint. OH, I'm sure I could disable the compositing extension inside the xorg.conf file, but I really wanted a light switch option. The normal way I would handle this is the Fusion Icon. It didn't seem to work. I also tried disabling effects from the Gnome Appearances menu option. Compositing just wouldn't turn off that easily.

So here is the solution for Eclipse and Aptana inside Linux Mint.

GDK_NATIVE_WINDOWS=true /opt/eclipse/eclipse

That will work if eclipse is installed in /opt/eclipse, but I just had mine downloaded to my home folder. It doesn't really matter. You would just change the /opt/eclipse/eclipse to your actual executable path. The key here is to add the GDK_NATIVE_WINDOWS=true before the eclipse command.

I'm about to create a shortcut to do this for me. Now all my buttons will work when I click on them. That's convenient huh.

, , , ,

No Comments

Resetting WordPress Passwords Manually

Posted by Randy in Open Source, SQL, technology, Web Development on January 10, 2010

I've had to do this for my wife and her mom both, so I thought I would share this with anyone who needs to reset a WordPress password. I personally love WordPress. You can build any type of site with it, not just a blog. If you have created a WordPress site but haven't visited the admin dashboard in a while, you may have forgotten your password. I thought that WordPress would email you a lost password, but maybe they didn't put in their correct email address. It could have also been the installation script they used through cPanel. Whichever the case, they couldn't get into their dashboard and they needed their passwords sent to them.

There's a very easy way to reset that password through SQL. Whether you are using phpmyadmin or some other SQL client to access your databases, you'll want to use the following SQL statement to reset your password:
UPDATE wp_users SET user_pass=md5('password1') WHERE ID=1;

You can change password1 to whatever you want. I'm amazed that WordPress passwords aren't stored with more encryption than a simple MD5 hash. It's secure enough, don't get me wrong. I'm just surprised that the WordPress developers didn't opt for more.

Oh well, I hope that helps someone in a pinch.

,

No Comments

Another look at Google Chrome

Posted by Randy in Applications, Internet, Open Source, technology on December 13, 2009

I've never published a "first look at Google Chrome", but I have been excited about it before. By Google Chrome, I'm referring to Google's webkit-based browser, not the Chrome OS.

When it was announced that Google was releasing it's own browser, I wasn't extremely excited. Then once it was available, I downloaded it to see how well it performed. I was amazed. The javascript executing was blazing fast. I'd never seen a web application respond so well. So, I suddenly became very excited about it and wanted to adopt it as my main browser.

This was soon shot down by the fact that I rely too heavily on certain extensions in Firefox, namely Gmail Notifier, Firebug, ForecastFox, and Adblock Plus. So, I had to keep using Firefox and hoped that one day Firefox would be able to handle javascript as good as Chrome.

Well the opposite has happened. Chrome now has extensions. I'm a little worried that it will be bloated and start performing slowly like Firefox. Firefox was once a lean mean browser. Now it is a bloated mess. It has started crashing without warming in Windows 7. I was once a Firefox advocate and I still like the browser, but it has been going downhill for the past year or two. Let's hope that Chrome doesn't follow down this path.

Firefox shouldn't even be that bloated. Sure, the extensions probably add to memory usage and Firefox reserves memory if it's available, but should a browser really be using half a gig of RAM? Seriously?

Chrome doesn't use less memory but it sure responds better. Adding extensions doesn't seem to lower performance either. I've added a GMail notifier, Google Wave Notifier, Forecastfox weather, Firebug Lite, and a couple other extensions and there is no noticeable change what-so-ever.

Now that these extensions are available for Chrome, I think it's time for me to take the next step. Chrome will be my main browser as soon as the extensions are available for the Mac and Linux versions. It's already going to be my main browser in Windows.

So, if you took a look at Chrome when it first came out, this may be a good time to look at it again. There are a few added features that may change your mind about it as well.

Reblog this post [with Zemanta]

, , , , , , ,

No Comments