Join / Log in
I am trying to link an Informix 14.10.FC3 instance running on a RHEL7 server to an Informix 12.10.FC4 instance running on a Solaris 10 server. (I previously had both servers connected, but using the same Informix 12.10)IBM Informix Dynamic Server Version 14.10.FC3 -- On-Line -- Up 03:23:42 -- 3946412 KbytesIBM Informix Dynamic Server Version 12.10.FC4 -- On-Line -- Up 01:49:52 -- 7032832 KbytesI can connect in both directions using DBACCESS, so the servers can talk to each other.I am attempting to define a new server connection, which will be the original for both systems:cdr define server --connect=i14_srepl_tcp --init g_upg_srepl --nonroot --sync=g_upg_scliOn the REHL7 side (i14_srepl_tcp & g_upg_srepl), I amgetting:14:05:18 CDR connection to server lost, id 12, name <g_upg_scli>Reason: ASF connect error (-27002)14:05:18 CDR GC: operation sync connect failed (error 5).14:05:18 CDR GC: synchronization failed (sync abort, shutting down CDR)On the Solaris side (g_upg_scli), the error is just:14:05:18 (62) connection rejected - no calls allowed for cdracceptif it helps, this is the relevant section of the sqlhosts file on each system:RHEL7:----------g_upg_srepl group - - i=42i14_srepl_tcp onsoctcp rh7data 5142 g=g_upg_sreplg_upg_scli group - - i=12sylvestercfp_tcp onsoctcp clientdata 5196 g=g_upg_scliSolaris:----------g_upg_scli group - - i=12sylvestercfp_tcp onsoctcp clientdata 5196 g=g_upg_sclig_upg_srepl group - - i=42i14_srepl_tcp onsoctcp rh7data 5142 g=g_upg_sreplThanks Much,Michael Hoffman
Can you bi-directional connect without a password from dbaccess using the group/informix servers name ?
But 27002 is engine is Queisicent – needs to be online
Hi Paul,Yes, I can connect bi-directionally via dbaccess without a password.
The Quiescent error message is a red herring. Both instances are Online. (That's why I included the onstat - messages :-) )Thanks,Mike
Is the 'master' defined ?
We have a WINNER!!!!! Thanks Jacques!!!
Jacques had issues replying to the thread, so he replied privately. I'm dropping it here so others can learn from my error.---------------Message From: Jacques RenautFor some reason it doesn't seem like I can respond to your post, so I'm going to try and reply privately.I think the issue is simply that you haven't done the cdr define server 1st on server that you are trying to use as the sync server in the "cdr define server" command you listed. I believe if you do the define server on that machine 1st, then the command you are trying to run will then work. So if you are using the sync in your cdr define server command, that server needs to already have been added.------------------------------Jacques Renaut------------------------------
I just attempted something similar to what I think you are doing. I think the issue is you are trying to define the server first on server i14_srepl_tcp/g_upg_srepl, but you are telling it the sync server is going to be sylvestercfp_tcp/g_upg_scli, but you haven't done the cdr define server on sylvestercfp_tcp/g_upg_scli.from my test doing something similar (without the --nonroot)cdr define server --init g_er2 --sync=g_er1from MSGPATH of g_er1:09:06:02 (93) connection rejected - no calls allowed for cdracceptfrom MSGPATH of g_er2:09:05:59 DDR Log Snooping - Snooping started in log 19509:06:01 CDR: WARNING: Server is configured with /tmp as the ATS and RIS directory.If /tmp is configured as the swap space of this machine then it canaffect the machine's performance if ER generated a large amount offiles in this directory.09:06:02 CDR connection to server lost, id 101, name <g_er1>Reason: ASF connect error (-27002)09:06:02 CDR GC: operation sync connect failed (error 5).09:06:02 CDR GC: synchronization failed (sync abort, shutting down CDR)09:06:03 CDR NIF Shutdown: connections all shutdown.09:06:03 CDR The NIF sub-component has shut down.09:06:04 DDR Log Snooping - Shutdown09:06:04 CDR shutdown completeSo in my case, I would need to do my cdr define server 1st on g_er1.