{"id":173,"date":"2009-12-30T14:02:02","date_gmt":"2009-12-30T14:02:02","guid":{"rendered":"http:\/\/www.muratyaman.co.uk\/wp\/?p=173"},"modified":"2020-04-01T12:39:05","modified_gmt":"2020-04-01T11:39:05","slug":"setting-up-a-web-application-on-centos-continued","status":"publish","type":"post","link":"https:\/\/www.muratyaman.co.uk\/blog\/index.php\/2009\/12\/setting-up-a-web-application-on-centos-continued\/","title":{"rendered":"Setting up a web application on CentOS (continued)"},"content":{"rendered":"

Before continuing the rest of the installation process we started (\/wp\/index.php\/2009\/07\/setting-up-a-web-application-on-centos-5-3\/<\/a>), I must mention my appreciation for the “yummy” tool Linux developers provided: yum<\/a><\/strong> (.. an automatic updater and package installer\/remover for rpm systems). I love using webmin<\/a><\/strong> (.. a web-based interface for system administration for Unix) as well. The other day I only clicked on a button<\/strong> to upgrade almost all the packages in our CentOS box; this facility is using yum in the background. It took almost 2 hours: just be patient \ud83d\ude42<\/p>\n

The main problem I have experienced was the create the link between PHP and Oracle 10g Express Database server. Thanks to Google I was able to find people on the net that had the similar issues.<\/p>\n

I downloaded 2 (free) packages from Oracle’s website (into folder \/usr\/src\/<\/strong>):<\/p>\n

oracle-instantclient-basic-10.2.0.3-1.x86_64.rpm
\noracle-instantclient-devel-10.2.0.3-1.x86_64.rpm<\/p>\n

Then, I ran:<\/p>\n

\r\ncd \/usr\/src\/\r\nrpm -ivh oracle-instantclient-basic-10.2.0.3-1.x86_64.rpm\r\nrpm -ivh oracle-instantclient-devel-10.2.0.3-1.x86_64.rpm\r\n<\/pre>\n
Development packages and a compiler were needed, as far as I understood from the error messages.<\/p>\n
\r\nyum install gcc\r\nyum install php-devel\r\nyum install php-pecl-* --skip-broken\r\nyum install php-oci8\r\npecl install oci8\r\n<\/pre>\n
When it asks for the ORACLE_HOME or Oracle Instant Client, type:<\/p>\n
instantclient,\/usr\/lib\/oracle\/10.2.0.3\/client64\/lib<\/strong><\/p>\n
\r\n[root@localhost src]# pecl install oci8\r\ndownloading oci8-1.3.5.tgz ...\r\nStarting to download oci8-1.3.5.tgz (137,987 bytes)\r\n............................done: 137,987 bytes\r\n10 source files, building\r\nrunning: phpize\r\nConfiguring for:\r\nPHP Api Version:         20090626\r\nZend Module Api No:      20090626\r\nZend Extension Api No:   220090626\r\nPlease provide the path to the ORACLE_HOME directory. Use 'instantclient,\/path\/to\/instant\/client\/lib' if you're compiling with Oracle Instant Client [autodetect] : instantclient,\/usr\/lib\/oracle\/10.2.0.3\/client64\/lib\r\n<\/pre>\n
By the way, I did not need all the pecl libraries installed. I simply went into \/etc\/php.d\/ and commented out the lines for extensions (to disable them):<\/p>\n
\r\n[root@localhost php.d]# ls\r\napc.ini       gmagick.ini    lzf.ini        oci8.ini          pdo_sqlite.ini        sphinx.ini  z-mailparse.ini\r\ncurl.ini      imap.ini       mbstring.ini   pdf.ini           phar.ini              sqlite.ini\r\nfileinfo.ini  interbase.ini  memcached.ini  pdo_firebird.ini  php-pecl-imagick.ini  ssh2.ini\r\ngd.ini        json.ini       memcache.ini   pdo.ini           pspell.ini            xdebug.ini\r\ngeoip.ini     ldap.ini       ncurses.ini    pdo_oci.ini       radius.ini            zip.ini\r\n\r\n[root@localhost php.d]# nano xdebug.ini\r\n; Enable xdebug extension module\r\n; zend_extension=\/usr\/lib64\/php\/modules\/xdebug.so\r\n<\/pre>\n
So, far the packages installed help us run our bespoke web application on Apache (httpd 2.2.3), PHP 5.3.1, Firebird 2.1.2, Oracle 10g XE.<\/p>\n
Check the following useful extras:<\/p>\n
\r\nyum install aspell\r\nyum install php-pspell\r\nyum install php-imap\r\n<\/pre>\n
Reading emails from an IMAP server, parsing structured content, preparing emails using by TinyMCE with spellchecker and sending email using PHPMailer class are all fun!<\/p>\n
Happy coding!<\/p>\n","protected":false},"excerpt":{"rendered":"
Before continuing the rest of the installation process we started, I must mention my appreciation for the “yummy” tool Linux developers provided…<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[69,126,38,26,70],"class_list":["post-173","post","type-post","status-publish","format-standard","hentry","category-technology","tag-gcc","tag-linux","tag-oracle","tag-php","tag-yum"],"_links":{"self":[{"href":"https:\/\/www.muratyaman.co.uk\/blog\/index.php\/wp-json\/wp\/v2\/posts\/173","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.muratyaman.co.uk\/blog\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.muratyaman.co.uk\/blog\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.muratyaman.co.uk\/blog\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.muratyaman.co.uk\/blog\/index.php\/wp-json\/wp\/v2\/comments?post=173"}],"version-history":[{"count":7,"href":"https:\/\/www.muratyaman.co.uk\/blog\/index.php\/wp-json\/wp\/v2\/posts\/173\/revisions"}],"predecessor-version":[{"id":951,"href":"https:\/\/www.muratyaman.co.uk\/blog\/index.php\/wp-json\/wp\/v2\/posts\/173\/revisions\/951"}],"wp:attachment":[{"href":"https:\/\/www.muratyaman.co.uk\/blog\/index.php\/wp-json\/wp\/v2\/media?parent=173"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.muratyaman.co.uk\/blog\/index.php\/wp-json\/wp\/v2\/categories?post=173"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.muratyaman.co.uk\/blog\/index.php\/wp-json\/wp\/v2\/tags?post=173"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}