amitk8
07-08-02, 05:34
| We have installed the OpenLink's Multi-Tier ODBC Drivers ver 4.0 for Progress 9.1C running on the LINUX Redhat 7.2 Server box. The server side installation consisted of the Database Agent for Progress 9.1C and the Request Broker Agent. On the Windows 2000 Client box, we've installed the client side Openlink's generic MT ODBC driver. We used the Database Server Components Configuration Wizard to configure the Database Agent as per the instructions given in the documentation provided for the Driver. After that we started the Request Broker as well as the Database Agent on the Linux Server. Now, when we try creating a connection in the Client (Win 2000) machine using the Client OpenLink MT ODBC Driver ver 4.0, the connection fails inspite of setting all the parameters correctly. On the server side, it says that the RPC call failed, connection has been reset by the peer. Can anybody provide some feedback on how to solve this problem? The contents of the log file in the Linux box are: 14:08:18 DEBUG (mapscode.c:163): cook.pacificebiz.com.au called (192.168.0.62.1254) 14:08:18 INFO (mapscode.c:172): request: domain=Progress 91C database=merlum55 serveropts= 14:08:18 INFO (mapscode.c:174): connectopts= user=sausten opsys=win32 readonly=1 14:08:18 INFO (mapscode.c:176): application=ODBCAD32 processid=316 14:08:18 DEBUG (maprule.c:109): solve mapping: pro91c:merlum55:sausten:msdos:cook.pacificebiz.com .au:ODBCAD32:ro 14:08:18 DEBUG (maprule.c:144): using mapping: pro91c:*:*:*:*:*:* 14:08:18 DEBUG (mapscode.c:246): using [generic_pro91c] ServerProgram=pro91c_sv 14:08:18 DEBUG (mapscode.c:347): connect params: domain=Progress 91c db=merlum55 serveropts=-T /tmp -d mdy -TB 31 -TM 31 -q -NL readonly=1 14:08:18 DEBUG (mapscode.c:349): connectopts= user=sausten opsys=win32 machine=cook.pacificebiz.com.au application=ODBCAD32 14:08:18 DEBUG (proc.c:189): spawning /usr/openlink/bin/pro91c_sv generic_pro91c +debug 14:08:18 DEBUG (mapscode.c:411): asking agent for server handle 14:08:18 DEBUG (mapsglbl.c:304): setting Environment PROGRESS91C 14:08:18 DEBUG (mapsglbl.c:311): change environment 'CURSOR_SENSITIVITY' -> 'LOW' 14:08:18 DEBUG (mapsglbl.c:311): change environment 'DLC' -> '/usr/dlc9' 14:08:18 DEBUG (mapsglbl.c:311): change environment 'PROCFG' -> '/usr/dlc9/progress.cfg' 14:08:18 DEBUG (mapscode.c:433): got it! 14:08:18 DEBUG (mapscode.c:589): asking agent for connection handle 14:08:18 ERROR (mapscode.c:592): internal rpc call failed (Success): RPC: Unable to receive; errno = Connection reset by peer 14:08:18 INFO (mapscode.c:639): rejected sausten@cook.pacificebiz.com.au.ODBCAD32 (unable to contact the requested database agent) We started the Request Broker as root. I'm also pasting below the related contents of the oplrqb.ini file present on the Linux box: [Request Broker] BinaryDirectory = /usr/openlink/bin CommandLine = ;+logfile /tmp/oplrqb.log +debug Protocols = tcp ;MaxAgents = 0 ; if >0, max. # of processes spawned by broker ;MaxConnections = 0 ; if >0, max. # of connections from clients HostNameResolver = Yes ; Resolve IP addresses to hostnames LingerTimeout = 0 ; if >0, time a disconnected agent will linger [Protocol TCP] PingWatchdog = No ; Send check-alive packets PingInterval = 600 ; every <PingInterval> seconds Listen = 5000 ; Port for client connections PortLow = 5000 ; Limits TCP port range - first used port ;PortHigh = 60000 ; last used port ;IPAddress = 127.0.0.1 ; Overrules found interface address [Protocol SPX] SAPBroadcast = No ; Broadcast SAP registration packets SAPInterval = 100 ; every <SAPInterval> seconds SAPServiceType = 0x321F ; with type <SAPServiceType> SAPServiceName = OPENLINK ; and with name <SAPServiceName> [Communications] SendSize = 16000 ; Send buffer size ReceiveSize = 4096 ; Receive buffer size DataEncryption = No ; Crypting of outgoing packets BrokerTimeout = 30 ; Timeout for utilities to contact the broker ReceiveTimeout = 10 ; Timeout for the broker contacting an agent RetryTimeout = 5 ; Initial retry interval -- doubles on failure ; to a maximum of 30 seconds [Security] StartupBy = .* ; Users who can startup oplrqb ShutdownBy = .* ; Users who can shutdown oplrqb ShutdownFrom = localhost.*,127\.0\.0\.1 ; Hostnames that can shutdown ValidUidRange = 0, 50000 ; Valid range for OpSysLogin ;TraceRulebook = /tmp/debug.book ; Write merged rulebook (debug) ;IncludeRulebook = proxy_sv.book ; More than one IncludeRulebook is legal ;IncludeRulebook = generic.book ; More than one IncludeRulebook is legal [Environment PROGRESS91C] ;TABLEVIEW = tableview.dat ; Full path to filename generated by setup.p ;TABLEVIEW_QUALIFIER = Y ; Add owner information to select statement ;INSERT_LOGICAL = Y ; Rewrite character TRUE/FALSE to logical ;UPDATE_LOGICAL = Y ; Rewrite character TRUE/FALSE to logical ;MIN_FIELD_LEN = ; Min length for char field or expression ;MAX_FIELD_LEN = ; Max length for expression ;EXPR_PRECISION = 15 ; Fixed precision for numeric expressions ;EXPR_SCALE = 2 ; Fixed scale for numeric expressions CURSOR_SENSITIVITY = LOW DLC = /usr/dlc9 PROCFG = /usr/dlc9/progress.cfg [Domain Aliases] Progress 91C = pro91c [Database Aliases] demo = demo [Opsys Aliases] java = java win32|msdos = msdos .* = other [User Aliases] scott|system = insecure ^$ = blank [Machine Aliases] [Application Aliases] MSACCESS = jet MSQRY.*|EXCEL|WORD = msoffice [Mapping Rules] ;*:*:blank:*:*:*:rw = reject You should specify a username and password *:*:Admin:msdos:*:jet:* = reject Admin user account is not registered pro91c:*:*:*:*:*:* = accept generic_pro91c [generic_pro91c] Description = Default settings for Progress 9.1C agent Program = pro91c_sv Environment = PROGRESS91C ServerOptions = -T /tmp -d mdy -TB 31 -TM 31 -q -NL ; Do not use a different -d argument Directory = /usr/sentai55/db ReUse = never ;CommandLine = ;ConnectOptions = ;Database = ;ReadOnly = Yes Database = merlum55 UserID = sausten Password = (removed) ServerType = Progress 91c Host = trax [Persistent Services] Configurator = www_sv [www_sv] Program = w3config/www_sv Directory = w3config CommandLine = [Environment WWW_SV] |