By Rupert
Debian MySQL
A default install of mysql on debian would have bind-address set to 127.0.0.1. This is why you can’t accept remote connections to your mysql. In order to establish remote connections to mysql on debian servers, please comment the bind-address as shown below.
42 language = /usr/share/mysql/english 43 skip-external-locking 44 # 45 # Instead of skip-networking the default is now to listen only on 46 # localhost which is more compatible and is not less secure. 47 #bind-address = 127.0.0.1 48 #
| Print article | This entry was posted by rupert on October 30, 2007 at 6:21 am, and is filed under debian, mysql. Follow any responses to this post through RSS 2.0. You can skip to the end and leave a response. Pinging is currently not allowed. |
No comments yet.
Rails Note #13: RubyonRails + Oracle on Linux (i386 / x64)
about 1 year ago - No comments
In summary, install Oracle Instant Client and try to run sqlplus. If sqlplus connects to the oracle sid then go ahead and install the rails adapters for oracle. What is important to note here, is to install the oracle-instantclient for the architecture of your machine.. I have tested this on Debian Lenny (i386) and CentOS5
Rails Note #4: Deploying a Rails Application in a Subdirectory
about 1 year ago - No comments
There are many ways to deploy RoR applications. I have googled all over the place and so far the easiest setup that I could find that would suit my needs (existing Apache2 + ColdFusion + TileCache) would be to use 1. Apache PROXY 2. Mongrel CentOS Installation Instructions 1. Make sure Apache has mod_proxy ./configure
Chinese Debian Repository
about 1 year ago - No comments
Its been a long time I have not updated debian. Now, debian.cn99.com is not working. However, there is a new mirror in town.. www.anheng.com.cn. http://www.debian.org/mirror/list
Post Install Apache2.x, ColdFusion 8
about 2 years ago - No comments
After binding Apache2.x and ColdFusion 8, I find it very useful to follow the post-install instructions below: 1. Copying ColdFusion Admin directory to /wwwroot (webroot) # ln -s /var/www /wwwroot # cp -Rf /opt/coldfusion8/wwwroot/CFIDE /wwwroot/ # rm /wwwroot/index.html # cd /wwwroot # ln -s CFIDE cfide 2. Adding index.cfm to DirectoryIndex. # vim /etc/apache2/mods-available/dir.conf DirectoryIndex
Installing Postgresql, Postgis, pgRouting on Debian
about 2 years ago - Comments Off
Operating System: Debian sid Versions: postgres 8.3.1 postgis 1.3.3 pgRouting1.02 1. Install base system and ssh #vi /etc/apt/sources.list to include deb http://debian.cn99.com/debian etch main deb-src http://debian.cn99.com/debian etch main #apt-get update #apt-get upgrade libc6 2. Install the required packages for postgres8.3 and postgis1.3.3 #apt-get install sudo nmap telnet #apt-get install python2.5 python2.5-dev python-setuptools #apt-get install g++
Installing Mapserver on Debian (reprise)
about 2 years ago - 1 comment
As noted from my previous blog post regarding Mapserver on Debian, you don’t get AGG with Mapserver when installing directly from Debian packages. Thus, it would be better to install Mapserver by source. However, debian still helps because it would install all the necessary libraries needed for compiling mapserver. ./configure \ –with-agg \ –with-jpeg \
Installing Firefox on Linux (Debian)
about 2 years ago - No comments
I read somewhere that Firefox was renamed to Iceweasel on Debian. Thus, I can’t install the Google Toolbar for it. So here are the steps for installing Firefox manually in a linux system. 1. Download the source from Mozilla’s site 2. Unpack the source. tar -zxvf firefox-2.0.0.12.tar.gz 3. Create a shell script pointing to the
Debian Command CheatSheet
about 2 years ago - No comments
If you need to setup/install Debian. Please follow this post. 1. Removing a service from startup # update-rc.d -f samba remove 2. Installing a service on boot update-rc.d myServiceName start 80 2 3 4 5 . stop 15 0 1 6 3. Specifying Debian Sources #vim /etc/apt/sources.list #SID: deb http://debian.cn99.com/debian unstable main deb-src http://debian.cn99.com/debian unstable
Installing Subversion on Debian
about 2 years ago - No comments
I was greeted with “No space left on device” on my cron log. Turns out that my svn server obviously ran out of disk space. The old svn server was running on CentOS4.3, Subversion 1.3.2, Trac-0.11.devxxx. I decided to migrate the svn data to a new server, so I installed Debian4.01 on a small server
Installing R on Windows and Debian
about 2 years ago - No comments
‘R’ is a statistical package. For an overview, please go to www.r-project.org My intention was to remove the point outliers from a given set of point geometries. I just recently installed R both on my Windows XP and Debian. Regina’s www.bostongis.com is an excellent tutorial in getting involved with R. I do suggest you head