Re: installing DBD-Informix on fedora 6
- From: oliverj@xxxxxxxxxxxxxxxxxxx (Oliver Howe)
- Date: Tue, 30 Jan 2007 13:59:57 +0000
can i ask does anyone have it working properly on fedora6 ?
if so, can you let me know if you did it the same way as i am trying?
thanks,
oliver
this is what I do on fedora 4
perl -MCPAN -e 'install Bundle::DBI'
groupadd -g 300 informix
useradd -u 200 -g 300 informix
source /etc/profile.d/informix.sh - see below for this files content
vi /etc/services - i add "sqlexec 1526/tcp informix" at the bottom
mkdir /opt/informix
chown informix.informix /opt/informix/
cd /opt/informix/
tar xvf clientsdk.2.90.UC2.LINUX.tar
cd clientsdk.2.90.UC2.LINUX.tar
./install_rpm
cd
tar xvzf DBD-Informix-2005.02.tar.gz
cp /opt/informix/etc/sqlhosts.std /opt/informix/etc/sqlhosts
vi /opt/informix/etc/sqlhosts - i add the db server here
perl rmautoinst.pl Makefile.PL | perl -
make
make install
cat /etc/profile.d/informix.shexport INFORMIXDIR="/opt/informix"
export INFORMIXSERVER=pmuk2
export LD_LIBRARY_PATH=/opt/informix/lib:/opt/informix/lib/esql/
PATH=/opt/informix/bin:${PATH}
export ACCEPTLICENSE=yes
export DBANSIWARN=""
export DBDATE="Y4MD-"
export CLIENT_LOCALE=en_us.utf8
export DB_LOCALE=en_us.utf8
On Mon, 29 Jan 2007 21:20:26 -0800 , "Jonathan Leffler" <jonathan.leffler@xxxxxxxxx> wrote:
On 1/29/07, Oliver Howe <oliverj@xxxxxxxxxxxxxxxxxxx> wrote:
on the client i can telnet to the server on port 1526 as the user informix.no i dont see anything from that server when running the esqltest. but
i have stopped iptables and ip6tables on the client
can you snoop on the server to see if any packets reach the interface
at all when running esqltest?
there is some stuff that reaches it :-
[...snip...]
which seems to be referring to checking the hostnames?
hmmail2.uk1.bibliotech.net is the client (running fedora 6) and
dbpmuk2.uk1.bibliotech.net is the db server
Can you do "CREATE TABLE dbd_ix_esqltest (Col01 INTEGER NOT NULL);"
from dbaccess on the server in the stores database as the appropriate
user?
yes
This is a key issue (connecting with DB-Access on the server machine). The
error 107 (discussed in previous emails in this thread) has me a bit
puzzled. Does Fedora Core 6 have an error value (from errno.h) for 107? If
so, does the associated message drop any hints? Taken at face value, it
appears that someone has the database locked in exclusive mode (though I'd
like to think the error would say that more clearly). Did the process
(session) that created the database complete yet? Classically, you get
exclusive access when you create a database, up until you terminate the
session that created the DB.
When you connect using DB-Access, you are using the same server name and
sqlhosts values; you aren't suddenly switching to shared memory connections
or anything like that?
You're using CSDK 2.90.UC2; that's good. Close enough to the most recent
version that it is unlikely to be the cause of the trouble.
You seem to be connecting to IDS as either root or informix - frankly, you
should do neither. Treat them both with extreme caution - they are just
about equally powerful with respect to IDS. I never do things like building
DBD::Informix as either informix or root; I'd find (or create) another user
to do the work as. If I actually needed to install DBD::Informix as root,
I'd use the privileges then, but only then.
[Aside: I'm not sure why you feel having DBANSIWARN set is a good idea.]
--
Jonathan Leffler <jonathan.leffler@xxxxxxxxx> #include <disclaimer.h>
Guardian of DBD::Informix - v2005.02 - http://dbi.perl.org
"I don't suffer from insanity - I enjoy every minute of it."
--
Oliver Howe
Senior Systems Administrator
Tel: +44 (0) 79 7420 6484
Fax: +44 (0) 20 7664 7878
Spider Networks - the power behind interactive web communications - www.spider-networks.net
--
Confidentiality Notice: This email is confidential and may also be privileged. If you are not the intended recipient, please notify the sender IMMEDIATELY; you should not copy the email or use it for any purpose or disclose its contents to any other person. General Statement: Any statements made, or intentions expressed in this communication, may not necessarily reflect the view of Spider Networks, that no content herein may be held binding upon Spider Networks or any associate or any associated company unless confirmed by the issuance of a formal contractual document or purchase order.
.
- Follow-Ups:
- Re: installing DBD-Informix on fedora 6
- From: Jonathan Leffler
- Re: installing DBD-Informix on fedora 6
- From: Tielman de Villiers
- Re: installing DBD-Informix on fedora 6
- Prev by Date: Re: Can't call method "prepare" on an undefined value
- Next by Date: RE: Oracle DBD runtime error
- Previous by thread: Re: installing DBD-Informix on fedora 6
- Next by thread: Re: installing DBD-Informix on fedora 6
- Index(es):
Relevant Pages
|
