Hi there,

I'm a newbie to ingres database, and I am using ingres 2006 X86
64bits. Here is what I want to do:

First I want to install ingres into a SUSE Linux Virtual machine. I
use the command line "sudo ingress_express_install.sh" to do this,
everything works fine here.

After the installation, I created a new database using command
"createdb mytestdb". Then I want to access this new database from
clinet application. Here I want to develop a simple dotNet application
to access, update the newly created database. After reading the
"Connectivity Guide", I found I should set up the virtual node and so
on. Am I right here? After the netutil set up process, ingres
complains "E_GC2819_NTWK_CONNECTION_FAIL Unable to establish network
connection: See errlog.log for detail." and the errlog.log output as
following:
"sles10 ::[27802, 00002b8b4f6cedc0]: Wed Apr 8 12:22:20 2009
I_TP0232_BEGIN_PHASE1 2PC/RECOVERY : Phase 1 begins.
sles10 ::[27802, 00002b8b4f6cedc0]: Wed Apr 8 12:22:20 2009
I_TP0207_BEGIN_CDB_REC 2PC/RECOVERY : Building CDB list for
recovery begins.
sles10 ::[20047, ffffffff]: Wed Apr 8 12:22:20 2009
E_RE0001_RMCMD_UP Visual DBA RMCMD Server -- Normal Startup.
sles10 ::[58926 IIGCC, 0000000000000001]: Wed Apr 8 12:30:41 2009
E_GC2809_NTWK_CONNECTION_FAIL Network connection failed for
protocol TCP_IP, to node 192.168.1.33, port ax0; status follows.
sles10 ::[58926 IIGCC, 0000000000000001]: Wed Apr 8 12:30:41 2009
E_CLFE05_BS_CONNECT_ERR Unable to make outgoing connection.
sles10 ::[58926 IIGCC, 0000000000000001]: System communication error:
Transport endpoint is not connected.
sles10 ::[58926 IIGCC, 0000000000000000]: Wed Apr 8 12:41:31 2009
E_GC2809_NTWK_CONNECTION_FAIL Network connection failed for
protocol TCP_IP, to node 192.168.1.33, port ax0; status follows.
sles10 ::[58926 IIGCC, 0000000000000000]: Wed Apr 8 12:41:31 2009
E_CLFE05_BS_CONNECT_ERR Unable to make outgoing connection.
sles10 ::[58926 IIGCC, 0000000000000000]: System communication error:
Transport endpoint is not connected.

Any advice or comments are highly appriciated.

Guoqiang Yang

On Apr 8, 2009, at 7:43 AM, IngresBeginner wrote:

For starters, go into CBF (configuration tool), and make sure that the
startup count for the DAS server is 1, and the startup count for the
Star server is zero. (You don't need star, and apparently it's trying
to start up.)

The vnode stuff applies to connections made across Ingres-Net.
I believe that dot-net uses the DAS (data access server) instead
of Ingres-Net. I'm not sure of the connection details though,
since I try to stay hidden inside the dbms server. :-)

Hint: if you have trouble with CBF, which is a character
forms based tool, try setting the shell environment variable
TERM_INGRES to konsolel -- that should work on suse with KDE.

Karl

Hi Guoqiang,

Have you tested the vnode you set up?
It doesn't look like the port on the server is correct. The default
install should set up an installation labelled 'II', your vnode from the
client box should mention the 'II' as the 'Listen Address'.

Martin Bowes

-----Original Message-----
From: info-ingres-bounces (AT) kettleriver...ting (DOT) com
[mailto:info-ingres-bounces (AT) kettleriverconsulting (DOT) com] On Behalf Of
IngresBeginner
Sent: 08 April 2009 12:43
To: info-ingres (AT) kettleriverconsulting (DOT) com
Subject: [Info-Ingres] connect to remote ingres server

Hi there,

I'm a newbie to ingres database, and I am using ingres 2006 X86
64bits. Here is what I want to do:

First I want to install ingres into a SUSE Linux Virtual machine. I
use the command line "sudo ingress_express_install.sh" to do this,
everything works fine here.

After the installation, I created a new database using command
"createdb mytestdb". Then I want to access this new database from
clinet application. Here I want to develop a simple dotNet application
to access, update the newly created database. After reading the
"Connectivity Guide", I found I should set up the virtual node and so
on. Am I right here? After the netutil set up process, ingres
complains "E_GC2819_NTWK_CONNECTION_FAIL Unable to establish network
connection: See errlog.log for detail." and the errlog.log output as
following:
"sles10 ::[27802, 00002b8b4f6cedc0]: Wed Apr 8 12:22:20 2009
I_TP0232_BEGIN_PHASE1 2PC/RECOVERY : Phase 1 begins.
sles10 ::[27802, 00002b8b4f6cedc0]: Wed Apr 8 12:22:20 2009
I_TP0207_BEGIN_CDB_REC 2PC/RECOVERY : Building CDB list for
recovery begins.
sles10 ::[20047, ffffffff]: Wed Apr 8 12:22:20 2009
E_RE0001_RMCMD_UP Visual DBA RMCMD Server -- Normal Startup.
sles10 ::[58926 IIGCC, 0000000000000001]: Wed Apr 8 12:30:41 2009
E_GC2809_NTWK_CONNECTION_FAIL Network connection failed for
protocol TCP_IP, to node 192.168.1.33, port ax0; status follows.
sles10 ::[58926 IIGCC, 0000000000000001]: Wed Apr 8 12:30:41 2009
E_CLFE05_BS_CONNECT_ERR Unable to make outgoing connection.
sles10 ::[58926 IIGCC, 0000000000000001]: System communication error:
Transport endpoint is not connected.
sles10 ::[58926 IIGCC, 0000000000000000]: Wed Apr 8 12:41:31 2009
E_GC2809_NTWK_CONNECTION_FAIL Network connection failed for
protocol TCP_IP, to node 192.168.1.33, port ax0; status follows.
sles10 ::[58926 IIGCC, 0000000000000000]: Wed Apr 8 12:41:31 2009
E_CLFE05_BS_CONNECT_ERR Unable to make outgoing connection.
sles10 ::[58926 IIGCC, 0000000000000000]: System communication error:
Transport endpoint is not connected.

Any advice or comments are highly appriciated.

Guoqiang Yang
_______________________________________________
Info-Ingres mailing list
Info-Ingres (AT) kettleriverconsulting (DOT) com
http://www.kettleriverconsulting.com...fo/info-ingres

On 8 Dub, 13:43, IngresBeginner <guoqiangyang.... (AT) gmail (DOT) com> wrote:
Hi,
you don't need vnode and ingres Net. dotNet applications use DAS
server only. Make sure you'v started das server (iigcd process in
linux). And if you have default installation, you can connect to II7
port of your SLES box and connection string may look like
IngresConnection conn = new IngresConnection
("host=sles;database=test;User
ID=ingres;Password=ingres_pass_on_sles");
You can also check firewall on SLES (rcSuSEfirewall2 status) - port
II7 is unix port 21071(?) and may be closed by firewall.

Hi Yang,

Take care also your TCP port is not bloked by a firewall.

grep TCP_IP $II_SYSTEM/ingres/files/errlog.log
to read the TCP_IP ports (for XX7 if you talk about DAS, XX for Ingres/NET,
where XX is your installation code - ie ingprenv II_INSTALLATION)

Hope this help,
--
Jean-Pierre Zuate
La Fage Conseil
+33(0)6 11 40 11 09
jean-pierre.zuate (AT) lafageconseil (DOT) fr
http://lafageconseil.fr/


2009/4/8 IngresBeginner <guoqiangyang.nku (AT) gmail (DOT) com>