**Could not connect to server for database...

davjoh

New Member
When trying to make a multi-user client connection to our ERP Syteline 3.5b02a on Progress 8.2c from a client pc I receive this error "Could not connect to server for database d:\syteline.db\cdal, errno 0. (1432)."...I confirmed that the database servers are running and I can connect as a multi-user client locally on the database server. I have done this successfully several times before over the last few years without any problems on NT4 Server, W2K Server, and 2003 Server Std - the only thing different about this attempt is the databases are on 2003 R2 Server Std.

The Databases are on a stand-alone server SS3 (2003 R2 Std) located in d:\syteline.db. The pf files the clients use are on a separate file server SS2 (2003 Std) located in s:\sytelin3.pf...see attached files.

I have checked and double-checked the hosts, services, ini and pf files both on the server and client, but just can't see why it doesn't connect...unless it has something to do with the security enhancements on 2003 R2? I have tried playing around with permissions to the database folder, but no luck there.

Client Icon Connection Properties -
Target: S:\DLC\bin\prowin32.exe -basekey ini -pf s:\sytelin3.pf\cdalrun.pf -ininame s:\syteline.srv\symixdj.ini -p menu\symix.p

Any help would be greatly appreciated!!
 

Attachments

  • Sytelin3.pf.zip
    5.1 KB · Views: 24

davjoh

New Member
  • CDALRUN.PF
# PF-TYPE = R "cdal Run" no
#
# SESSION,Session-related parameters
-Bt 2000 # min: 10 max: 50000 Specifies the number of blocks in the buffer for temporary tabels.
-D 150 # min: 5 max: 500 The mumber of compiled procedure directory entries.
-TB 4 # min: 1 max: 31 The block size in Kilobytes to allocate when sorting records for reports and when rebuilding indexes.
-TM 28 # min: 1 max: 32 The number of blocks or streams to be simultaneously merged during the sort process.
-inp 5000 # min: x max: 32000 The number of characters allowed in a single statement. The default is 4096.
-mmax 8192 # min: 1 max: 65534 The initial amount of memory allocated for r-code segments in kilobytes.
-nb 255 # min: 20 max: 255 The maximum number of nested blocks.
-q # -q or no entry Search PROPATH directories only on the first use of a procedure.
-rand 2 # min: 1 max: 2 The type of random number generator. 1 = original generator, 2 = to use an alternate.
-yy 1930 # see system administration reference page 4-116.
#
# MAIN,cdal
-db d:\syteline.db\cdal # Physical Database Name; The database to connect to when a Progress session is started; NOT the logical database name.
-ld symix # Logical Database Name; The logical name assigned to the database.
-pls # -pls or no entry Directs progress to store the r-code files locally in temporary files.
-H ss3 # Host Name; The name of the server that runs multi-user Progress sessions.
-N tcp # Network Type; The network communications protocol.
-S cdal3 # Service Name; The name of th service to be used by the broker process on the host machine.
#
# LICENSE,symlic
-db d:\syteline.db\symlic
-N tcp
-H ss3
-S symlic3
#
# CUSTOM2,custom2
-db d:\syteline.db\custom2
-ld custom
-pls
-H ss3
-N tcp
-S custom23
#
# REPORTS,reports
-db d:\syteline.db\reports
-ld reports
-pls
-H ss3
-N tcp
-S reports3


  • CUSTOM2RUN.PF
# PF-TYPE = R "custom2 Run" no
#
# SESSION,Session-related parameters
-Bt 500
-D 150
-TB 4
-TM 15
-inp 5000
-mmax 8192
-nb 255
-q
-rand 2
-yy 1930
#
# MAIN,custom2
-db d:\syteline.db\custom2
-H ss3
-N tcp
-S custom23

  • REPORTSRUN.PF
# PF-TYPE = R "Reports Run" no
#
# SESSION,Session-related parameters
-Bt 500
-D 150
-TB 4
-TM 15
-inp 5000
-mmax 8192
-nb 255
-q
-rand 2
-yy 1930
#
# MAIN,reports
-db d:\syteline.db\reports
-H ss3
-N tcp
-S reports3

  • CDAL.PF
# PF-TYPE = B "cdal Server" no
#
# SESSION,Session-related parameters
-L 8000 # min: 32 max: xxxx
-TB 4 # min: 1 max: 31 The block size in Kilobytes to allocate when sorting records for reports and when rebuilding indexes.
-TM 15 # min: 1 max: 32 The number of blocks or streams to be simultaneously merged during the sort process.
-inp 5000 # min: x max: 32000 The number of characters allowed in a single statement. The default is 4096.
-rand 2 # min: 1 max: 2 The type of random number generator. 1 = original generator, 2 = to use an alternate.
#
# MAIN,cdal
-db d:\syteline.db\cdal # Physical Database Name; The database to connect to when a Progress session is started; NOT the logical database name.
-B 50000
-H ss3 # Host Name; The name of the server that runs multi-user Progress sessions.
-N tcp # Network Type; The network communications protocol.
-S cdal3 # Service Name; The name of the service to be used by the broker process on the host machine.
-Mn 12
-Ma 10
-Mf 20
-Mi 4
-n 160

  • CUSTOM2.PF
# PF-TYPE = B "custom2 Server" no
#
# SESSION,Session-related parameters
-L 5000
-TB 4
-TM 15
-inp 5000
-rand 2
#
# CUSTOM2,custom2
-db d:\syteline.db\custom2
-B 10000
-N tcp
-H ss3
-S custom23
-Mn 12
-Ma 10
-Mf 20
-Mi 4
-n 160

  • REPORTS.PF
# PF-TYPE = B "Reports Server" no
#
# SESSION,Session-related parameters
-L 2000
-TB 4
-TM 15
-inp 5000
-rand 2
#
# REPORTS,reports
-db d:\syteline.db\reports
-B 10000
-N tcp
-H ss3
-S reports3
-Mn 12
-Ma 10
-Mf 20
-Mi 4
-n 160

  • SYMIXDJ.INI
[Startup]
; Progress Configuration Settings
;
V6Display=no
V6FontNumber=15
Keep3dFillinBorder=Yes
AllowDesignMode=no
QueryRunMode=yes
WindowSystem=MS-Windows
;ImmediateDisplay=yes
;UseNative3D=Yes
;Use-3D-Size=Yes
;PopupNoSysDefault=No
;Popup-menu-key=Shift-F10
DefaultFont=System
DefaultFixedFont=FixedSys
DLC=S:\DLC
PROBUILD=S:\DLC\PROBUILD
PROPATH=s:\syteline.srv\mods\dc,s:\syteline.srv\mods,s:\syteline.srv\custom,s:\syteline.srv\mods\triggers,S:\CDALPRG,S:\SYTELINE.srv\PATCH,C:\SYTELINE\IMAGES,S:\SYTELINE.srv,S:\DLC\BIN,S:\DLC\gui,S:\DLC
;
; SyteLine Configuration Settings
; (defaults are shown; remove semi-colon and modify value to customize)
:
;DatabaseDirectory=C:\SyteLine\db
DatabaseDirectory=S:\Sytelin3.pf
OSAllow=priv
;DefaultUser=symix
; Number of records to read at a time into SmartLocalBrowsers:
;BrowseReadAhead=100
BrowseReadAhead=20
; Third-party viewer for [Admin.View Database Logfile]:
;LogViewer=NotePad
; Allowance for translation of tab-labels into verbose languages
;TabExtraChars=0
 

gabriel.flores

New Member
Hi
Check the configuration of the "new" Windows Firewall, now enabled by default in 2003 Server. This can avoid the connection via TCP ports required for Progress.
 

davjoh

New Member
I enabled Windows Firewall and added the ports (from the services file for each of the databases), prowin32.exe, and _mprosrv.exe to the exception list then shutdown and restarted the databases.....now (from the client) it trys to make the connection about 1:30 seconds longer than before, but still gives the same error. I also stopped the TrendMicro Officescan services...but still no luck.
 

gabriel.flores

New Member
When you connect a database in Client-server mode, the port specified by -S is the first of the ports used, then Progress start a "server" process wich use another TCP Port. You can see the port that is used for each server in the database log file ("Starting server x for database in port nnnn") and you can adjust these ports with the -minport and -maxport parameters.
 

davjoh

New Member
  • SERVICES file
#
# The following are SyteLine databases. Last line must be blank!!!
#
EXEC 19100/tcp # EXEC server
cdal 19300/tcp # cdal server
cdalcfg 19350/tcp # cdalcfg server
dev 19400/tcp # development server
devcfg 19450/tcp # development cfg server
custom2dev 19500/tcp # custom2 development server
reportsdev 19550/tcp # reports development server
custom2 19850/tcp # custom2 server
reports 48000/tcp # reports server
apdb2_99 49150/tcp
custom2_99 49200/tcp
symlic 49250/tcp
dummy 49400/tcp # dummy server
dumcfg 49450/tcp # dummy cfg server
custom2dum 49500/tcp # custom2dum dummy server
reportsdum 49550/tcp # reportsdum dummy server
symlicdum 49600/tcp # symlicdum dummy server
cdal3 20100/tcp
custom23 20150/tcp # custom23 dummy server
reports3 20200/tcp # reports3 dummy server
symlic3 20250/tcp # symlic3 dummy server


  • SYMLIC Log file
Wed Jan 31 18:34:34 2007
18:34:34 BROKER 0: Multi-user session begin. (333)
18:34:37 BROKER 0: Started for symlic using tcp, pid 2520. (5644)
18:34:37 BROKER 0: PROGRESS Version 8.2C on WINNT. (4234)
18:34:37 BROKER 0: Server started by syteline on CON:. (4281)
18:34:37 BROKER 0: Physical Database Name (-db): d:\syteline.db\symlic. (4235)
18:34:37 BROKER 0: Database Type (-dt): PROGRESS. (4236)
18:34:37 BROKER 0: Direct I/O (-directio): Not Enabled. (4238)
18:34:37 BROKER 0: Number of Database Buffers (-B): 1000. (4239)
18:34:37 BROKER 0: Excess Shared Memory Size (-Mxs): 16431. (4240)
18:34:37 BROKER 0: Current Size of Lock Table (-L): 5024. (4241)
18:34:37 BROKER 0: Hash Table Entries (-hash): 317. (4242)
18:34:37 BROKER 0: Current Spin Lock Tries (-spin): 0. (4243)
18:34:37 BROKER 0: Crash Recovery (-i): Enabled. (4244)
18:34:37 BROKER 0: Delay of Before-Image Flush (-Mf): 20. (4245)
18:34:37 BROKER 0: Before-Image File Name (-g): (4246)
18:34:37 BROKER 0: Before-Image File I/O (-r -R): Reliable. (4247)
18:34:37 BROKER 0: Before-Image Truncate Interval (-G): 60. (4249)
18:34:37 BROKER 0: Before-Image Cluster Size: 512. (4250)
18:34:37 BROKER 0: Before-Image Block Size: 8192. (4251)
18:34:37 BROKER 0: Number of Before-Image Buffers (-bibufs): 5. (4252)
18:34:37 BROKER 0: After-Image File Name (-a): Not Enabled. (4253)
18:34:37 BROKER 0: After-Image Stall (-aistall): Not Enabled. (4254)
18:34:37 BROKER 0: After-Image Block Size: 8192. (4255)
18:34:37 BROKER 0: Number of After-Image Buffers (-aibufs): 1. (4256)
18:34:37 BROKER 0: Maximum Number of Clients Per Server (-Ma): 10. (4257)
18:34:37 BROKER 0: Maximum Number of Servers (-Mn): 13. (4258)
18:34:37 BROKER 0: Minimum Clients Per Server (-Mi): 4. (4259)
18:34:37 BROKER 0: Maximum Number of Users (-n): 161. (4260)
18:34:37 BROKER 0: Host Name (-H): ss3. (4261)
18:34:37 BROKER 0: Service Name (-S): symlic. (4262)
18:34:37 BROKER 0: Network Type (-N): tcp. (4263)
18:34:37 BROKER 0: Character Set (-cpinternal): iso8859-1. (4264)
18:34:37 BROKER 0: Stream (-cpstream): iso8859-1. (4265)
18:34:37 BROKER 0: Parameter File: C:\symwork\SYM9516.tmp. (4282)
18:34:37 BROKER 0: Minimum Port for Auto Servers (-minport): 3000. (5648)
18:34:37 BROKER 0: Maximum Port for Auto Servers (-maxport): 5000. (5649)
18:35:02 SRV 1: Started on port 3002 using tcp, pid 1436. (5646)
  • CDAL Log File
Wed Jan 31 18:34:44 2007
18:34:44 BROKER 0: Multi-user session begin. (333)
18:34:44 BROKER 0: Started for cdal using tcp, pid 520. (5644)
18:34:44 BROKER 0: PROGRESS Version 8.2C on WINNT. (4234)
18:34:44 BROKER 0: Server started by syteline on CON:. (4281)
18:34:44 BROKER 0: Physical Database Name (-db): d:\syteline.db\cdal. (4235)
18:34:44 BROKER 0: Database Type (-dt): PROGRESS. (4236)
18:34:44 BROKER 0: Direct I/O (-directio): Not Enabled. (4238)
18:34:44 BROKER 0: Number of Database Buffers (-B): 50000. (4239)
18:34:44 BROKER 0: Excess Shared Memory Size (-Mxs): 16431. (4240)
18:34:44 BROKER 0: Current Size of Lock Table (-L): 8000. (4241)
18:34:44 BROKER 0: Hash Table Entries (-hash): 13063. (4242)
18:34:44 BROKER 0: Current Spin Lock Tries (-spin): 0. (4243)
18:34:44 BROKER 0: Crash Recovery (-i): Enabled. (4244)
18:34:44 BROKER 0: Delay of Before-Image Flush (-Mf): 20. (4245)
18:34:44 BROKER 0: Before-Image File Name (-g): (4246)
18:34:44 BROKER 0: Before-Image File I/O (-r -R): Reliable. (4247)
18:34:44 BROKER 0: Before-Image Truncate Interval (-G): 60. (4249)
18:34:44 BROKER 0: Before-Image Cluster Size: 512. (4250)
18:34:44 BROKER 0: Before-Image Block Size: 8192. (4251)
18:34:44 BROKER 0: Number of Before-Image Buffers (-bibufs): 5. (4252)
18:34:44 BROKER 0: After-Image File Name (-a): Not Enabled. (4253)
18:34:44 BROKER 0: After-Image Stall (-aistall): Not Enabled. (4254)
18:34:44 BROKER 0: After-Image Block Size: 8192. (4255)
18:34:44 BROKER 0: Number of After-Image Buffers (-aibufs): 1. (4256)
18:34:44 BROKER 0: Maximum Number of Clients Per Server (-Ma): 10. (4257)
18:34:44 BROKER 0: Maximum Number of Servers (-Mn): 13. (4258)
18:34:44 BROKER 0: Minimum Clients Per Server (-Mi): 4. (4259)
18:34:44 BROKER 0: Maximum Number of Users (-n): 161. (4260)
18:34:44 BROKER 0: Host Name (-H): ss3. (4261)
18:34:44 BROKER 0: Service Name (-S): cdal. (4262)
18:34:44 BROKER 0: Network Type (-N): tcp. (4263)
18:34:44 BROKER 0: Character Set (-cpinternal): iso8859-1. (4264)
18:34:44 BROKER 0: Stream (-cpstream): iso8859-1. (4265)
18:34:44 BROKER 0: Parameter File: C:\symwork\SYM9516.tmp. (4282)
18:34:44 BROKER 0: Minimum Port for Auto Servers (-minport): 3000. (5648)
18:34:44 BROKER 0: Maximum Port for Auto Servers (-maxport): 5000. (5649)
18:35:01 SRV 1: Started on port 3001 using tcp, pid 2976. (5646)
 

davjoh

New Member
Good idea...but still no luck. If we can't find a solution before I go in to work tomorrow, I plan on reloading the server from scratch but won't install the R2 portion...I have been struggling with this for more than a week...I very much appreciate your suggestions and I will let you know how it goes.
 

pmorrissey

New Member
Hi again,

Think that this may be the solution. The 'service name' (-S) parameter can also be specified as a Port Number - this what you specify on the database server as a startup parameter. The Service Name or Port Number, used with the Host Name, will identify the database server instance. All this means is that the database filename (-db) only needs to be the file name, i.e. not qualified with a path. So, try removing the 'd:\...' from the '-db' parameter, and ensure that the service name/port number for the database matches that specified on the database server configuration.

Good luck
Paul
 

davjoh

New Member
Paul,
I tried your suggestion, but still no luck.

As a last resort before reloading the server from scatch I deleted all of the .pf files from SS3 then copied the .pf files currently used in our production environment (SS2) then pasted into SS3 and only changed the -H setting from SS2 to SS3 for each .pf file...I started the databases...when to the client pc...double-clicked on the icon to connect...crossed my fingers & closed my eyes...AND IT WORKED !!!

I wish I knew exactly what the problem was, but I don't have time to figure it out...prior to replacing the .pf files I went through each one making sure there were no 'tabs' used, only spaces...maybe I missed one or more? or it was something else?? Anyway, it's working now and I feel the weight of the world (or at least my bosses) has been lifted off of me now!!

Thanks Gabriel and Paul for your help!!!
 
Top