Can't connect Win XP client to Linux server
От | Geoff Lane |
---|---|
Тема | Can't connect Win XP client to Linux server |
Дата | |
Msg-id | 11010632126.20090519204831@gjctech.co.uk обсуждение исходный текст |
Ответы |
Re: Can't connect Win XP client to Linux server
|
Список | pgsql-odbc |
Sorry for a complete newbie question. I've just started experimenting with PostgreSQL and managed to get the server running under CentOS 5.3. However, things didn't go smoothly and it took a while to figure out that I needed to su to root, then su to postgres before I could create roles for root and for my normal login. Having done that for both as superusers, I can now define and manipulate data via psql (version 8.1.11). For info, I installed PostgreSQL on the server via the CentOS packet manager. However, I cannot connect to this server from a Windows XP client using either the 8.03.04.00 ANSI or Unicode drivers. At first, I got the response: Could not connect to the server; No connection could be made because the target machine actively refused it. [192.168.42.106:5432] when I click the Test button. I can telnet onto the server and run the psql client in a telnet session as the user I'm trying to connect as. I suspected I needed to tweak the server to permit connections from remote clients but had no idea how to do that other than set listen_addresses = '*' in postgresql.conf. Having done that, I got another error message telling me there wasn't an entry in pg_hba.conf. So to that file, I added the line: host all all 192.168.42.0/24 md5 and after rebooting the server got the error: FATAL: password authentication failed for user "geoff" I changed "md5" to "password" and rebooted the server but to no avail. However, connection was successful when I changed "password" to "trust" - but I'm uneasy about that level of security and would prefer full authentication. I've tried searching through the docs, FAQ's and the archives of this list but failed to find a solution (although that could be due to not knowing the most appropriate search terms!) Can someone give me a few pointers? TIA, -- Geoff Lane
В списке pgsql-odbc по дате отправления: