Thank you for your help. I appreciate the response. I have tried using both the password and the dbpasswd for the postgres user to create the Dataset. Both options give me a "could not connect to server: No such file or directory" error. Any other ideas of what I may be doing wrong?
Since I am connecting from another machine on my network, I am using host: 192.168.2.10 and port: 5432 (which is where I understand that postgreSQL listens at). I get the same error when I connect from localhost, as well, without specifying a hostname and port number. Is it necessary to specify a port number given that the perl script which invokes the connection and the SQL server reside on the same machine? -- Hugh Esco At 01:14 PM 10/21/02 -0600, you wrote: >No, the two passwords are for different things. One is to login to SL, the >other is for the db user to login to the SQL server. > >Dieter Simader http://www.sql-ledger.org (780) 472-8161 >DWS Systems Inc. Accounting Software Fax: 478-5281 >=========== On a clear disk you can seek forever =========== > >On Sat, 19 Oct 2002, Hugh Esco wrote: > > > From the page entitled: SQL-Ledger Accounting / Database Administration, > > I get the following error: > > >Error! > > >could not connect to server: No such file or directory > > > > When I attempt to Create Dataset. > > > > I have apparently created three users in my efforts to get past this step > > in the installation: SQL-Ledger_Owner, postgres and hesco. I have tried > > every possible combination of userIDs and passwords. > > > > I am confused about why the user/members file contains both a dbpasswd and > > a password. What is the significance of these two fields? I recognize the > > dbpasswd for the two users I set up. Is the other one an encrypted version > > of the first? Or is that a plain text rendering of what I would need to > > enter to authenticate? Which of these gets used how and when? > > > > And what of that error I keep getting? How can I create my Dataset, so I > > can build a Chart of Accounts and start importing my legacy data for the > > testing and training? > > > > -- Hugh Esco
