Centos 6 Postgresql 9.1 Install

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

Eclipse 3.7 PDT on Kubuntu

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.

Php 5.3 problems

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.

Yii journey continues

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.

Yii Nginx Php FastCgi Url Rewrite Configuration

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.

iRedMail for Centos 5.7

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 file: '/var/www/iRedAdmin-0.1.6/docs/samples/iredadmin.sql': 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 '(14) NOT NULL DEFAULT CURRENT_TIMESTAMP, which is resolved by deleting the number 14 at TIMESTAMP(14).

Because of those errors the user ireadadmin is not configured and I was getting internal server error at page www.domain.com/ireadadmin. The I found the password of iredadmin user at file /var/www/iredadmin/settings.ini and gave the grants.

Also I got some errors beforehand when initiating mysql server. I recognised that the lines

default-character-set   = utf8

skip-locking  at my.cnf  causing mysql die. So I commented them out and mysql began working.

What I learnt form this journey:

1- Keep the distro's packages unchanged if you want to use iRedMail.

2- Let iRedMail install those packages,ie. remove the packages which are pre-installed.

 

Php 5.3 Fastcgi contd

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.

 

Centos Remi Php 5.3 Fastcgi etc

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