Friday, July 20, 2007

This Insert comes in Handy..

In Gentoo, the my.cnf, has a default setting of binding the local interface to 127.0.0.1, hence from outside we are unable to connect to the server at port 3306.

Always remember, that before we check all the permissions inside the mysql db, we should check the connection from outside ie. 'telnet romote-address 3306' If this connects and still you get error in connection, then there is an authentication problem..

Check the host table..
if not insert this..
insert into host (Host,Db,Select_priv,Insert_priv,Update_priv,Delete_priv,Create_priv,Drop_priv,Grant_priv,References_priv,Index_priv,Alter_priv,Create_tmp_table_priv,Lock_tables_priv) values ('%','db_name','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');

% denotes all hosts.. You can mention an IP address to restrict connection from a certain IP address.


PEAR Installation on Windows..

Firstly get PHP installed on your machine.
next go to http://pear.php.net/go-pear, save this page as go-pear.php.

Assuming your PHP was installed nicely, and you had selected to configure the Env Variables, while Installing PHP, go to command prompt.. ie 'cmd'.
F:>php go-pear.php

Progress herewith by selecting the exact path of your PHP installation and continue henceforth.

How To Install Struts4PHP

Now, that Pear installed do the following things..

1) F:>pear channel-discover pear.struts4php.org
2) F:>pear install struts4php/struts4php
Although the above #2 command did not work on my machine..
I had to force install, it said some comflict with lang package ..
2) F:>pear --force install struts4php/struts4php

Thats all..

Now unto understanding the struts4php...

No comments:

VIM issues with powerline

What to do if you get this annoying issue - vi requirements.txt ...