Archive

Archive for the ‘how-to’ Category

ERROR 1045 (28000): Access denied for user ‘root’@'localhost’ (using password: NO)

July 27th, 2009

Today I got the error below :

1
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

after typing :

1
mysql -u root

I don’t know why ? but I know how to solve it.
First of all let’s disable password authentication :
Stop your MySQL daemon:

1
/etc/init.d/mysql stop

or

1
/etc/init.d/mysqld stop


Then run the following command line in background :

1
mysqld_safe --skip-grant-tables &

Secondly run :

1
mysql -u root

Finally, In your MySQL command line prompt issue the following command:

1
2
3
4
USE mysql;
UPDATE user SET password=PASSWORD("my_password") WHERE user="root";
FLUSH PRIVILEGES;
EXIT

Password is now reset to my_password. So just restart your MySQL server using :

1
/etc/init.d/mysql restart

or

1
/etc/init.d/mysqld restart

and use your new password to authenticate :

1
mysql -u root -p

All that remains is to enter your password.

  • Share/Bookmark

Marouan OMEZZINE Tips & Tricks, how-to ,

ERROR: ‘phpize’ failed on ubuntu

June 24th, 2009


Today when I tried to install a pear package using the pecl command line on ubuntu, I got the following error :

1
2
3
4
5
6
7
8
pecl install pecl_http
downloading pecl_http-1.6.3.tgz ...
Starting to download pecl_http-1.6.3.tgz (173,005 bytes)
.....................done: 173,005 bytes
71 source files, building
running: phpize
sh: phpize: not found
ERROR: `phpize' failed


Solution :
Just install php5-dev package

1
apt-get install php5-dev

or php4-dev if you are running php 4.x

1
apt-get install php4-dev
  • Share/Bookmark

Marouan OMEZZINE Tips & Tricks, how-to , , , ,

LoadError : no such file to load — readline (LoadError) when running script/console on ubuntu

June 15th, 2009

Q : What’s the best thing that may happen to a developer ?
A : A Bug :) at the beginning of the day :)

I ran script/console in a rails project to debug something on console, but I got this LoadError:

1
2
3
4
5
6
7
8
9
10
Loading development environment (Rails 2.1.0)
/usr/local/lib/ruby/1.8/irb/completion.rb:10:in `require’: no such file to load — readline (LoadError)
        from /usr/local/lib/ruby/1.8/irb/completion.rb:10
        from /usr/local/lib/ruby/1.8/irb/init.rb:252:in `require’
        from /usr/local/lib/ruby/1.8/irb/init.rb:252:in `load_modules’
        from /usr/local/lib/ruby/1.8/irb/init.rb:250:in `each’
        from /usr/local/lib/ruby/1.8/irb/init.rb:250:in `load_modules’
        from /usr/local/lib/ruby/1.8/irb/init.rb:21:in `setup’
        from /usr/local/lib/ruby/1.8/irb.rb:54:in `start’
        from /usr/local/bin/irb:13


How to fix ?
I figured out that some libraries are missing after installing ruby from sources (I got those troubles after upgrading my ubuntu from 8.10 to 9.04 and then reinstalling ruby from sources to solve a non-compatibility problem of the already installed ruby binary package with ubuntu 9.04) :

1
2
sudo apt-get install libncurses5-dev
sudo apt-get install libreadline5-dev

Then move to your ruby source folder, subfolder ext/readline and then configure, build and install stuffs.

1
2
3
4
cd /usr/src/ruby-1.8.6-p368/ext/readline/
ruby extconf.rb
sudo make
sudo make install

you may get something like this : ( when running ruby extconf.rb)

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
marouan@myownpercept:/usr/src/ruby-1.8.6-p368/ext/readline$ sudo ruby extconf.rb
checking for tgetnum() in -lncurses... yes
checking for readline/readline.h... yes
checking for readline/history.h... yes
checking for readline() in -lreadline... yes
checking for rl_filename_completion_function()... yes
checking for rl_username_completion_function()... yes
checking for rl_completion_matches()... yes
checking for rl_deprep_term_function in stdio.h,readline/readline.h,readline/history.h... yes
checking for rl_completion_append_character in stdio.h,readline/readline.h,readline/history.h... yes
checking for rl_basic_word_break_characters in stdio.h,readline/readline.h,readline/history.h... yes
checking for rl_completer_word_break_characters in stdio.h,readline/readline.h,readline/history.h... yes
checking for rl_basic_quote_characters in stdio.h,readline/readline.h,readline/history.h... yes
checking for rl_completer_quote_characters in stdio.h,readline/readline.h,readline/history.h... yes
checking for rl_filename_quote_characters in stdio.h,readline/readline.h,readline/history.h... yes
checking for rl_attempted_completion_over in stdio.h,readline/readline.h,readline/history.h... yes
checking for rl_library_version in stdio.h,readline/readline.h,readline/history.h... yes
checking for rl_event_hook in stdio.h,readline/readline.h,readline/history.h... yes
checking for rl_cleanup_after_signal()... yes
checking for rl_clear_signals()... yes
checking for rl_vi_editing_mode()... yes
checking for rl_emacs_editing_mode()... yes
checking for replace_history_entry()... yes
checking for remove_history()... yes
creating Makefile
  • Share/Bookmark

Marouan OMEZZINE Tips & Tricks, Web development, how-to , , ,

How to remove the blue border around an image link

April 12th, 2009

You want to use an image as a link.However, a blue border appears around the image.

1
2
3
<a href="http://www.myownpercept.com/">  
  <img src="logo.png" alt="" />
</a>

This border is meant to inform users that the image is a link. Well, it’s a link but this is ugly :s and may not fit your need. 
  

Solution

  1. You simply have to add a border-style, set to none, as a style to your img tag
    1
    2
    3
    
    <a href="http://www.myownpercept.com/">
      <img style="border-style: none;" src="logo.png" alt="" />
    </a>
  2. A cleaner way, that will pass the W3C validation, is by adding those lines to your CSS file :
    1
    2
    3
    
    img {
    	border-style: none;
    }
  3. A dirty old way, but works, is by adding border attribute to the img tag.
    1
    2
    3
    
    <a href="http://www.myownpercept.com/">  
      <img src="logo.png" border="0" alt="" />
    </a>
  • Share/Bookmark

Marouan OMEZZINE Tips & Tricks, Web development, how-to, snippet ,

Restore Joomla! 1.5 administrator’s password (for dummies)

March 22nd, 2009

I have installed a new Joomla! instance but unluckily I forgot my password :-( .I was seeking for the forget my password link but no way !

Solutions :

  1. Generate a new MD5 hashed / encrypted password, to do this you can visit :  http://pajhome.org.uk/crypt/md5/ type your clear password and then en crypt it using MD5.
  2. illustration

  3. Go to your phpmyadmin or any other MySQL client  and execute the query  below (don’t forget to replace your_new_encrypted_password by your own encrypted  password) or just do it manually through the gui/phpmyadmin interface: 
    UPDATE jos_users SET password='your_new_encrypted_password' WHERE name='Administrator';

    PS : verify your table’s prefix, as here I am using jos_ as a table prefix.

  4. You can now log-in using your new password.
  • Share/Bookmark

Marouan OMEZZINE Tips & Tricks, how-to

Firebug Lite in Google Chrome

March 21st, 2009

You are a Web developer/designer :) , I believe you have used Firebug extension in Firefox to track bugs or to test your hot CSS changes before coding using your favourite editor.

firebug-splash

What about if you ever have tried Google Chrome browser and a new love story starts .. Leave Firefox ? or forget about your new love ?

Sure there is a “solution” and it is named Firebug Lite : a JavaScript file you can insert into your pages to simulate some Firebug features in browsers that are not named “Firefox”.

 Just insert this line of code to load Firebug Lite in a specific page you want to debug :

<script src="http://getfirebug.com/releases/lite/1.2/firebug-lite-compressed.js" type="text/javascript"><!--mce:0--></script>

For more information visit : http://getfirebug.com/lite.html

Also, you can simply drag the red bug icon below to your bookmark toolbar then you will be able to use FB Lite with any page  :

Track my bug!

 

<a href="javascript:var firebug=document.createElement('script');firebug.setAttribute('src','http://getfirebug.com/releases/lite/1.2/firebug-lite-compressed.js');document.body.appendChild(firebug);(function(){if(window.firebug.version){firebug.init();}else{setTimeout(arguments.callee);}})();void(firebug);">Firebug Lite</a>

All basic commands of Firebug are supported by this Lite version.  I have tried it with Google Chrome .. It’s not as smooth as in Forefox .. I hope that a native Firebug extension for Google Chrome and others webkit based browsers will see the light soon. As I believe that the Lite version is not a real replacement for the Native Firefox extension.

You can do a lot of funny stuffs like using Firebug Lite offline , changing FB Lite’s CSS style.. So check out http://getfirebug.com/lite.html for more information.

  • Share/Bookmark

Marouan OMEZZINE how-to , , ,