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 […]
In: Server Config, Ubuntu Tricks, Web Development · Tagged with: MySQL Administrator, ssh
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 […]
In: SEO, Web Development · Tagged with: 404, dynamic content, featured, google analytics, google webmaster tools, search engine optimization, search traffic, SEO, title tags
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
In: Server Config, Ubuntu Tricks, Web Development · Tagged with: corkscrew, git, github.com, http proxy, ssh
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, […]
In: Ruby on Rails, Server Config · Tagged with: error, ldconfig, PostGIS, postgresql, problem
