Wetware » 2010 » March

Archive for March, 2010

MySQL Admin via SSH Tunnel

Lets create a ssh tunnel into our remote server so that we can connect MySQL Administrator.  This will trick MySQL Administrator into thinking that it has a local connection to the remote machine when it doesn’t.  This is great for getting around having only local MySQL access rights while trying to login from a remote […]

Posted on March 18, 2010 at 8:30 pm by Jordan Carter · Permalink · Leave a comment
In: Server Config, Ubuntu Tricks, Web Development · Tagged with: ,

SEO for large Dynamic sites

Over the last year I have worked very close at improving the SEO for a large dynamic website.  The website has 200k+ pages, 99% of which are user content.  The website currently relies solely on Google traffic and has no large inbound links. Here is some of the things that I have learnt first hand […]

Can’t Access Github behind proxy or Firewall

Use corkscrew to get through the firewall. You will have to install it from source. website: http://www.agroman.net/corkscrew/ Now edit your ~/.ssh/config file, create it if you haven’t got one. > cat ~/.ssh/config Host gitproxy User git Hostname ssh.github.com Port 443 ProxyCommand /usr/local/bin/corkscrew proxy.example.com 3128 %h %p IdentityFile /home/jordan/.ssh/id_rsa Now use this proxy when cloning git

Posted on March 17, 2010 at 9:45 pm by Jordan Carter · Permalink · 5 Comments
In: Server Config, Ubuntu Tricks, Web Development · Tagged with: , , , ,

PostGIS psqlostgis ERROR could not load library /usr/lib/postgresql/8.4/lib/postgis-1.5.so

Trying to install PostGIS and you can’t get past this error? psqlostgis.sql:57: NOTICE:  type “spheroid” is not yet defined DETAIL:  Creating a shell type definition. psqlostgis.sql:57: ERROR:  could not load library “/usr/lib/postgresql/8.4/lib/postgis-1.5.so”: /usr/lib/postgresql/8.4/lib/postgis-1.5.so: undefined symbol: GEOSHausdorffDistance psqlostgis.sql:63: ERROR:  current transaction is aborted, commands ignored until end of transaction block psqlostgis.sql:68: ERROR:  current transaction is aborted, […]

Posted on March 10, 2010 at 12:44 pm by Jordan Carter · Permalink · 5 Comments
In: Ruby on Rails, Server Config · Tagged with: , , , ,