RE: Linux testing issue - sformbld

newcx:/home/jgoldrick # dbaccess cars - <<! > info tables; > ! Database selected. Table name aa_rec aa_table ac_table acad_cal_rec acad_group_table acad_stat_table acadsum_rec accesscontrol accommod_rec accommod_table accomp_rec accomp_table acct_table acctmeth_table acgrant_rec ack_table acq_rec act_table action_table acttype_table I am running as root right now. I am still getting our third party environment setup. -----Original Message----- From: ids-bounces@iiug.org on behalf of Jonathan Leffler Sent: Tue 3/8/2011 7:09 PM To: ids@iiug.org Subject: Re: Linux testing issue - sformbld [22999] On Tue, Mar 8, 2011 at 13:36, Goldrick, Jim <jgoldrick@judsonu.edu> wrote: > I am testing moving our system from HPUX to Linux. sformbld and > sperform, and now DBD-Informix give the error below. Dbaccess works > fine. > So DB-Access is able to connect via the shared memory connection? If so, so should other ESQL/C-based programs. > newcx:/usr/bin # sformbld -d > I worry about people running as root when I see a hash (#) in the prompt... IBM INFORMIX-SQL Version 7.50.UC4 > Copyright (C) International Business Machines Corporation 1984-2008. > > Software Serial Number RDS#R000000 > > Enter desired name for the form: tdoc > Enter the name of the database used by the form: cars > > The appl process cannot connect to the database server newcx_shm. > See error number -25588. > Database cars not found or not correct format > newcx:/usr/bin # > Does this work? dbaccess cars - <<! info tables; ! Here is the sqlhosts. > # > newcx_shm onipcshm newcx newcx > newcx onsoctcp localhost istarcarsi > istarcarsi onsoctcp newcx istarcarsi> > Since shared memory connections are inherently for the local host, try using localhost instead of newcx for the 3rd column of the first line of the sqlhosts file. Ideally, you should be able to use the host name too, but this will (probably) get you going. > FWIW, I am running in a VM on my laptop, so nslookup cannot find the > server newcx, but it is in the hosts file. > > 127.0.0.1 localhost > 127.0.0.2 newcx.site newcx > > # special IPv6 addresses > ::1 localhost ipv6-localhost ipv6-loopback > > fe00::0 ipv6-localnet > > ff00::0 ipv6-mcastprefix > ff02::1 ipv6-allnodes > ff02::2 ipv6-allrouters > ff02::3 ipv6-allhosts > > Any ideas would be greatly appreciated. > -- Jonathan Leffler <jonathan.leffler@gmail.com> #include <disclaimer.h> Guardian of DBD::Informix - v2008.0513 - http://dbi.perl.org "Blessed are we who can laugh at ourselves, for we shall never cease to be amused." --0023545bd4d82f3520049e025e33 ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

One of the other schools using our third party software has informed me that they shipped 32 bit sformbld and sperform with the 64 bit server. I was not aware of this. Thanks for your help and sorry for the time. -----Original Message----- From: ids-bounces@iiug.org on behalf of Goldrick, Jim Sent: Tue 3/8/2011 8:04 PM To: ids@iiug.org Subject: RE: Linux testing issue - sformbld [23002] newcx:/home/jgoldrick # dbaccess cars - <<! > info tables; > ! Database selected. Table name aa_rec aa_table ac_table acad_cal_rec acad_group_table acad_stat_table acadsum_rec accesscontrol accommod_rec accommod_table accomp_rec accomp_table acct_table acctmeth_table acgrant_rec ack_table acq_rec act_table action_table acttype_table I am running as root right now. I am still getting our third party environment setup. -----Original Message----- From: ids-bounces@iiug.org on behalf of Jonathan Leffler Sent: Tue 3/8/2011 7:09 PM To: ids@iiug.org Subject: Re: Linux testing issue - sformbld [22999] On Tue, Mar 8, 2011 at 13:36, Goldrick, Jim <jgoldrick@judsonu.edu> wrote: > I am testing moving our system from HPUX to Linux. sformbld and > sperform, and now DBD-Informix give the error below. Dbaccess works > fine. > So DB-Access is able to connect via the shared memory connection? If so, so should other ESQL/C-based programs. > newcx:/usr/bin # sformbld -d > I worry about people running as root when I see a hash (#) in the prompt... IBM INFORMIX-SQL Version 7.50.UC4 > Copyright (C) International Business Machines Corporation 1984-2008. > > Software Serial Number RDS#R000000 > > Enter desired name for the form: tdoc > Enter the name of the database used by the form: cars > > The appl process cannot connect to the database server newcx_shm. > See error number -25588. > Database cars not found or not correct format > newcx:/usr/bin # > Does this work? dbaccess cars - <<! info tables; ! Here is the sqlhosts. > # > newcx_shm onipcshm newcx newcx > newcx onsoctcp localhost istarcarsi > istarcarsi onsoctcp newcx istarcarsi> > Since shared memory connections are inherently for the local host, try using localhost instead of newcx for the 3rd column of the first line of the sqlhosts file. Ideally, you should be able to use the host name too, but this will (probably) get you going. > FWIW, I am running in a VM on my laptop, so nslookup cannot find the > server newcx, but it is in the hosts file. > > 127.0.0.1 localhost > 127.0.0.2 newcx.site newcx > > # special IPv6 addresses > ::1 localhost ipv6-localhost ipv6-loopback > > fe00::0 ipv6-localnet > > ff00::0 ipv6-mcastprefix > ff02::1 ipv6-allnodes > ff02::2 ipv6-allrouters > ff02::3 ipv6-allhosts > > Any ideas would be greatly appreciated. > -- Jonathan Leffler <jonathan.leffler@gmail.com> #include <disclaimer.h> Guardian of DBD::Informix - v2008.0513 - http://dbi.perl.org "Blessed are we who can laugh at ourselves, for we shall never cease to be amused." --0023545bd4d82f3520049e025e33 ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.