I know this isn't a 'database' question, but I thought I'd start my replying to this message before I went elsewhere. I've also posted this to the Zend Community Edition forums and am still waiting to hear back there too.
I've done most of this and I've added the Zend repository into my yum to install the Zend Server, but each time I try to install using 'yum install zend-server-php-5.3' (or 5.2) I get this at the end of the install command:
Finished Dependency Resolution
Error: Package: php-5.3-dev-zend-server-5.3.9-277.x86_64 (Zend)
Requires: zend-base
Error: Package: jq-daemon-zend-server-5.6.0-287.x86_64 (Zend)
Requires: zend-base
Error: Package: lighttpd-zend-server-1.4.26-13.x86_64 (Zend)
Requires: zend-base
Error: Package: php-5.3-page-cache-zend-server-6:5.6.0-284.x86_64 (Zend)
Requires: zend-base
Error: Package: php-5.3-code-tracing-zend-server-5.6.0-278.x86_64 (Zend)
Requires: zend-base
Error: Package: zend-server-php-5.3-5.6.0-341.noarch (Zend_noarch)
Requires: zend-base
Error: Package: php-5.3-jobqueue-zend-server-5.6.0-298.x86_64 (Zend)
Requires: zend-base
Error: Package: deployment-daemon-zend-server-5.6.0-277.x86_64 (Zend)
Requires: zend-base
Error: Package: php-5.3-data-cache-zend-server-5.6.0-273.x86_64 (Zend)
Requires: zend-base
You could try using --skip-broken to work around the problem
You could try running: rpm -Va --nofiles --nodigest
I also get this if I download the Zend setup script and try to do it that way too.
Anyone have any suggestions as to how I can get the 'zend-base' package installed? I've tried doing 'yum install zend-base' and just get this:
# yum install zend-base
Loaded plugins: langpacks, presto, refresh-packagekit
Resolving Dependencies
--> Running transaction check
---> Package zend-base.x86_64 0:5.6.0-276 will be installed
--> Restarting Dependency Resolution with new changes.
--> Running transaction check
---> Package zend-base.x86_64 0:5.6.0-276 will be installed
--> Finished Dependency Resolution
#
Thanks, all!
Charles
_____________________________________________________________________
Charles Buege | The Morey Corporation | Research and Development/IT Special Projects
100 Morey Drive | Woodridge, IL 60517
Phone: 630-754-2181 | Fax: 630-754-2581 | Cell: 630-605-2077
cbuege@xxxxxxxxxxxxx | www.moreycorp.com
Follow us on Twitter! http://twitter.com/Moreycorp
From: Daniel Krook <krook@xxxxxxxxxx>
To: php-db@xxxxxxxxxxxxx,
Cc: Charles W Buege <cbuege@xxxxxxxxxxxxx>
Date: 05/11/2012 09:35 AM
Subject: Re: Installing IBM DB2 drivers onto an Apache Server under Fedora 16 x64 to access IBM POWER7 DB2 via PHP....
Hi Charles,
So you just need to get the Apache on Fedora configured to connect to the DB2 servers on AIX? This is a good a list to ask as any :)
Here are the steps I would take (some of which you might have already done... so it's up to you whether you want to start fresh or tweak my instructions).
This is based on RHEL / CentOS using DB2 v9.7, so it might be slightly different for you.
(Sorry for the top post, it's easier to write this all up front.)
1. Download the DB2 Runtime Client. Based on the specs you mention, it would be:
IBM Data Server Runtime Client (Linux AMD64 and Intel EM64T)
ibm_data_server_runtime_client_linuxx64_v10.1.tar.gz (613 MB)
2. Install and configure the DB2 RC (I use 9.7, so modify this for 10.1):
tar -xzvf ibm_data_server_runtime_client_linuxx64_v9.7.tar.gz
cd rtcl
echo "no" > rsp.txt
./db2_install < rsp.txt
groupadd db2iadm1
useradd db2inst1 -g db2iadm1
/opt/ibm/db2/V9.7/instance/db2icrt -s client db2inst1
echo '. /home/db2inst1/sqllib/db2profile' >> /etc/sysconfig/httpd # Assuming yum install of httpd... otherwise put it in apachectl
2. Then either download the PHP and IBM DB2 extension source (instructions here: http://us.php.net/manual/en/ibm-db2.installation.php), or use Zend Server (which I recommend if you want to manage everything with yum, including the DB2 drivers).
http://www.zend.com/en/products/server/downloads
Install, then add the "php-5.3-ibmdb2-zend-server" extra package (you could also install the PDO one).
3. Catalog the remote system (optional... you'd just use a lengthier connection string in step 4)
. /home/db2inst1/sqllib/db2profile
db2 "catalog tcpip node aixbox1 remote db2.example.com server 50000 remote_instance db2inst1 ostype aix"
db2 "catalog database sample as sample at node aixbox1 "
4. Test your connection from /var/www/html/index.php.
$conn_resource = db2_connect($db2_name, $db2_user, $db2_pass);
if ($conn_resource) {
echo 'Connection to database succeeded.';
db2_close($conn_resource);
} else {
echo 'Connection to database failed.<br />';
echo 'SQLSTATE: ' . db2_conn_error() . '<br />';
echo 'Message: ' . db2_conn_errormsg(). '<br />';
}
Hope that gets you on the right track.
Thanks,
-Dan
Daniel Krook, IBM L2 Certified IT Specialist
Software Engineer, Advanced Cloud Technology, GTS, IBM
Cloud Architecture, Java EE, PHP, BlackBerry, DB2 & Solaris Certified
Charles W Buege <cbuege@xxxxxxxxxxxxx> wrote on 05/11/2012 09:48:08 AM:
> From: Charles W Buege <cbuege@xxxxxxxxxxxxx>
> To: php-db@xxxxxxxxxxxxx
> Date: 05/11/2012 09:52 AM
> Subject: Installing IBM DB2 drivers onto an Apache Server
> under Fedora 16 x64 to access IBM POWER7 DB2 via PHP....
>
> All -
>
> I know that this topic only vaguely relates to this mailing list,
> but I thought I'd start here. If anyone has a better location for
> me to look at for this information, please feel free to tell me.
>
> Okay, here's my scenario. We are an IBM POWER7 shop and have
> several instances of Apache running on our POWER7 for customer
> information lookup, part ordering, etc. What I am attempting to do
> is setup a web server as a virtual machine in Fedora 16 as a front-
> end to all of these servers to perform the following tasks:
> - centralized access to all of the sites - a table of contents/central portal
> - a server that, when the POWER7 is down for backup and/or
> maintenance, it can provide a 'Temporarily Out Of Service' message
> to any users attempting to access these sites with a message of 'The
> system is down for (whatever the reason). It will be back up by (time).'
> - Another development/deployment platform other than our POWER7 for
> testing/learning/etc. since setting up a virtual host on Apache
> under Linux means that it is something that I can do instead of
> involving our POWER7 administrator since he is as busy as I am
>
> Here is what I have done so far. I've got the Apache running on the
> Fedora 16 box no problem. I'm getting good phpinfo() results, so
> all good there. I'm trying to follow IBM's instructions for getting
> DB2 drivers using the following sites:
> Setting up the PHP environment on Linux or UNIX - http://
> publib.boulder.ibm.com/infocenter/db2luw/v9r7/index.jsp?topic=%
> 2Fcom.ibm.swg.im.dbclient.php.doc%2Fdoc%2Ft0011926.html
> which lead me to this page to get the IBM Data Server Driver Package
> mentioned in bullet point three
> Download initial Version 10.1 clients and drivers - http://
> www-01.ibm.com/support/docview.wss?uid=swg21385217
> which I did download and that page sent me to here:
> Installing IBM Data Server Driver Package (Linux and UNIX) - http://
> publib.boulder.ibm.com/infocenter/db2luw/v9r7/index.jsp?topic=%
> 2Fcom.ibm.swg.im.dbclient.install.doc%2Fdoc%2Ft0054799.html
> where, after reading this page, I attempted to run the
> installDSDriver which apparently requires ksh to be installed to run
> so I downloaded and installed the ksh package.
> Now, at this point, I will freely admit that I am not 100% sure what
> is meant by step #3 on this page: For the Java and ODBC/CLI drivers
> (which it says are needed for the PHP drivers), uncompress the
> driver file into your chosen install directory on the target machine.
> It's the verbage of 'chosen install directory' that is throwing me.
> So, in an effort to move ahead and get the ODBC/CLI drivers loaded,
> I went on to this page:
> Installing the IBM Data Server Driver for ODBC and CLI - http://
> publib.boulder.ibm.com/infocenter/db2luw/v9r7/index.jsp?topic=%
> 2Fcom.ibm.db2.luw.apdv.cli.doc%2Fdoc%2Ft0023864.html
> At this point, I read these instructions which seemed to confuse me
> even more since I wasn't working with a DB2 Version 9 cd at all and
> thought I'd post to this list to see if anyone has any suggestions/
> recommendations.
>
> In an effort to answer some questions in advance, here's some things
> that I can offer:
> Why am I using Fedora 16?
> We are an electronics manufacturing company and that is what my
> Engineering department uses for their development purposes. I am
> not married to using Fedora 16 - I have been working with
> Engineering a lot in the last several months performing
> virtualizations of several Linux boxes so in an effort to be of
> better assistance to them, I decided to start this project using
> Fedora and have learned a lot.
> Am I open to other linux distros?
> Sure. You've got another suggestion, please throw it my way. I'm
> MORE than willing to listen
> What are the specs of the Fedora box I'm using?
> It's a Dell desktop, x64 with 8 Gig of RAM and a 2.8 (I'm pretty
> sure) GHz processor. It's got a 2TB hard drive, but I doubt that'll matter
>
> If anyone would like any additional clarification/details or does
> have any recommendations, please feel free to e-mail me directly as
> I do only get this list in its digest form.
>
> Thanks in advance,
> Charles Buege
>
>
>
>
>
>
> _____________________________________________________________________
> Charles Buege | The Morey Corporation | Research and Development/IT
> Special Projects
> 100 Morey Drive | Woodridge, IL 60517
> Phone: 630-754-2181 | Fax: 630-754-2581 | Cell: 630-605-2077
> cbuege@xxxxxxxxxxxxx | www.moreycorp.com
>
> [image removed]
> Follow us on Twitter! http://twitter.com/Moreycorp
>
>
>
> This e-mail, including attachments, may contain information that is
> confidential and/or proprietary, and may only be used by the person
> to whom this email is addressed. If the recipient of this e-mail is
> not the intended recipient or an authorized agent, the reader is
> hereby notified that any dissemination, distribution, or copying of
> this e-mail is prohibited. If this e-mail has been delivered to you
> in error, please notify the sender by replying to this message and
> deleting this e-mail immediately.
This e-mail, including attachments, may contain information that is confidential and/or proprietary, and may only be used by the person to whom this email is addressed. If the recipient of this e-mail is not the intended recipient or an authorized agent, the reader is hereby notified that any dissemination, distribution, or copying of this e-mail is prohibited. If this e-mail has been delivered to you in error, please notify the sender by replying to this message and deleting this e-mail immediately.
