Questions tagged [sql]
SQL is a programming language designed for managing data in relational database management systems (RDBMS).
0
votes
0answers
16 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
38 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
873 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
21 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 ...
1
vote
1answer
148 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
16 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
34 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
175 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 ...
0
votes
0answers
112 views
How can I install Oracle 18c express edition in Ubuntu 18.04? [duplicate]
I need Oracle 18c express edition for one of my courses.
Can anyone explain how I can install Oracle 18c express or suggest any alternative I can use to practise SQL queries?
I searched online but ...
5
votes
3answers
7k 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
24 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
0answers
105 views
MySql stopped working LAMP
After making system update (my SO is Ubuntu 18.04) and reboot, the mysql doesn't start on Xampp (everything was working fine before).
Here is the sudo /opt/lampp/lampp start :
Starting XAMPP for ...
0
votes
1answer
115 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 ...
2
votes
2answers
6k 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
40 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?
2
votes
3answers
8k 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
2k 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
161 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
751 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
118 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
2k 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
44 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-...
2
votes
1answer
595 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
30 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
311 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/...
1
vote
1answer
502 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
265 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
816 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
525 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
0
votes
0answers
622 views
sqldeveloper freezes on first launch
Installed Oracle XE 11g on Ubuntu in VM. Now installing SQL Developer. At the point where I'm ready to run sqldeveloper or sudo sqldeveloper for the first time the terminal freezes/crashes.
Prompted ...
1
vote
1answer
3k views
can't install mysql-connector
i tried to install mysql-connector but didn't succeded
pip install mysql-connector-python-rf
Collecting mysql-connector-python-rf
Downloading mysql-connector-python-rf-2.2.2.tar.gz (11.9MB)
...
1
vote
1answer
16k views
How to configure DBeaver to connect with ms sql server
I am a trainee and in my project i have been working on MS SQL server using microsoft server management studio but now for some reasons i have to use ubuntu for a week or so. I have nothing installed ...
0
votes
1answer
315 views
Need JDBC Driver Class for LibreOffice Calc (Database)
I am using Ubuntu 16.04 and LibreOffice Calc.
Trying to connect to database, which is Microsoft SQL which I am using through DBeaver.
I would like to know what to write here:
I have tried installing ...
0
votes
0answers
264 views
Unable to Install PDO_DBLIB
I have been trying to get the PDO_DBLIB installed with no luck.
When I try:
pecl install PDO_DBLIB
I get:
there was a problem with getting the configured temp directory install failed
0
votes
0answers
564 views
SQL Developer not opening? [duplicate]
I Just installed SQL developer and JDK version 8 in Ubuntu 16.04 with tar -xvzf jdk-8u121-linux-x64-demos.tar.gz -C /opt/java
When I run ./sqldeveloper.sh I get:
Oracle SQL Developer
Copyright (c) ...
0
votes
2answers
61 views
When an SQL query fails to return anything, how can I tell the shell to return a “false” instead?
This may not have anything to do with SQL in particular, because I am sure other commands will do this as well.
In this case, I send a query through the shell, and if the query does not match any ...
1
vote
0answers
707 views
ORA-12162: TNS:net service name is incorrectly specified
I have read some similar posts. And tried to reinstall oracle several times. But nothing worked.
Environment:
Ubuntu 16.04
Oracle SQL 11g Release 2
Errors I am getting:
sqlplus system
SQL*Plus: ...
0
votes
0answers
1k views
connect to mssql server from php7
I installed mssql and I have a mssql database.
I want to connect to this database through php7.
I'm using PDO
$dbh = new PDO ("dblib:host=hostname:portnum;dbname=dbname" , "username" , "password");
...
0
votes
2answers
132 views
Mysql compressed file .gz unable to extract file part
I have written a bash script for backing up my sql database.
#!/bin/bash
#START
DBNAME=test_uat
host=127.0.0.1
username=root
DATE=`date +"%Y%m%d"`
SQLFILE=spen_db-${DATE}
mysqldump -u $username -p $...
1
vote
0answers
175 views
“socketIO_client not found” and “cannot import sql related function” error when running “github sadit” software in ubuntu 12.04
I am trying to run 'github sadit' software in ubuntu 12.04. It requires to install python socket.io and socketIO-clients. I have python 2.7.3, python 3.2.3, python-dev installed and for socket.io and ...
3
votes
0answers
54 views
replacement for `mk-table-checksum --scheme`
After upgrading to LTS 16.04.1, the mk-table-checksum --scheme generates errors, so tried to find a newer version, but can only find pt-table-checksum, and it doesn't have a --scheme-option.
Also ...
0
votes
1answer
3k views
Do I need to change the mysql.sys password
This is probably a daft question, but do I need to change the mysql.sys password?
After doing a:
SELECT User,Host,Authentication_String FROM mysql.user;
to display the mysql users, hosts and ...
1
vote
1answer
446 views
Help installing DB-main
I want to install a program called DB-main and have the same problem as this person. I have extracted the file and the instructions which say:
Edit the .bashrc file (.profile in some environments) ...
2
votes
0answers
539 views
Permissions issue with all directories
I accidentally screwed up the permissions on my entire Ubuntu installation. While trying to fix an issue with inaccessible folders, I set all directories to be owned by root. I realize I will likely ...
14
votes
2answers
13k views
Not prompted to input the root password when installing mariadb-server on Ubuntu 16.04 LTS
I just had a fresh install on my pc the Ubuntu 16.04 LTS. When I tried to install MariaDB by typing:
sudo apt-get install mariadb-server
The installation went smoothly but during the process I was ...
3
votes
2answers
4k views
How to create a database directory structure for MySQL?
I was following this tutorial:
https://www.digitalocean.com/community/tutorials/how-to-use-mysql-with-your-ruby-on-rails-application-on-ubuntu-14-04
So far, I installed mysql-server mysql-client ...
1
vote
1answer
365 views
Help removing all LAMP, website and related configurations on Ubuntu 16.04 LTS
I'm very new to Ubuntu and I set up a website (mybb forum) by creating a user called webmaster then installing LAMP etc and the website folder was var/www/html.
Anyways everything worked well until ...
9
votes
1answer
5k views
Jetbrains Datagrip icon cannot lock to the launcher
I downloaded Jetbrains' Datagrip application on Ubuntu 16.04 and started it by running it's datagrip.sh file on the terminal. When I try to select Lock to launcher by right clicking it's icon on the ...
0
votes
1answer
2k views
Limited size of MySQL INSERT
I am inserting data from .csv to MySQL database using PHP but I can't INSERT more than 922 lines.
Every time the number of the lines is different, usually it is 841 or 837 but after restart my mysql-...
0
votes
1answer
759 views
“Access denied for user 'root'@'localhost'” when updating vendors in a symfony app while deploying on a remote server
I am trying to deploy my symfony application on a remote amazon server. While updating the vendors using: composer install --no-dev --optimize-autoloader command this error occurs Access denied for ...
