If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Other > ODBC connection to Progress/Linux

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 07-08-02, 04:34
amitk8 amitk8 is offline
Registered User
 
Join Date: Jul 2002
Location: Sydney Australia
Posts: 1
ODBC connection to Progress/Linux

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]
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On