Questions tagged [sqlserver]
The sqlserver tag has no usage guidance.
33
questions
0
votes
0answers
14 views
How to install mssql tools on ubuntu 20.04?
I am trying to install the mssql-tools on Ubuntu 20.04 but when I tried with this command I get this:
sudo apt-get install mssql-tools unixodbc
Reading package lists... Done
Building dependency tree
...
0
votes
0answers
30 views
Instaling linux server on old laptop with broken gpu
I tried to install an Ubuntu server to manage sql database for the application im building on my old laptop. I haven't used it a long time ago because the gpu is dead. Im kinda noob-ish for linux, so ...
0
votes
1answer
46 views
Resetting Debian Password without restarting at all? [duplicate]
My company has a Debian server that holds and runs some important stuff that cannot be shut down... The previous Joe before me, didn't seem to have a password logged or even passed on the information ...
1
vote
0answers
18 views
SQL SERVER (LINUX) – syspolicy_purge_history job failing step 3: Erase Phantom System Health Records
No one out there seems to have an answer for this...everything is for windows and no help for those using linux to run SQL Server 2019. Problem is that the 3rd step in this process is to run ...
0
votes
1answer
87 views
SQL Server 2019 (Centos 8) Non-Yielding Scheduler
We are running SQL Server 2019 (Linux) CU4 with the following server specs:
OS: Centos 8
RAM: 32GB
HDD: 1TB SSD
CPU: 8 Core I-7
SQL: Microsoft SQL Server 2019 (RTM-CU4) (KB4548597) - 15.0.4033.1 (X64)...
0
votes
0answers
110 views
Flask application running on uwsgi and nginx crashes with SQL Server transaction error
Python: 3.5.2 pyodbc: 4.0.28 OS: Ubuntu 18.04 DB: Microsoft SQL Server driver: ODBC Driver 17 for SQL Server WSGI: uwsgi & nginx
Issue: Hitting error SQL Server Failed to resume transaction, for ...
0
votes
0answers
22 views
List all crowd users in DB without the root or write access credentials
Hi I want to run a query on the Crowd DB with a read permission access.
However, I ran a query on my Linux CLI to get the list of all active users with write access credentials, whereas I want to use ...
0
votes
0answers
197 views
How to store value of sqlcmd query into variable in shell scripting
I tried to store the value of my sqlcmd query into variable and display the output.
For example
cwdusers=$(sqlcmd -S "mydb" -U xxx -P xxxxx -d My_DB -Q "select count(*) from user_table")
echo "Total ...
0
votes
0answers
72 views
Query gets truncated while executing in sqlcmd in shell script
I am trying to execute a select statement from linux via sqlcmd, the query length is of 5100 characters. When I print the result using echo the entire query is being displayed, but sqlcmd execution is ...
0
votes
1answer
518 views
How to write data to a csv file with comma in string values
I need to hit a database with basic select queries and write the result output in a file. using sqlcmd I execute the queries and write the results to the output csv file.
While trying to open this ...
0
votes
1answer
110 views
How to use * in shell scripting [duplicate]
I have table in database which stores few queries, Using sqlcmd I am trying to retrieve the queries.
While doing so, the select * from abc is getting replaced with 'select from abc'
How to overcome ...
0
votes
0answers
247 views
Installing OpenSSL 1.1.0
I am trying to connect to an instance of SQL Server 17 running on my Ubuntu 18.04 machine, using Azure Data Studio, and after a long session of brainstorming, I discovered that it depends upon OpenSSL ...
1
vote
0answers
194 views
mssql-server on debian broken after update?
Time ago I installed mssql-server on my debian VPS and works fine. Now, mssql-server not run and I don't know what is changed.
If type /opt/mssql/bin/sqlserver I get
2019-07-07 18:13:19.79 Logon ...
0
votes
3answers
1k views
Install the PHP drivers for Microsoft SQL Server
I'm using web server nginx, php 7.1 fpm and laravel in Centos 7.
I want to install SQL Server following the official installation tutorial for Linux but I'm confused with this command:
echo extension=...
1
vote
2answers
923 views
kdump in CentOS 7
I wanted to migrate to CentOS 7.5 from CentOS 6.9. during installation I saw an option kdump that i could enable or disable. I wonder what is kdump and disabling it has any bad effect on server? I ...
1
vote
1answer
453 views
“sqldeveloper-18.1.0.095.1630-no-jre.zip” not found, aborting… error message [closed]
During installation of Debian package builder for Oracle SQL developer in Ubuntu 18.04, I used the following command:
make-sqldeveloper-package sqldeveloper-18.1.0.095.1630-no-jre.zip
but it is ...
3
votes
1answer
238 views
Can getauxval be used to determine whether or not you're being traced?
Coming off of this question, I patched my kernel in a quest to get SQL Server 2017 on Linux to start up. Now I'm getting further but I'm being shut down,
strstr("TracerPid:\t0\n", "TracerPid:") ...
3
votes
2answers
2k views
How do I hide TracerPID from a process?
I'm conjecturing SQL Server on Linux is checking /proc/self/status for TracerPID and then dying if it's not 0. I want to test that. Playing around, here is the strace,
... lots of stuff
openat(...
0
votes
1answer
25 views
Is it needed for the server daemon to running so that it could be included as a dependency while building some other package?
I'm making the postfix MTA which depends on some database packages(mariadb, postgresql,...). I'm building on the instructions of Beyond Linux Form Scratch (BLFS) but I fear if it is needed for the ...
1
vote
0answers
52 views
SQL-Server for Linux WORKGROUP authentication handling
I installed SQL-Server for Linux on a linux Centos 7 distro, it works fine, but I need a workgroup authentication. It's required by the client (SAGE Ligne 100) which runs on a Windows workstation. ...
0
votes
1answer
7k views
Increase Ram Provided to docker container
I'm trying to run the docker mssql container on a Linux host.
In the tutorial it is described how you should increase the RAM size allocated to the container and how you do that on Windows and Mac ...
4
votes
5answers
5k views
sqlcmd does not work: Can't open lib libmsodbcsql.13.dylib
I've installed mssql-tools and msodbcsql,
And I've symlinked /usr/local/homebrew/lib/libmsodbcsql.13.dylib to /usr/local/lib/libmsodbcsql.13.dylib
But sqlcmd still complains about missing lib,
%>...
3
votes
1answer
540 views
BCP neither gives results nor outputs anything when using valid statements but it does throw errors when passing invalid parameters
I have to use bcp command-line tool to export data from an SQL Server database to a file in a Red Hat server.
I am (apparently) using valid statements but bcp is not producing any kind of output/...
2
votes
1answer
159 views
Unexpected behavior of file descriptor and/or I/O streams after running sqlcmd with -i option (read sql from file) in ksh creates infinite loop
Is there a way to use sqlcmd with -i input_file option without creating an infinite loop in my ksh script?
The code reads lines from $file and parses it line-by-line to extract data and process other ...
2
votes
1answer
8k views
Cannot run test program while cross compiling - cross compiling Firebird
I've tried to compile firebird server for arm linux, with cross-compiler (it's choosen - it's working properly).
When using:
./autogen.sh --host=arm-linux-gnu
I get this error:
checking for ...
1
vote
0answers
64 views
ODBC connection from a Linux box to MS SQLServer
I need to connect to MS SQLServer from a Linux box using ODBC from a Qt application I am developing.
So far I have installed the ODBC MS SQLServer driver and Kerberos on the Linux box. Using kinit I ...
0
votes
4answers
1k views
Find a server IP on LAN from a script
I am looking for a way to have a script on a client machine automatically find the servers IP on the same network.
I have several media extender clients running ubuntu 14.04.1 and a server running ...
1
vote
2answers
10k views
Can't Install php-mssql or freetds on Centos7
My goal is to connect to MS SQL Server 2005 using PHP. I have installed PHP and ODBC. I am running CentOS7.
PHP Version => 5.4.16
.... (from php -i) ....
odbc
ODBC Support => enabled
I am ...
1
vote
1answer
608 views
syslog-ng ignores MSSQL database name
syslog-ng ignores the database defined in syslog-ng.conf and instead uses the default database of the user when logging to MSSQL destination.
destination d_mssql {
sql(type(mssql)
host("...
1
vote
1answer
98 views
Apostrophe appearing as space
I am trying to insert the following message:
friend's mobile number
from a file over redhat server into sql server 2005.
this message is appearing in the sql server as below:
friend s mobile ...
2
votes
1answer
257 views
MSSQL database server on UNIX
I have heard rumors, but did not manage to find anything more, about some sort of MSSQL serving on UNIX machine, or MSSQL/MySQL server, that can handle MSSQL storage.
I would like to know, if it is ...
3
votes
2answers
3k views
backup MSSQL database to a client's local disk over network
I'm trying to backup a MSSQL server from linux. I'm able to connect to the server using tsql (from the freetds project), and I'm even able to backup the database on the server using the backup ...
6
votes
4answers
6k views
Can I work with Sql Server, Office and C# using Linux?
I want to start working with linux, and I know I should work in that regularly to improve myself.
I work with sql server, office, c# at the company. can I install and do my tasks in linux (i.e. red ...
