Are you sure postgres is actually running on your machine / and you have=20 permissions to use it?
does 'psql template1' return an error?? On Monday 21 October 2002 05:48 pm, Hugh Esco wrote: > Thank you for your help. I appreciate the response. I have tried usin= g > 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 ho= st: > 192.168.2.10 and port: 5432 (which is where I understand that postgreSQ= L > listens at). I get the same error when I connect from localhost, as we= ll, > without specifying a hostname and port number. Is it necessary to spec= ify > a port number given that the perl script which invokes the connection a= nd > 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 > >=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D On a clear disk you can seek forever= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D > > > >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 thi= s > > > 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 dbpas= swd > > > 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 on= e 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 us= ed > > > 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 --=20 =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D David Ratte Superior Circuit Technologies, Inc. [EMAIL PROTECTED] http://www.superiorcircuits.com Tel 321-254-4201 x 204 Fax 321-254-6192
