Sinan'ın Yeri

Today I have changed my mind and decided to begin learning and using Postgresql. On a Centos 6 host there are some ways of installing Postgresql. I have chosen the easy one: use repos. Here http://yum.pgrpms.org/repopackages.php is the official Postgresql repos for Red Hat related distros. I have chosen the x86_64 rpm for Centos 6 and installed it. Later using yum install postgresql91-server I have installed three packages postgresql91,postgresql91-server and postgresql91-libs which is enough for now to start Postgresql 9.1. Using the instructions at /usr/share/doc/postgresql91-9.1.1/README.rpm-dist , I first did service postgresql-9.1 initdb and then service postgresql-9.1 start.Voila! Now let the journey begin! Edit:  Here is another place to look instructions http://www.postgresonline.com/journal/archives/203-postgresql90-yum.html

I have installed Eclipse 3.7 by using repos (universe maybe) and then installed PDT from within Eclipse. I used the instructions on web page http://wiki.eclipse.org/PDT/Installation#Install_a_JVM by adding Indigo update site. It works.Now its time to grab info about Aptana.

I have stucked with Php 5.3 and Mysql 5.5 packages installed from Remi repo to Centos 5.7 server. So I removed them and decided to use distro's old packages. Now it seems to work fine. I tr to satisfy Yii's requirements. Although the requirement checker says it is installable to my system, I try to provide more requirements for Yii namely, APC,Dom,pdo_mysql etc. As you guess when installing packages (pdo_mysql,APC etc)  with pecl some problems happen. One of them happens when installing APC, the error "make: *** [apc.lo] Error 1". The solution is to install pcre-devel package. I dont think APC is a good optimize, lets use it for the Yii's sake.

Since a couple of days I have been geting along with Yii. I follow the instructions from Larry Ullman's page. At first I try nginx as web server, but when url rewriting and session handling I got some problems. I thought it is because of nginx,ie I mean I dont know the right way to fix nginx. Then I started httpd and now trying it.As a requirement of Yii installation, I saw pdo_mysql needs to be installed. Now I try to install it.

When you use yii url rewrite feature, actually it is configured for the apache web server. For people like me who uses nginx for web serving purposes one needs to do additional configuration to Yii. Here   is a good blog post which suggests a solution for our problem. After doing this one can get better written urls. Thanks for the info William. Edit: Here is a snippet from Yii CookBook and here is a complete config for Yii,PHPFM and Nginx from Yii's wiki.

I tried iRedMail today on a Centos 5.7 server. The installation seems to smooth if you keep the distro's main packages unchanged. Namely I have had enabled the remi repo which upgrades php and mysql packages. When installing iRedMail the upgraded packages of mysql gave some syntax errors on some .sql scripts. After some search I manually configured them afterwards. So now iRedMail seems working. One must notice that iRedMail tried to install required packages dont checking if they are already installed or not. So this is problematic. But there are some ways disabling this behaviour. Here are the sql problems I got ERROR 1064 (42000) at line 4 in file: '/usr/share/doc/policyd-1.82/DATABASE.mysql': You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 6 which is resolved by changing all occurences of TYPE with ENGINE in the script. ERROR 1064 (42000) at line 17 in fil...

I found a way of starting php fastcgi processes thanks to howtoforge,.com article Actually I have tried php-fpm with no success and didnt try any further. But it was really simple. One needs to set cgi.fix_pathinfo=0 at php.ini. And with proper user and group account names on /etc/php-fpm.d/www.conf file, php-fpm just works.  

Recently looking for centos 5.6 server's php update. Some 3rd party repos over there to choose from beside the centos testing repo. Tried Remi,Ius repos. Generally there are dependency problems about packages and problems with fast cgi on php. Dependency problems are crazy and discouraging. When you upgrade to php 5.2 or 5.3 previously working fast-cgi programs could become not working. Possible maybe-working cgi programs are spawn-fcgi and php-fpm. Here are some working commands  yum --enablerepo=remi install php-common php php-suhosin php-cli php-mysql mysql spawn-fcgi -a 127.0.0.1 -p 9000 -f /usr/bin/php-cgi -C 5 -U php