Questions tagged [sql]
SQL is a programming language designed for managing data in relational database management systems (RDBMS).
113
questions
1
vote
0answers
25 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 ...
0
votes
0answers
23 views
ms sql server on ubuntu 20.4
Has anyone tried MS SQL on Ubuntu 20.4 ? Did it work? I am trying to install it but looks like there are no new dependencies.
Thank you very much in advance.
1
vote
0answers
139 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
0
votes
1answer
230 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
61 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
246 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
72 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
154 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
230 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
281 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: ...
0
votes
0answers
30 views
Cannot connect to MsSQL Enable TCP connections
I'm trying to enable TCP connections. I'm making an app and I'm using mssql with node. The message I'm getting is:
ConnectionError: Failed to connect to hostname:1433 - getaddrinfo ENOTFOUND ...
0
votes
0answers
345 views
How to set up pyodbc driver for python 3.6 superset docker
I followed the guide on https://superset.incubator.apache.org/installation.html to install the docker.
Now i need to install pyodbc driver for SQL server connection.
Driver installed successful:
...
0
votes
0answers
15 views
How to install imported .sql database?
I have exported database from another computer, I want to install (add) it to my sql server
so when I run
mysql -u root -e "show databases();"
it should show me database exported database name.
...
4
votes
1answer
872 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
0answers
24 views
Using Python to query SQL Azure DWH unable to use correct data types?
I have some simple Python code using the pandas package to read from a SQL server. This works on my windows machine, and it worked on my Ubuntu machine until recently.
query = """
SELECT TOP ...
0
votes
1answer
216 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
67 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
4k 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
109 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 ...
0
votes
0answers
131 views
A connection error
I’m trying to connect a windows application from Ubuntu to SQL Server but I’ve got an error of:
“A connection was successfully established with the server, but then an error occurred during the pre ...
4
votes
1answer
745 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
...
2
votes
1answer
324 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 ...
1
vote
3answers
10k 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
90 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
1k 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/...
3
votes
1answer
901 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
181 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 ...
7
votes
4answers
9k 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
28 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
76 views
Configuration Error while installing mysql in ubutnu 16.04
Unfortunately, I uninstalled MySQL. And later I am trying to install but I get this following error.
ERROR: Unable to start MySQL server:
mysqld: Can't read dir of '/etc/mysql/conf.d/' (Errcode: 2 - ...
0
votes
1answer
1k 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
23k 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
0answers
40 views
Failed writing body while installing Sql [duplicate]
enter image description hereI've installed Ubuntu and Virtual Machine on my Mac OS and I'm trying to download Sql now and run into this error when I use this command in my Mac terminal.
curl https:/...
0
votes
1answer
648 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
17k 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
89 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
36k 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 ...
5
votes
1answer
11k 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 ...
0
votes
1answer
221 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: ...
0
votes
1answer
1k 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 ...
0
votes
2answers
410 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 ...
0
votes
0answers
3k 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 ...
0
votes
0answers
79 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-...
3
votes
1answer
1k views
How to install Adventure Works DB on Ubuntu 16.04?
I have downloaded the free Express version of SQL Server 2017 onto my Linux Ubuntu 16.04 LTS machine. I have created a test database through the command line terminal, and I was able to create a table ...
0
votes
0answers
36 views
Read database from vm1 to vm2 (ubuntu)?
I have ubuntu on vmware. I've installed mysql-server on it. And now I'd like to connect to this db directly from another ubuntu(2) on vmware. I've set the network adapter to host-only for both vm. I ...
0
votes
1answer
375 views
Failed to install SQL Server
When I try to download SQL Sever following the procedure in this blog using the terminal on Ubuntu 16.04,
I get this:
roqaia@roqaia-Inspiron-3558:~$ curl https://packages.microsoft.com/keys/...
2
votes
1answer
1k views
Cannot run Sqlectron
I have installed sqlectron v1.28.0 from the .deb file available here
but I cannot run it. The icon appears in my system. When I click on it nothing happens. I'm running 14.04 btw. Please help.
0
votes
1answer
449 views
Can I close port 3306 if I dont use?
I have a LAMP server. The port 3306 is opened.
I have a php program on the server, to make query and display it on the port 80.
Can I close it if I do not use SQL DB manager client software?
0
votes
0answers
2k views
How to open SQL file
I am trying to open an SQL file, but unfortunately I have some problems. When I try
mysql -u -p dbname < dbsource
it says
ERROR 1049 (42000): Unknown database
The file also encrypted SHA512 ...
-1
votes
1answer
818 views
How to start mysql service automatically as root user.
Since mysql on my system is able to run using sudo service mysql start i used the username root it self.. the problem is now I want to automatically run the script
