META SERVER error register table

[haibh]

I use sas management console connect to sas meta with user "sasadm@saspw",  after create server, library then register table,  have error:

---

NOTE: SAS Initialization used (Total process time):
real time 0.07 seconds
cpu time 0.00 seconds

NOTE: The autoexec file, /u01/SASConfig/Lev1/SASApp/WorkspaceServer/autoexec.sas, was executed at server initialization.
1 LIBNAME LIBPOSG ODBC DATAsrc=postgresdb1 USER=postgres PASSWORD=XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX ;
NOTE: Libref LIBPOSG was successfully assigned as follows:
Engine: ODBC
Physical Name: postgresdb1
2
2 The SAS System 18:19 Friday, June 30, 2023

3 proc metalib
4 ;
4 ! omr (LIBURI="A5FSLUGQ.B5000006"
5 user="sasadm@saspw" password=XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
6 );
7 REPORT(type = summary out = "tab_info");
8 SELECT ("CAS_USERS"
9 );
10 FOLDERID = "A5FSLUGQ.AA000002";
11 run;

ERROR: CLI error trying to establish connection: connection to server at "10.4.18.143", port 5432 failed: FATAL: password
authentication failed for user "postgres"
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE METALIB used (Total process time):
real time 0.24 seconds
cpu time 0.10 seconds

[Sajid01]

Hello
From your post the  is "ERROR: CLI error trying to establish connection: connection to server at "10.4.18.143", port 5432 failed: FATAL: password
authentication failed for user "postgres""
Can you please check the connection to postgres using odbc manager at the OS level ?

[haibh]

at the OS level, on sas app, use isql test odbc is ok
[main-sas@dc-sas-app ~]$ isql postgresdb1 postgres ************
+---------------------------------------+
| Connected! |
| |
| sql-statement |
| help [tablename] |
| quit |
| |
+---------------------------------------+
SQL>

[Sajid01]

After seeing that you are able to connect to the postgres and my understanding if wat you are attempting to do,
I have the following suggestions.
1.If it is desired to create odbc session and resgister tables better to use SASMC
2.I see that odbc connection is being created in the workspace server session. So table registration is not needed.
Access control can be managed at the database level itself.
3.Are you trying to follow this example ?
https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/engimap/p09tt26phccdlbn17aw01bavqtdj.htm 

Please have a look at theis link http://support.sas.com/kb/13/848.html 

[Patrick]

I have a vague memory that there is something special with the unrestricted user sasadm@saspw and external passwords. Something related to security. 

Also sasadm@saspw is an internal user that shouldn't have an external user associated. To register your tables SAS will need to create a SAS session which requires an external user.

Try and use a different user that's not unrestricted to register your tables.