JBossDeveloper

Yes it was a clean install and main server group didnt  report this, as mentioned only server three having this issue

Yes Steven... I know teiid only be working with ha profile, It is hard-coded in the code itself, that is why I changed profile of other-server-group to ha.

Now Server groups in my domain.xml :-

<server-groups>

        <server-group name="main-server-group" profile="full">

            <jvm name="default">

                <heap size="64m" max-size="512m"/>

            </jvm>

            <socket-binding-group ref="full-sockets"/>

        </server-group>

        <server-group name="other-server-group" profile="ha">

            <jvm name="default">

                <heap size="64m" max-size="512m"/>

            </jvm>

            <socket-binding-group ref="ha-sockets"/>

        </server-group>

    </server-groups>

After changing <socket-binding-group ref="full-ha-sockets"/> to <socket-binding-group ref="ha-sockets"/> form other-server-group I am not getting any error during the start-up or load time of the server.

but code line

connection = DriverManager.getConnection("jdbc:teiid:" + VDBName + "@mm://" + IPAddress + ":" + port + ";", userName, password);

still throws an error:

org.teiid.jdbc.TeiidSQLException: TEIID20020 Error establishing socket to host and port: <IP_Address>:31000. Reason: Connection refused: connect

I am creating object of the class AdminApiClientAccessor by calling AdminApiClientAccessor.getInstance() method which interns returns

new AdminApiClientAccessor()

Code:

private AdminApiClientAccessor clientAccessor = AdminApiClientAccessor.getInstance();

then using clientAccessor I am able to access VDB(s) and their information like is it active or not etc..

I am creating Admin using code line

admin = AdminFactory.getInstance().createAdmin(ModelControllerClient.Factory.create(serverHost, serverPort, cbh));

Thanks Steven....

How should I deal with the error?

org.teiid.jdbc.TeiidSQLException: TEIID20020 Error establishing socket to host and port: <IP_Address>:31000. Reason: Connection refused: connect

Can you outline exactly the steps you did to alter the configuration >

AS7 Cluster Howto - JBoss AS 7.1 - Project Documentation Editor

https://docs.jboss.org/author/display/SWITCHYARD/Domain+Clustering+with+SwitchYard

I have mentioned in domain.xml file under the tag

<socket-binding-group name="ha-sockets" default-interface="public">

.....

<socket-binding name="teiid-jdbc" port="31000"/>

<socket-binding name="teiid-odbc" port="35432"/>

</socket-binding-group>

port-offset for server3 is 250

did you look at the server3 log to confirm what port it's using >

Yes it is 31250, for the teiid instance on master when I access teiid using this port number I am able to make the connection to the database; as I am using mod_cluster I need to access teiid port irrespective of the teiid instance I mean whether its a master or slave, but now when I shut down the master I am not able to access the teiid because slave teiid instance is running on a different port.

Yes, right...

When there is both node connected mod_cluster-manager status page looks like:

mod_cluster/1.3.1.Final

Auto Refresh show DUMP output show INFO output

Node slave_local:server-three-slave (ajp://<IP_Addr>:8459):

Enable Contexts Disable Contexts Stop Contexts

Balancer: main-server-group,LBGroup: ,Flushpackets: Off,Flushwait: 10000,Ping: 10000000,Smax: 65,Ttl: 60000000,Status: OK,Elected: 0,Read: 0,Transferred: 0,Connected: 0,Load: 100

Virtual Host 1:

Contexts:

/zclusterDemo, Status: ENABLED Request: 0 Disable Stop

Aliases:

localhost

default-host

Node master:server-three (ajp://<IP_Addr>:8259):

Enable Contexts Disable Contexts Stop Contexts

Balancer: main-server-group,LBGroup: ,Flushpackets: Off,Flushwait: 10000,Ping: 10000000,Smax: 65,Ttl: 60000000,Status: OK,Elected: 0,Read: 0,Transferred: 0,Connected: 0,Load: 100

Virtual Host 1:

Contexts:

/zclusterDemo, Status: ENABLED Request: 0 Disable Stop

Aliases:

localhost

default-host

where zclusterDemo is the war file I deployed using admin api. it can be accessible from both the node i.e. when I shutdown the master or vice versa I can still access the zclusterDemo application.