[SOLVED] Looking for libsss_nss_idmap.so.0 on Slackware

mfoley · 08-24-2018, 11:45 AM

I'm trying to install a package on 14.2 that required libsss_nss_idmap.so.0. I don't find this in either slackpkg or slackBuilds. Am I out of luck or can this be found somewhere?

Didier Spaier · 08-24-2018, 12:13 PM

I just found a page in Polish, link to translation below. Good luck.
https://translate.google.fr/translat...%2F&edit-text=
Link to the page in Polish:
http://www.ntit.pl/mssql-vnext-slackware-14-2/

mfoley · 08-24-2018, 09:52 PM

Quote:

Originally Posted by Didier Spaier

I just found a page in Polish, link to translation below. Good luck.
https://translate.google.fr/translat...%2F&edit-text=
Link to the page in Polish:
http://www.ntit.pl/mssql-vnext-slackware-14-2/

Excellent! The translation page is quite understandable. I've already installed the libc++ and numactl libraries, found on SlackBuilds.

I *could* simply install the Microsoft package on Ubuntu/Debian, but setting those up is a bit more painful than using an existing Slackware system -- provided installing the SQL Server package in Slackware isn't more painful itself.

I'll give this package a shot and post back. Nice Hunting!

mfoley · 08-25-2018, 03:13 PM

Downloaded the missing libsss_nss_idmap.so.0 from the Polish site (wget http://www.ntit.pl/wp-content/upload..._nss_idmap.tar) along with mssql-tools (wget http://www.ntit.pl/wp-content/upload....0-1_amd64.txz) and msodbcsql (wget http://www.ntit.pl/wp-content/upload....2-1_amd64.txz). Not entirely sure what the latter is, but must have something to do with ODBC. With the libc++, numactl and libsss libs I was able to run the '/opt/mssql/bin/mssql-conf setup' successfully (I think, there were some errors about "no version information available - required by sqlservr" on 3 libraries, but that didn't seem to be fatal).

I've now run '/opt/mssql/bin/sqlservr'. The next step is to try a query. The Polish website has some query examples, but doesn't say how to run them. I'll have to do some research on the 'tools'. I've also just downloaded sqlops (https://docs.microsoft.com/en-us/sql...ql-server-2017) which seems to be a SQL Management Studio-like GUI app. I'll post results after more testing. So far so good.

Thanks to Sławomir Dworaczek for making these Slackware ports and publishing the links!

mfoley · 08-25-2018, 04:22 PM

I don't mean to give a blow-by-blow of my testing, but working out these issues might help others.

I was able to use /opt/mssql-tools/bin/sqlcmd to do command-line queries, but first I had to download and install linuxODBC from SlackBuilds. That gave me the error:

Code:

# /opt/mssql-tools/bin/sqlcmd -U sa -P password -Q "select name from sys.databases" 
Sqlcmd: Error: Microsoft ODBC Driver 13 for SQL Server : Can't open lib 'ODBC Driver 13 for SQL Server' : file not found.

https://stackoverflow.com/questions/...-linking-issue had the answer to that:

Code:

# odbcinst -j
unixODBC 2.3.4
DRIVERS............: /etc/odbcinst.ini
SYSTEM DATA SOURCES: /etc/odbc.ini
FILE DATA SOURCES..: /etc/ODBCDataSources
USER DATA SOURCES..: /root/.odbc.ini
SQLULEN Size.......: 8
SQLLEN Size........: 8
SQLSETPOSIROW Size.: 8

# find / -mount -name odbcinst.ini -exec ls -l {} \;
-rw-r--r-- 1 root root 147 Jan  3  2018 /opt/microsoft/msodbcsql/etc/odbcinst.ini
-rw-r--r-- 1 root root 0 Aug 25 16:25 /etc/odbcinst.ini

# rm /etc/odbcinst.ini /etc/odbc.ini 
# ln -s /opt/microsoft/msodbcsql/etc/odbcinst.ini /etc/odbcinst.ini

That was the only symlink I needed, no odbc.ini was created in the /opt/microsoft directory. I could then run:

Code:

# /opt/mssql-tools/bin/sqlcmd -U sa -P password -Q "select name from sys.databases" # get a list of databases
name                                                                                                                            
-------------------------------------
master                                                                                                                          
tempdb                                                                                                                          
model                                                                                                                           
msdb             

# /opt/mssql-tools/bin/sqlcmd -U sa -P password -Q "use master; SELECT table_name FROM Information_schema.tables" # get list of tables
Changed database context to 'master'.
table_name                                                                                                                      
-----------------------------------------
spt_fallback_db                                                                                                                 
spt_fallback_dev                                                                                                                
spt_fallback_usg                                                                                                                
spt_values                                                                                                                      
spt_monitor                                                                                                                     
MSreplication_options

And of course I can do queries on individual tables.

Still not able to connect via SQL Operations Studio in KDE, but I suppose that's another issue entirely. As to my OP on getting SQL Server running with Slackware, I think I've got it! Again, thanks to Sławomir Dworaczek for doing the work on getting SQL Server to Slackware and to Didier Spaier for finding Sławomir's website.