dbTalk Databases Forums  

Postgresql user name doesn't match login

comp.databases.postgresql comp.databases.postgresql


Discuss Postgresql user name doesn't match login in the comp.databases.postgresql forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Al Balmer
 
Posts: n/a

Default Postgresql user name doesn't match login - 01-25-2008 , 06:31 PM






We have a peculiar situation on one HP-UX site. We have a function
which tests for user name, but the user name it sees is not the same
as the login name. PGUSER is not set. The function works as expected
on other systems.

I've spent some time with the source code trying to determine exactly
how the user name is determined, but since I'm not familiar with it,
that could take weeks <g>.

One thing that's different about this system is that it's using LDAP.

Does anyone have a clue for us?

--
Al Balmer
Sun City, AZ

Reply With Quote
  #2  
Old   
Laurenz Albe
 
Posts: n/a

Default Re: Postgresql user name doesn't match login - 02-26-2008 , 09:04 AM






Al Balmer <albalmer (AT) att (DOT) net> wrote:
Quote:
We have a peculiar situation on one HP-UX site. We have a function
which tests for user name, but the user name it sees is not the same
as the login name. PGUSER is not set. The function works as expected
on other systems.

I've spent some time with the source code trying to determine exactly
how the user name is determined, but since I'm not familiar with it,
that could take weeks <g>.

One thing that's different about this system is that it's using LDAP.

Does anyone have a clue for us?
"Function": is this a PostgreSQL function in PL/pgSQL? In C?

"User name": is this a database user or an operating system user?
If the latter: the user of the client process or the user of the server
process?

Is the function very long? If not, you could post it.
Without the code it's difficult to help you.

Yours,
Laurenz Albe


Reply With Quote
  #3  
Old   
Laurenz Albe
 
Posts: n/a

Default Re: Postgresql user name doesn't match login - 02-26-2008 , 09:04 AM



Al Balmer <albalmer (AT) att (DOT) net> wrote:
Quote:
We have a peculiar situation on one HP-UX site. We have a function
which tests for user name, but the user name it sees is not the same
as the login name. PGUSER is not set. The function works as expected
on other systems.

I've spent some time with the source code trying to determine exactly
how the user name is determined, but since I'm not familiar with it,
that could take weeks <g>.

One thing that's different about this system is that it's using LDAP.

Does anyone have a clue for us?
"Function": is this a PostgreSQL function in PL/pgSQL? In C?

"User name": is this a database user or an operating system user?
If the latter: the user of the client process or the user of the server
process?

Is the function very long? If not, you could post it.
Without the code it's difficult to help you.

Yours,
Laurenz Albe


Reply With Quote
  #4  
Old   
Laurenz Albe
 
Posts: n/a

Default Re: Postgresql user name doesn't match login - 02-26-2008 , 09:04 AM



Al Balmer <albalmer (AT) att (DOT) net> wrote:
Quote:
We have a peculiar situation on one HP-UX site. We have a function
which tests for user name, but the user name it sees is not the same
as the login name. PGUSER is not set. The function works as expected
on other systems.

I've spent some time with the source code trying to determine exactly
how the user name is determined, but since I'm not familiar with it,
that could take weeks <g>.

One thing that's different about this system is that it's using LDAP.

Does anyone have a clue for us?
"Function": is this a PostgreSQL function in PL/pgSQL? In C?

"User name": is this a database user or an operating system user?
If the latter: the user of the client process or the user of the server
process?

Is the function very long? If not, you could post it.
Without the code it's difficult to help you.

Yours,
Laurenz Albe


Reply With Quote
  #5  
Old   
Laurenz Albe
 
Posts: n/a

Default Re: Postgresql user name doesn't match login - 02-26-2008 , 09:04 AM



Al Balmer <albalmer (AT) att (DOT) net> wrote:
Quote:
We have a peculiar situation on one HP-UX site. We have a function
which tests for user name, but the user name it sees is not the same
as the login name. PGUSER is not set. The function works as expected
on other systems.

I've spent some time with the source code trying to determine exactly
how the user name is determined, but since I'm not familiar with it,
that could take weeks <g>.

One thing that's different about this system is that it's using LDAP.

Does anyone have a clue for us?
"Function": is this a PostgreSQL function in PL/pgSQL? In C?

"User name": is this a database user or an operating system user?
If the latter: the user of the client process or the user of the server
process?

Is the function very long? If not, you could post it.
Without the code it's difficult to help you.

Yours,
Laurenz Albe


Reply With Quote
  #6  
Old   
Laurenz Albe
 
Posts: n/a

Default Re: Postgresql user name doesn't match login - 02-26-2008 , 09:04 AM



Al Balmer <albalmer (AT) att (DOT) net> wrote:
Quote:
We have a peculiar situation on one HP-UX site. We have a function
which tests for user name, but the user name it sees is not the same
as the login name. PGUSER is not set. The function works as expected
on other systems.

I've spent some time with the source code trying to determine exactly
how the user name is determined, but since I'm not familiar with it,
that could take weeks <g>.

One thing that's different about this system is that it's using LDAP.

Does anyone have a clue for us?
"Function": is this a PostgreSQL function in PL/pgSQL? In C?

"User name": is this a database user or an operating system user?
If the latter: the user of the client process or the user of the server
process?

Is the function very long? If not, you could post it.
Without the code it's difficult to help you.

Yours,
Laurenz Albe


Reply With Quote
  #7  
Old   
Laurenz Albe
 
Posts: n/a

Default Re: Postgresql user name doesn't match login - 02-26-2008 , 09:04 AM



Al Balmer <albalmer (AT) att (DOT) net> wrote:
Quote:
We have a peculiar situation on one HP-UX site. We have a function
which tests for user name, but the user name it sees is not the same
as the login name. PGUSER is not set. The function works as expected
on other systems.

I've spent some time with the source code trying to determine exactly
how the user name is determined, but since I'm not familiar with it,
that could take weeks <g>.

One thing that's different about this system is that it's using LDAP.

Does anyone have a clue for us?
"Function": is this a PostgreSQL function in PL/pgSQL? In C?

"User name": is this a database user or an operating system user?
If the latter: the user of the client process or the user of the server
process?

Is the function very long? If not, you could post it.
Without the code it's difficult to help you.

Yours,
Laurenz Albe


Reply With Quote
  #8  
Old   
Laurenz Albe
 
Posts: n/a

Default Re: Postgresql user name doesn't match login - 02-26-2008 , 09:04 AM



Al Balmer <albalmer (AT) att (DOT) net> wrote:
Quote:
We have a peculiar situation on one HP-UX site. We have a function
which tests for user name, but the user name it sees is not the same
as the login name. PGUSER is not set. The function works as expected
on other systems.

I've spent some time with the source code trying to determine exactly
how the user name is determined, but since I'm not familiar with it,
that could take weeks <g>.

One thing that's different about this system is that it's using LDAP.

Does anyone have a clue for us?
"Function": is this a PostgreSQL function in PL/pgSQL? In C?

"User name": is this a database user or an operating system user?
If the latter: the user of the client process or the user of the server
process?

Is the function very long? If not, you could post it.
Without the code it's difficult to help you.

Yours,
Laurenz Albe


Reply With Quote
  #9  
Old   
Laurenz Albe
 
Posts: n/a

Default Re: Postgresql user name doesn't match login - 02-26-2008 , 09:04 AM



Al Balmer <albalmer (AT) att (DOT) net> wrote:
Quote:
We have a peculiar situation on one HP-UX site. We have a function
which tests for user name, but the user name it sees is not the same
as the login name. PGUSER is not set. The function works as expected
on other systems.

I've spent some time with the source code trying to determine exactly
how the user name is determined, but since I'm not familiar with it,
that could take weeks <g>.

One thing that's different about this system is that it's using LDAP.

Does anyone have a clue for us?
"Function": is this a PostgreSQL function in PL/pgSQL? In C?

"User name": is this a database user or an operating system user?
If the latter: the user of the client process or the user of the server
process?

Is the function very long? If not, you could post it.
Without the code it's difficult to help you.

Yours,
Laurenz Albe


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.