Granting remote access to your MySQL database

I will keep this short and sweet!

if you want to access all your databases

GRANT ALL ON *.* TO username@'yourhostnameorip' IDENTIFIED BY 'PASSWORD

if you want to access a particular database

GRANT ALL ON databasename.* TO username@'yourhostnameorip' IDENTIFIED BY 'PASSWORD
Posted in Programming | Tagged | Leave a comment

[Solved] The Web Application project ‘MyWebApp’ is configured to use IIS error

“The Web Application project ‘MyWebApp’ is configured to use IIS.

To access local IIS Web sites, you must install the following IIS components

IIS 6 Metabase and IIS 6 Configuration Compatibility Authentication”

This happens when a project created using Visual Studio 2008 is imported opened using Visual Studio 2010. To solve this issue do the following

1) Open your CSProj file in a text editor

2) Replace the following lines


<UseIIS>True</UseIIS>

with

<UseIIS>False</UseIIS>

and

<IISUrl>http://localhost/site</IISUrl>

with

<CustomServerUrl> http://localhost/site </CustomServerUrl>
Posted in Programming | Tagged , , | 1 Comment

Sticky wicket. Dealing with FBML deprecation, Iframe facebook app as page tab

Here is the situation break-down.
*Facebook is deprecating FBML this year, 2011.
*FBML is most often used to create facebook page tabs. Since facebook is deprecating FBML it no more makes sense.
*Facebook documents say developers need to go with Iframe apps from now on and not FBML.
*So in order to create a facebook page tab, one needs to create a facebook application(IFRAME) and add the app as a page tab.
*BUT, iframe is not allowed inside page tabs, as in tags such as body , any custom Javascript is not allowed inside a page tab.

So its a messy situation. Is there any solution to this problem? the answer is NO. Going still with FBML is the only solution.

I had to spend hours and hours to find out that there is no solution to this problem as of now. The only way is to go with FBML even though Facebook suggests against doing it. And thats exactly why i am posting this. So you guys save time.

There is a super easy way to add a facebook application(IFrame) to your page as a tab. Just an URL with the following format will do.

http://www.facebook.com/add.php?api_key={your_facebook_app_key}&pages=1&page={page_id}

Here is an example. You will know what i am talking about

http://www.facebook.com/add.php?api_key=d702312c39692db23db1f5b321051191&pages=1

And now an another problem with facebook Iframe app as your page tab. I am very sure most of the time you will need to access the visiting user’s information. But hey guess what? You cannot access it. Period. (if your page tab is a facebook application).

You will need to prompt the user for permission to access it. I have not tried doing it. I just used FBML even though its against what Facebook suggests. Facebook has seriously messed this up and i hope they will sort this entire FBML vs IFrame thing soon or else developers might go crazy.

Went crazy but now fine,

Keyan

Posted in Programming | Tagged , | Leave a comment

In search of the neos and the oracles

Folks,

We are looking for freshers who love working with web development in a start-up environment. We say ‘web-development’ because he or she should be willing to work with HTML, Javascript, CSS, Ruby on Rails and PHP. Yes. from UI to server side stuff. It will only help you in staying ahead of your contemporaries working in MNCs. Believe me its good for you.

And to be fair, we don’t expect you to know everything from HTML, JS, CSS to RoR and PHP. You would qualify if you know HTML, CSS and PHP and have a great deal of love for web apps. The rest of the stuff you can learn here.

Lets talk about the company now. ByteAlly officially became a private limited in February 2010. We have clients across US, Europe and India. We primarily develop anything that can run on the web, but our main focus for the next year or so would be on Social media marketing and analytics which is a fascinating segment to work on.

So shoot us an email at putchuttni@byteally.com if you are interested along with your resume, twitter ID(if you have one), blog urls (if you have any). Oh yes, we would like to know you better before we have some face time.

Cheers,
Karthikeyan Mani
CTO/Managing Director/Chef/ Car driver
ByteAlly Software Solutions private limited.

www.byteally.com

byteally careers

byteally careers

Posted in ByteAlly | Tagged | Leave a comment

Lessons learnt on PayPal Website Payments Pro API today, Supported currencies, Changes needed with Active merchant integration

First of all the blokes at paypal need to organize their documentation well. I spent more time trying to figure out the currencies  supported by PayPal web standards pro for reals than i spent on the actual integration. There seems to be a confusion amongst fellow developers too regarding the currencies supported by PayPal Website Payments Pro.

Paypal website payments pro US supports only AUD,CAD,EUR,JPY,GBP,USD

while Paypal website payments pro UK and Canada supports

AUD,CAD,EUR,JPY,GBP,USD,CHF,SEK,SGD,PLN,NZD,NOK,DKK,CZK

So my fellow developers from switzerland , denmark,  hungary, new zealand, poland, norway, singapore and sweden, im sure your currencies smell lovely! but its sad PayPal does not support them yet with Pro US accounts. Hmmm.

And going now to the actual integration, i found out today that with Direct Payment when you are authorizing or paying with a new credit card, the billing address is necessary otherwise the API will return the error

“Please enter a complete shipping address”

So be sure to send that in as well to the API. If you are using ActiveMerchant gem for ruby on rails to integrate PayPal the code below is for your reference.


response = gateway.authorize(100, credit_card,{ :ip => "127.0.0.1",:billing_address => {
 :name     => "vin dibly",
 :address1 => "#3, The street where no milkman arrives, Mullholand drive",
 :city     => "Los angeles",
 :state    => "California",
 :country  => "US",
 :zip      => "90001"}}

 )

And please note that the value for country should be the Iso2 country code and not the country’s name.

If you happen to work with PayPal website payments pro please be sure to go through the following link. Will be helpful

https://cms.paypal.com/us/cgi-bin/?cmd=_render-content&content_ID=developer/e_howto_api_WPWebsitePaymentsPro

Posted in Programming | Tagged , , , , , | 1 Comment