topic Re: META SERVER error register table in Administration and Deployment

META SERVER error register table

haibh — Fri, 30 Jun 2023 11:06:02 GMT

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

Re: META SERVER error register table

Sajid01 — Sun, 02 Jul 2023 13:38:34 GMT

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 ?

Re: META SERVER error register table

haibh — Sun, 02 Jul 2023 14:04:15 GMT

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>

Re: META SERVER error register table

Sajid01 — Sun, 02 Jul 2023 15:16:45 GMT

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

Re: META SERVER error register table

Patrick — Mon, 03 Jul 2023 11:24:56 GMT

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.