Applied the patch and re-compilied. psql company, now works fine.
I would assume then, that it is the same bug that is in the UW.
Thanks for everyones help.
Larry Rosenman wrote:
> * Dave Smith <dave@candata.com> [001121 14:34]:
>
>> Yup. that's it.
>>
>> createdb --host=localhost company
>> works fine. Could you elaborate on what the accept issue is?
>
> SCO has a bug in accept() of Unix Domain Sockets. It doesn't set
> SA_FAMILY to AF_UNIX. Here's a patch for 7.0.3:
> $ diff -c pqcomm.c.old pqcomm.c
> *** pqcomm.c.old Thu May 25 20:26:19 2000
> --- pqcomm.c Sun Nov 12 12:03:25 2000
> ***************
> *** 354,359 ****
> --- 354,361 ----
> perror("postmaster: StreamConnection: accept");
> return STATUS_ERROR;
> }
> + if (port->raddr.sa.sa_family == 0)
> + port->raddr.sa.sa_family = AF_UNIX;
>
> /* fill in the server (local) address */
> addrlen = sizeof(port->laddr);
> $
>
> We've fixed this in 7.1 for UnixWare, now we need to fix it for OSR5
> as well.
>
> Peter E:
> Can we look into this?
>
>
>
>
>> Larry Rosenman wrote:
>>
>>
>>> What happens if you connect using TCP/IP?
>>> I think the OSR5 libs have the same issue that UW7 has in the accept
>>> call.
>>>
>>> I.E. psql -h localhost
>>>
>>> LER
>>>
>>> * Dave Smith <dave@candata.com> [001121 13:37]:
>>>
>>>
>>>> No differnt
>>>>
>>>> Robert D. Nelson wrote:
>>>>
>>>>
>>>>
>>>>>> createdb company
>>>>>> psql: No pg_hba.conf entry for host localhost, user postgre, database
>>>>>> template1
>>>>>> createdb: database creation failed
>>>>>
>>>>>
>>>>> What happens if you try a user "postgres" instead of "postgre"? :)
>>>>>
>>>>>
>>>>> Rob Nelson
>>>>> rdnelson@co.centre.pa.us
>>>>