iPhone Apps: iTunes on fivoca

Filed in iPhone | mac | web Leave a comment

stumble on this pretty interesting website that let you browse top ranking free/paid/grossing apps for the different countries that have itunes, for apple iphone, ipad and mac apps.

browse application through their screenshots, i personally love the photography category, allowing me to browse through all the camera sample screenshots instead of having to guess them from their icons and figure what type of lenses or effect it may offer!

worth the checks!

Installing mysqld on Dreamhost VPS

Filed in dreamhost | mysql | software | unix | web 8 Comments

If you do not already know, PS MySQL is useless! It’s basically a MySQL installation on a VPS where you have control over nothing! The only thing you have is assured memory allocation, which is pretty much useless.

So how? Why not create another VPS and install mysqld on it! Seriously, it’s that simple, with that you get full control of your MySQL server, in a real VPS environment.

Simple steps!

ssh into your VPS

ssh my_vps_admin_username@psXXXXX.dreamhostps.com

where psXXXXX is your VPS server name, like PS23535 etc.

type the following commands to install mysql server and client

sudo apt-get install mysql-server
sudo apt-get install mysql-client
All this point, your installation may fail, with errors like:

Can’t exec “/tmp/mysql-server-5.1.config.181101”: Permission denied at /usr/share/perl/5.10/IPC/Open3.pm line 168.
open2: exec of /tmp/mysql-server-5.1.config.181101 configure failed at /usr/share/perl5/Debconf/ConfModule.pm line 59

when you run:

sudo mount

you will see:

/dev/hdv1 on / type ufs (defaults)
none on /proc type proc (defaults)
none on /tmp type tmpfs (size=128m,mode=1777,nosuid,noexec,nodev)
none on /dev/pts type devpts (gid=5,mode=620)

you need

/dev/hdv1 on / type ufs (defaults)
none on /proc type proc (defaults)
none on /tmp type tmpfs (size=128m,mode=1777)
none on /dev/pts type devpts (gid=5,mode=620)

for your installation to run completely, without error.

Please submit a ticket to DH support, to request for the admin to mount /tmp folder without noexec. However, do note of the potential security issues, you may encounter.

Updates: from dlo in the comment, the default apt-get with DH will install only version 5.0, to get 5.1 while maintaining future update compatibility, simply:

sudo apt-get -t lenny-backports install mysql-server-5.1

Along with the pins in /etc/apt/preferences, this should allow you to keep it updated into the future. lenny-backports is already configured by DH in /etc/apt/sources.list by default.

Add Note
Verified: If you are on a new VPS, it is quite possible that your /etc/apt/preferences and /etc/apt/sources.list are not update or correctly configured for lenny-backports.

In /etc/apt/sources.list you will need to comment out the following line by adding a “#” in the beginning of the line


#deb http://www.backports.org/debian/ lenny-backports main

then ADD:

deb http://mirror.newdream.net/debian-backports/ lenny-backports main contrib non-free

In /etc/apt/preferences


Package: *
Pin: release a=lenny
Pin-Priority: 500

Package: *
Pin: release a=lenny-backports
Pin-Priority: 200

Package: emacs23
Pin: release a=lenny-backports
Pin-Priority: 900

Package: emacs23-common
Pin: release a=lenny-backports
Pin-Priority: 900

Package: debian-backports-keyring
Pin: release a=lenny-backports
Pin-Priority: 900

if you want to setup for remote access, do the follow:

sudo vi /etc/mysql/my.conf

look for bind-address and change to:

bind-address = psXXXXX.dreamhostps.com

again where psXXXXX is your VPS server name.

mysql -u root -p

then enter your password,

mysql> CREATE DATABASE your_new_database_name;
mysql> CREATE USER ‘newusr’@’psXXXXX.dreamhostps.com’ IDENTIFIED┬áBY ‘your_password’;
mysql> GRANT ALL PRIVILEGES ON *.* TO ‘newusr’@’psXXXXX.dreamhostps.com’ WITH GRANT OPTION;
mysql> CREATE USER ‘newusr’@’%’ IDENTIFIED BY ‘your_password’;

your mysql database user with username ‘newusr’ can now connect from any remote host, since using wildcard “%”.
just change “%” to a specified hostname if you are having a web application connecting to this database from say dreamhost shared hosting, with “%.dreamhost.com” or “%.dreamhostps.com”

alright! written in a bit of a rush cause i wasted many hours trying to install with much complicated methods! gosh*

Web: Facebook Share Button Generator

Filed in web 5 Comments

Ok, so i decided to write a generator myself! and here goes…





, ,

Web: Facebook Share Button

Filed in web 3 Comments

I was looking for the official facebook share button generator, but cannot seems to find it on their website. That’s because facebook no long want to support the share button, in order to make wider usage of the like button. I personally prefers the Share button, and here’s why!

How “Share” appear on feed:

How “Like” appear of feed:

quite clearly, facebook share get more space and attention on your feed.

a good documentation on how to implement Facebook share can still be found from google cache, which is still supported by Facebook.
I have ScreenGrab! the page, in case the cache get cleared, and you can download the png file below:

Let me include the source code for share button with counter here too:

Facebook Share Button with Above Counter

<a name="fb_share" type="box_count" href="http://www.facebook.com/sharer.php" share_url="http://howtogetitworking.com/">Share</a><script src="http://static.ak.fbcdn.net/connect.php/js/FB.Share" type="text/javascript"></script>

Facebook Share Button with Inline Counter

<a name="fb_share" type="button_count" href="http://www.facebook.com/sharer.php" share_url="http://howtogetitworking.com/">Share</a><script src="http://static.ak.fbcdn.net/connect.php/js/FB.Share" type="text/javascript"></script>

replace the variable inside the share_url attribute with a specify URL you may want to share, otherwise the share url will be of the page where you placed the button at.
the available type attributes are: button_count | box_count | button | icon_link | icon. of which only button_count and box_count will render the share counter.

, , , ,