As of May 31, 2023, we have updated our Code of Conduct.

Questions tagged [sql]

SQL is a programming language designed for managing data in relational database management systems (RDBMS).

Filter by
Sorted by
Tagged with
0 votes
0 answers
18 views

Can't restart apache2

I already work on Apache2 so IDK where does this problem comes from. If I type "sudo systemctl retsart apache2" I got "Job for apache2 failed because the control process exited with ...
Clarisse's user avatar
0 votes
0 answers
32 views

Unable to connect sqlplus from Ubuntu server to Oracle windows machine

I am trying to connect to sqlplus from Ubuntu server to Windows machine which I have Oracle 19c installed and working. In Ubuntu, I have installed Oracle 19c instant client from this page on Oracle's ...
Mujahid Ahmed's user avatar
0 votes
2 answers
2k views

Unable to install SQL Server 2022 on ubuntu 22.10 [duplicate]

I am having trouble on installing SQL server 2022 Express... sudo apt-get update sudo apt-get install -y mssql-server Hit:1 http://security.ubuntu.com/ubuntu kinetic-security InRelease Hit:2 ...
mmakr's user avatar
  • 1
0 votes
0 answers
108 views

Ubuntu 20.04 High RAM usage

I have a Linux VM that has 8 GB RAM. This is a screenshot of htop which includes all system information (tasks,services). There's no application using too much RAM when looking at the PIDs, but the ...
Onur İn's user avatar
2 votes
1 answer
8k views

SQLSTATE[08001]: [Microsoft][ODBC Driver 17 for SQL Server]TCP Provider: Error code 0x2746

I'm using PHP Laravel 7.4 on Ubuntu 20.04 and trying to get data from SQL Server located on a Windows server in another cloud. This method was tested on my PC (Windows) and it successfully retrieved ...
naif basalib's user avatar
0 votes
1 answer
259 views

How to Insert Data Field Table SQL Server from another SQL Server in different ip from Ubuntu 20.04?

Hai I need help to insert data from one sql server ip to another sql server ip. I've tried using sqlcmd but it not work like mysql syntax on bash which can insert data using csv or txt file after I ...
Preman Terminal's user avatar
0 votes
1 answer
538 views

How to insert and update data from CSV using sqlcmd on ubuntu 20.04?

I can convert data database to .csv using sqlcmd syntax on my ubuntu sqlcmd -S ipdb -U sa -P "passwordsa" -d dbname -Q "select * from tabelname" -o "direktori/file.csv" -...
Preman Terminal's user avatar
0 votes
0 answers
124 views

How to use Kate text editor for DBMS?

Has anyone been able to access databases through Kate's SQL plugin? This looks like an excellent alternative to VSCode but I think it requires root access to access db files. I have a database saved ...
Shiv_90's user avatar
  • 274
0 votes
1 answer
2k views

Interface error while working with SQL using sql connector

I wanted to run my code which uses sqlconnector, but I can't, my code: dbconnection.py import mysql.connector mydb = mysql.connector.connect(host="localhost", user="yusharthsingh",...
Yusharth Singh's user avatar
2 votes
0 answers
330 views

Couldn't remove mssql-server on linux

To work with ASP.Net I have wanted to install mssql-server. Unfortunately after at the end of installation, it should some error. So, I wanted to remove this bad installation to try to reinstall again....
Iftekhar Riyad's user avatar
0 votes
2 answers
4k views

How to find SQL Server instance name on Ubuntu

I have linux ubuntu 16.04 and running MSSQL Server express Service is up and running. sudo systemctl status mssql-server result mssql-server.service - Microsoft SQL Server Database Engine Loaded: ...
paolo bergomi's user avatar
4 votes
3 answers
10k views

PHP 7.4 Warning: Unable to load dynamic library 'sqlsrv.so' and 'pdo_sqlsrv.so'

After installing the sql server, I tried to install the php drivers, sqlsrv and pdo_sqlsrv php extensions, following these commands: sudo pecl install sqlsrv sudo pecl install pdo_sqlsrv sudo su ...
Carolina's user avatar
  • 171
0 votes
1 answer
127 views

Where is the database for feedreader?

It's implied: https://code.launchpad.net/~eviltwin1/feedreader/sqlite that feedreader uses sqlite or that it can be configured to do so. I looked in the .config folder, but didn't see anything ...
Nicholas Saunders's user avatar
0 votes
1 answer
579 views

Changing the default SQL developer icon [Applications]

Note below solution The following answer is a way of changing the default sqldeveloper icon into something more exciting and less out of place within the sharpness and sleekness of the Ubuntu ...
G Dube's user avatar
  • 155
1 vote
0 answers
72 views

Ubuntu 19.10 Update deleted the whole MySQL and the records

I have a serious problem with my Ubuntu Server, I updated today from 19.09 to 19.10 but during the install procedure, the system kept throwing messages that MySQL failed to update and the server want ...
Larry Petshow's user avatar
1 vote
1 answer
481 views

Overheating ubuntu 20.04

I installed Ubuntu 20.04 on my ASUS laptop, and I noticed an overheating of my laptop. on the other hand in the version ubuntu 19.04 I did not notice this problem, is there a solution thank you
Abdennaceur Zizouni's user avatar
1 vote
1 answer
790 views

mysql workbench on ubuntu 20.04

how to install MySQL workbench on Ubuntu 20.04? MySQL workbench is not available on apt or the official website to MySQL
على عبداللاه's user avatar
0 votes
0 answers
525 views

How to install Northwind Database on ubuntu 18.04

I have installed MSSQL server , i tried creating tables and inserting , it worked well but i want to install Northwind Database , so i am asking if i can install it on ubuntu.
Hussein Okasha's user avatar
3 votes
1 answer
2k views

19.10: Unmet dependencies block install SQL Server Command Line Tools

I ma trying to install SQL Server Developer Edition in Ubuntu 19.10. I have followed the article (https://docs.microsoft.com/en-us/sql/linux/quickstart-install-connect-ubuntu?view=sql-server-ver15) ...
Abhishek Sivasubramanian's user avatar
0 votes
0 answers
402 views

Thunderbird: How to recover email passwords if master-password is known?

I forgot one of my email passwords. And it's still saved in Thunderbird that ran on Kubuntu. But now my Kubuntu is broken, and I cannot open thunderbird's GUI. The only thing I know is username and ...
gloschtla's user avatar
  • 161
0 votes
1 answer
803 views

Postgresql drop role command not working

drop role command not working in my postgresql 11. I can't delete the role named 'ckdev' . Role name | Attributes | Member of -----------+------------...
newbiecoder's user avatar
0 votes
1 answer
2k views

SQL server connection string

Is it possible to somehow get connection string to my SQL server ? It is running localy, on the same computer as my app which need to use the sql server do. So far the application has been running on ...
John Ronald's user avatar
  • 1,496
2 votes
1 answer
1k views

nzsql: error while loading shared libraries: libcom_err.so.2: wrong ELF class: ELFCLASS64 on Ubuntu 18.04

I am trying to install Netezza Client on an Ubuntu 18.04 system. After installation once we checked, we saw the error message below /usr/local/nz$ nzsql nzsql: error while loading shared libraries: ...
user3631357's user avatar
6 votes
1 answer
8k views

How to disable MySQL server from constantly running in the background?

This website explains MySQL server installation in Ubuntu 18.04. Basically you issue the command sudo apt install mysql-server. The same website then explains that: Once the installation is ...
Display name's user avatar
  • 2,101
0 votes
1 answer
732 views

Error writing /usr/share/phpmyadmin/libraries/sql.lib.php: Permission denied [duplicate]

I tried to fix the :count($analyzed_sql_results['select_expr'] error in :usr/share/phpmyadmin/libraries/sql.lib.php but I cannot write to it. Error : Error writing /usr/share/phpmyadmin/...
Pasan Jayawickrama's user avatar
3 votes
2 answers
193 views

SQL Server add respository

I am following the instructions here https://docs.microsoft.com/en-us/sql/linux/quickstart-install-connect-ubuntu?view=sql-server-2017 I am trying to run step 2. I get the result "Error '' invalid" ...
user983325's user avatar
3 votes
2 answers
11k views

Unable to connect to SQL server after update

I updated my server today with all pending update and after reboot I was unable to connect to SQL server. Prior to reboot I've also enabled the firewall but now it's disabled again and server is after ...
HyperQBE's user avatar
0 votes
2 answers
239 views

Get sql server data in ubuntu

How can I get Sql server's data in ubuntu. I have recently shifted from windows where we had Sql server management studio to do this task. Is there an alternative of it in ubuntu. I know some ...
Ahmad Farhan's user avatar
4 votes
1 answer
1k views

error while loading shared libraries: libqjson.so.0

I've installed sqlprofiler but I'm getting following error $ sqlprofiler sqlprofiler: error while loading shared libraries: libqjson.so.0: cannot open shared object file: No such file or directory ...
Kaushal Suthar's user avatar
3 votes
1 answer
952 views

LetsEncrypt for SQL Server on Linux

I have found information on how to install LetsEncrypt on Linux for NGINX (which works) how to install LetsEncrypt for SQL Server on Windows (which relies on GUI tools so is of no use), and how ...
ckapilla's user avatar
  • 133
4 votes
6 answers
61k views

How to solve “Access denied for user 'phpmyadmin'@'localhost' (using password: YES)"

mysqli_real_connect(): (HY000/1045): Access denied for user 'phpmyadmin'@'localhost' (using password: YES) The connection to the controluser as defined in your configuration has failed..
islem GUESMI's user avatar
1 vote
0 answers
227 views

Installing SSL Certificate onto a MSSQL instance

I'm running Microsoft SQL Server 2017 on a 18.04 LTS Server (AWS Cloud). I'm looking into getting proper SSL security on the server, but I cannot seem to find any guides for Linux, only for windows. I'...
James McFarland's user avatar
0 votes
1 answer
2k views

SQL Plus command not found

I downloaded instant-client zip directories for basic Linux, sqlplus and for SDK and unzipped them in opt/oracle.Then I added to my .bashrc file to follows: export PATH=:$PATH:/opt/oracle/...
sak18's user avatar
  • 1
2 votes
1 answer
1k views

Why I can't insert a picture into database? [closed]

I have a table with create table pictures( pic_ID int, picture blob, primary key (pic_ID) ); I use INSERT INTO pictures VALUES (1, load_file('/home/hai/Pictures/icon.jpeg')); and then ...
Hải Phạm's user avatar
0 votes
1 answer
1k views

How to speed up MySQLl loading from dump file of a very large database around 1T of tables?

i have 1T in around 200 tales in aws rds of innoDB , i want to backup them and restore in ubuntu 16.0.4 server , i tried with mysql-dump mysqldump --single-transaction --quick --max_allowed_packet 1G ...
Omer Anisfeld's user avatar
20 votes
5 answers
42k views

Unable to install msodbcsql17 on Ubuntu 18.04

I installed the sqlserver based on the Microsoft Documentation. The following commands are executed correctly. wget -qO- https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add - sudo ...
Hossein Bajan's user avatar
0 votes
0 answers
79 views

How to update a string with values from other fields?

I have a table containing a column with a string value, and 3 other columns with data. How do I replace parts of the string, with the value of the other 3 columns? I need to be able to iterate this ...
WR7500's user avatar
  • 171
0 votes
1 answer
246 views

Configuration Error while installing MySQL in Ubuntu 16.04

Unfortunately, I uninstalled MySQL. When trying to install it later I get this following error: ERROR: Unable to start MySQL server: mysqld: Can't read dir of '/etc/mysql/conf.d/' (Errcode: 2 - No ...
Ramesh KR's user avatar
  • 121
0 votes
1 answer
3k views

install SQL server express 2008 r2 on ubuntu 18.04?

I need to install a new invoice software on my pc. It is a Windows' based product and I am trying to run it by wine. The installation process terminates because of this error: "SQL server express ...
Capolavoro's user avatar
9 votes
3 answers
28k views

how to install sql developer (.rpm file) on lubuntu 18.04

How to install sql developer on lubuntu 18.04 I tried the below link from Oracle (served as installation notes when you download sql developer) but that dint work. https://www.oracle.com/technetwork/...
Amar Singh's user avatar
0 votes
1 answer
1k views

my sql is not launching

mysql-workbench /usr/lib/mysql-workbench/mysql-workbench-bin: error while loading shared libraries: libgdkmm-2.4.so.1: cannot open shared object file: No such file or directory this error shows up ...
dilnavas roshan's user avatar
4 votes
2 answers
23k views

Set environment variable UBUNTU 18.04 (bionic) - Crontab

Firstly, sorry for my English. My situation is: Have a Ubuntu 18.04 Want to execute with crontab python & sh scripts Result: /usr/lib/oracle/12.2/client64/bin/sqlplus: error while loading shared ...
Juan Carlos Arqueros Vírseda's user avatar
0 votes
1 answer
101 views

SQL database access access

I can get to where I can view databases in my sql, however I want to see what is in those databases? what is my next command?
Tim Gilbert's user avatar
11 votes
3 answers
81k views

How to execute SQL statement from command line?

I'm a longtime GUI user trying to switch to command line, and I'm not sure how to execute an SQL statement from the Ubuntu command line. I'm using postgres. I can use \c to connect to the database ...
j450n's user avatar
  • 141
7 votes
1 answer
25k views

Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server

I am not able to run sqlcmd command My OS (18.04) is $ uname -a Linux Linux 4.15.0-23-generic #25-Ubuntu SMP Wed May 23 18:02:16 UTC 2018 x86_64 x86_64 x86_64 GNU/Linux $ sqlcmd -S localhost -U ...
Raakh's user avatar
  • 93
0 votes
1 answer
280 views

sql server installation error [duplicate]

When I try to install SQL Server, I get this error: The following packages have unmet dependencies: mssql-server : Depends: libcurl3 but it is not going to be installed Depends: ...
meco.30's user avatar
0 votes
1 answer
3k views

'STR' object is not callable while execute sql command [closed]

I'm try to get 3 data from one function. X,Y,Z data from get_gyro_data() function. When i'm try to execute these datas in order to insert tab TAB_MPU and columns GX,GY,GZ . I use i2c for gettin data ...
Mehmet Ali Küçük's user avatar
0 votes
2 answers
941 views

How to upload sqlite3 database to webserver? [closed]

I am very new to this. There is tuptime.db file which has records of uptime in my computer(local server). How can I upload it to web server and show the database content in a website. I want something ...
life tree's user avatar
1 vote
0 answers
5k views

Unable to locate package msodbcsql

I'm trying to install ms sql driver on Ubuntu 16.04. Here are steps I run : $ curl https://packages.microsoft.com/keys/microsoft.asc | apt-key add - % Total % Received % Xferd Average Speed ...
Samuel 's user avatar
0 votes
0 answers
90 views

Problems after setting up MySQL Cluster on Ubuntu Server 16.04

I am fairly new to Ubuntu but I wanted to set up a SQL Cluster. I followed this guide exactly as it says: https://www.digitalocean.com/community/tutorials/how-to-create-a-multi-node-mysql-cluster-on-...
naikon's user avatar
  • 1