I did have ipv6 switched on, so I tried turning it off but got the same error.
I am going to reinstall the fedora server, without ipv6 this time and try it
again.
On Tue, 30 Jan 2007 17:58:27 -0800 , "Jonathan Leffler" <[EMAIL PROTECTED]>
wrote:
>On 1/30/07, Oliver Howe <[EMAIL PROTECTED]> wrote:
>
>> 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?
>
>
>I asked on another mailing list ([EMAIL PROTECTED] - the International Informix
>User Group) and got at least a couple of positive responses.
>
>One of the answers I got was that maybe GCC 4.1.1 has issues with ESQL/C.
>I've got GCC 4.1.0 on my (old, slow) Sun Ultra 10 (1 CPU @ 333 MHz, 256 MB
>RAM) and haven't noticed problems there; I'm compiling GCC 4.1.1 as I type
>(into Stage2 comparison). I'll know whether that's a platform independent
>part of the problem - are you actually using GCC 4.1.1 in the first place?
>
>There was also mention that error 107 was something like 'end point not
>available' - maybe indicating a networking error -- I'm drafting this in a
>different gmail account from the one that gets the IIUG mailing lists so I
>can't see the exact message.
>
>I am inclined to agree with Tielman's assessment that the problem is as
>likely to be on the database server as on the client, or maybe in the
>networking in between the two. Presumably, you are satisfied that the DB
>server is operational and can be reached from other machines without
>problems.
>
>Are you using IPv6 by any chance?
>
>> 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.sh
>> > export 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" <
>> [EMAIL PROTECTED]> wrote:
>> >On 1/29/07, Oliver Howe <[EMAIL PROTECTED]> wrote:
>> >>
>> >>
>> >> >> no i dont see anything from that server when running the esqltest.
>> but
>> >> on the client i can telnet to the server on port 1526 as the user
>> informix.
>> >> 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.
>>
>
>
>--
>Jonathan Leffler <[EMAIL PROTECTED]> #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.
