Questions tagged [sql]
SQL is a programming language designed for managing data in relational database management systems (RDBMS).
124
questions
-1
votes
0answers
14 views
Error in sqlcmd command [closed]
I have installed sqlcmd tool to make a Database Connection. While executing the sqlcmd commands I am getting the below error:
root@docker-mssql:~# sqlcmd
Sqlcmd: Error: Microsoft ODBC Driver 17 for ...
0
votes
0answers
7 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 ...
-2
votes
0answers
21 views
Use a search word to retrieve database records and display in Python GUI [closed]
[enter image description here]
1
Hello from the other side.
A true programmer doesn't run away from challenges but would make every attempt to provide a solution. smiles
I'm having a little challenge ...
0
votes
0answers
32 views
How do I verify the inputs of a textfield exists in a database table when updating the records? How do I clear all the QlineEdit widgets in a QForm?
import sys
import pyodbc
from PyQt5.QtWidgets import (QApplication, QWidget, QLabel, QPushButton, QFormLayout, QMenu, QMenuBar, QLineEdit,
QDialogButtonBox, QMainWindow, QVBoxLayout, QDialog, ...
0
votes
0answers
13 views
How to install Oracle plsql and sqlpluse and form builder in ubuntu 20.0.4 LTS
I recently entered the world of Linux and I am now required to do my homework for a library project using the Oracle database and the (form builder) graphical data interface for (formbuilder) and I am ...
0
votes
1answer
80 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",...
0
votes
1answer
24 views
Unable to setup connection to server (SQL)
I am trying to set up a DBMS on my pop-os and with all the DS I tried I still have the same issue - when i try to set up the connection there is an error "Host "127.0.0.1" is not ...
1
vote
0answers
201 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....
0
votes
0answers
35 views
BaseX error: Could not find driver: org.sqlite.JDBC
Which directory should hold the JDBC driver for SQLite?
nicholas@mordor:~/flwor$
nicholas@mordor:~/flwor$ cat jdbc.xq
(: Initialize driver :)
sql:init("org.sqlite.JDBC"),
(: Establish a ...
0
votes
0answers
43 views
Installing SQL-server
I ran into a problem while installing the SQL server. The PHP package for some reason incorrectly installed the mcrypt.ini file, you can see on the screen.
I get the error:
skymasteer @ DESKTOP-...
0
votes
2answers
924 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: ...
0
votes
0answers
648 views
How to fix SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client?
I am new to using Laravel, but I am trying to help someone put the finishing touches to their website. I am using MAMP to host the database that was created by someone else.
However, whilst trying to ...
0
votes
0answers
310 views
High Availability “Username / Password Incorrect” during PCS cluster auth
I'm currently attempting to configure high availability on two Ubuntu SQL Servers.
Following this guide: Configuring Availability Groups in Ubuntu
I've set a password for the hacluster account and ...
0
votes
0answers
50 views
How to Open Ubuntu Version of SQL server for access to the internet
Hello: I am running SQL Server on my Local Area Network. I use it for Training and learning purposes. I am also learning Azure and GCP here. Cloud Databases are expensive. I would like to set up my ...
0
votes
1answer
2k 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
...
0
votes
1answer
88 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 ...
0
votes
0answers
23 views
Mysql error after apt upgrade error
I've recently run an apt upgrade on my server and then my MySQL server stopped working.
Here is the error I get: AVC apparmor="DENIED" operation="create" profile="/usr/sbin/...
1
vote
0answers
301 views
How to convert accdb to sql?
I am a new user of linux. I have a question that is how can I convert my accdb file to sql file.
Earlier I used the tool Access to MySQL to do this task in windows but this is not supported on Ubuntu ...
0
votes
1answer
133 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 ...
0
votes
0answers
228 views
Hue installation failed on Ubuntu 18.04
Lately I tried to install Hue on my ubuntu laptop. I downloaded the latest Hue tarball, and installed all required development packages before installing Hue. The following is the last two commands to ...
1
vote
0answers
53 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 ...
1
vote
1answer
385 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
1
vote
1answer
647 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
0
votes
0answers
240 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.
2
votes
1answer
751 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) ...
0
votes
0answers
182 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 ...
0
votes
1answer
405 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
-----------+------------...
0
votes
1answer
862 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 ...
2
votes
1answer
602 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: ...
5
votes
1answer
3k 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 ...
0
votes
1answer
442 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/...
2
votes
2answers
92 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"
...
2
votes
2answers
7k 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 ...
0
votes
2answers
150 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 ...
4
votes
1answer
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
...
3
votes
1answer
577 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 ...
2
votes
3answers
25k views
How to solve “Access denied for user 'phpmyadmin'@'localhost' (using password: YES)"
La connexion au controluser tel que défini dans votre configuration a échoué.
mysqli_real_connect(): (HY000/1045): Access denied for user 'phpmyadmin'@'localhost' (using password: YES)
La connexion ...
1
vote
0answers
135 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'...
0
votes
1answer
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/...
2
votes
1answer
964 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 ...
0
votes
1answer
482 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 ...
14
votes
5answers
22k 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 ...
0
votes
0answers
42 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 ...
0
votes
1answer
119 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 ...
0
votes
1answer
2k 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 ...
9
votes
3answers
26k 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/...
0
votes
1answer
851 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 ...
4
votes
2answers
20k 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 ...
0
votes
1answer
93 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?
5
votes
3answers
52k 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 ...
