开发者

Unknown user error when trying to set up replication with informix

开发者 https://www.devze.com 2023-01-16 19:47 出处:网络
I am on a linux system, logged in as the informix user. I have the following environment variables set:

I am on a linux system, logged in as the informix user. I have the following environment variables set:

INFORMIXDIR=/opt/IBM/informix
INFORMIXSQLHOSTS=/opt/IBM/informix/etc/sqlhosts.mydb
INFORMIXSERVER=rep_0

The contents of sqlhosts.mydb are as follows:

g_rep_0         group           -               -       i=0
rep_0           onsoctcp        svr0            30100   g=g_rep_0

g_rep_1         group           -               -       i=1
rep_1           olsoctcp        svr1            30101   g=g_rep_1

I am trying to run the command cdr define server --init g_rep_0 to set up g_rep_0 as the replication master, but get the following error:

connect to rep_0 failed 
Incorrect password or user rep_0 is not known on the database server.
 (-951)
command failed -- unable to connect to server specified  (5)

Can anyone suggest what I might be doing wrong?

edit

Looking in the log I got an error:

10:26:36  CDR GC: o开发者_如何学运维peration error reporting severe error message failed (error 62).
10:30:00  SCHAPI: [Save SQL Trace 27-550] Error -206 The specified table (mon_syssqltrace) is not in the database.
10:30:00  SCHAPI: [Save SQL Trace 27-550] Error -111 ISAM error:  no record found.


This problem turned out to be due to a corrupt database. I re-initialized it by running onmode -ky, oninit -ivyw, and it appears to be fine now.

0

精彩评论

暂无评论...
验证码 换一张
取 消