Questions tagged [database]
A database is an organized collection of data for one or more purposes, usually in digital form.
338
questions
2
votes
2
answers
326
views
How can I get pictures from Shotwell on the notebook to the desktop?
My father has a desktop and a notebook. The desktop is way more powerful and has RAID set up, so he uses it for editing and storing his pictures. But he spends several months a year away from home. So ...
0
votes
1
answer
328
views
how to connect to mongodb remotely
How can I remotely access my mongodb database using compass? I have followed the instructions here, but compass cannot connect and shows me connect ECONNREFUSED MY_SERVER_IP:27017. What is missing or ...
0
votes
2
answers
5k
views
Setting up postgresql on another SDD
I am new to the server part of ubuntu. I am setting up a server with ubuntu 14.04 LTS OS installed. I have two 1TB sata disks and two 2TB sata disks(configured with RAID 1 for both). I am using the ...
2
votes
1
answer
2k
views
18.04 - Not able to connect to mysql
So I've been trying to setup my new work development system, I have gotten everything installed and setup properly except MySQL. I've been trying everything I can even think of to gain access to mysql ...
0
votes
2
answers
634
views
Kodi hangs on splash screen at first run; apparent database error in logfile
On a freshly installed 64bit Ubuntu 18.04 system with Intel graphics, a freshly installed kodi hangs at the splash screen. The log file appears nominal until the last three lines.
2019-09-15 08:17:...
0
votes
1
answer
603
views
Host local database using ubuntu for external applications
I am trying to build an Android application and I need to install a database to store all my data like users, passwords etc. This is the first time when I do something like this and I dont have a clue ...
1
vote
1
answer
522
views
Installing CKAN 2.8.2 in Ubuntu 18.04
I am trying to install CKAN 2.8.2 in Ubuntu 18.04 following these instructions.
I have followed all steps successfully, until step 4.2 with sudo ckan db init.
I get the following error:
Traceback (...
0
votes
0
answers
228
views
Can't start postgresql 9.6
Hi from one day to another day postgresql didn't start :(.
When I type: psql then this error appears:
could not connect to server: No such file or directory Is the server running locally and ...
4
votes
2
answers
1k
views
Any good SQL shell programs?
I want to practice SQL commands on Ubuntu. I would just like to play with different commands and keywords. Where can I find something that helps?
I don't want to install any server. I need a small ...
13
votes
4
answers
20k
views
SQL modeling and design tools?
I would like to know which tool do you use for modeling tables, relationships, etc, generic database modeling, in Ubuntu.
It would be good if that tool generate SQL scripts, and a plus with those ...
2
votes
2
answers
4k
views
phpliteadmin cant find sqlite3
I installed sqlite3 using sudo apt-get install sqlite3. I also installed phpliteadmin in the var/www folder. When I go on phpliteadmin, it says it cant find sqlite3 and sqlite3database. How do I fix ...
1
vote
0
answers
57
views
Log message to database whenever an email arrives
Does anyone have a script that will log a message to a database anytime an email arrives? I'm referring to a native imap server running on ubuntu. I'd like to log a message anytime any email arrives ...
1
vote
2
answers
21k
views
Oracle Database Express 11.2 job for oracle-xe.service failed
Environment:
Ubuntu 14.04
Oracle Database Express 11g Release 2
I'm receiving an error by starting service oracle-xe
systemctl status oracle-xe.service
● oracle-xe.service - LSB: Oracle 11g ...
1
vote
0
answers
1k
views
Having Problems loading JDBC driver on LibreOffice Base
I'm trying to open a .mdb file by following the instructions from Gord Thompson in Is it possible to open an Access 2010 database file without using Wine or VirtualBox? .
Though I do everything as ...
0
votes
1
answer
105
views
how to send 150 GB of data from server to server
I have 2 Ubuntu 18.04 dedicated servers and I want to copy 150 GB of data from desktop on server 1 to desktop on server 2.
I have XRDP access.
6
votes
2
answers
24k
views
sqlcmd not available after installing mssql-tools
I'm trying to access sql server database so i need sqlcmd but after following microsoft docs here and here. Running sqlcmd returns:
sqlcmd: command not found
and I do have mssql-tools installed:
...
0
votes
1
answer
146
views
How to connect locahost with my outside Database
i to want to connect from my Computer to my outside Database .
SSH information from my Web-Host
SSH IP: .224.138.
SSH Port: 65002
SSH Username: 2907*****
SSH Password: ***********
I have a ...
1
vote
0
answers
838
views
Problem with Oracle Database XE Install on Ubuntu 18.04
I am newbie with Ubuntu, but I'm trying to install Oracle Database XE 11g, using this tutorial:
Link to Ubuntu Tutorial
My Ubuntu isn't 14-04, it's 18.04, but I cam getting this error on
Step 4. ...
0
votes
1
answer
1k
views
percona-server-server-5.7 not available anymore?
I followed the APT installation instruction here https://www.percona.com/doc/percona-server/5.7/installation/apt_repo.html
but it seems not working anymore with this error message
root@server# apt-...
0
votes
1
answer
2k
views
"Error: unable to open database" when creating sqlite3 database in terminal
The other questions I've seen deal with this have to do with creating databses through Django or some other Python framework. I am simply trying to create a database with $sqlite3 database.db. It ...
1
vote
2
answers
9k
views
Automatically deleted MySQL database table when restart server
I installed LAMP server on my Ubuntu 12.04 Server PC. I changed the database storage location using my.cnf. After I changed the location it's working fine. But if I restart my MySQL database is ...
1
vote
1
answer
725
views
darktable error locking database
My Darktable application is not working. The software just does not start and sometimes it shows the error:
darktable error locking database ~/darktable/data.db
the database lock file contains a pid ...
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 ...
4
votes
1
answer
8k
views
allow remote mysql access (through webmin or shell)
Spec:
Ubuntu 14.04
webmin/virtualmin 1.791
I am using following code to test remote mysql database connection:
<?php
$db_host = "123.456.789";
$db_name = "database";
$db_user = "user";
$db_pass =...
1
vote
1
answer
1k
views
Can't access PostgreSQL after crash restart, reports dbus error
I was running Postgresql database v9.6 and I rebooted, but now it will not start. Nothing seems to work. Any idea?
I am trying to run my Django Server:
django.db.utils.OperationalError: could not ...
0
votes
1
answer
4k
views
Failing to install MongoDB on ubuntu 18.04
Trying to install the community version of mongo on ubuntu 18.04.
Below are my unsuccessful attempts , if you don't have time - just go directly to the result in attempt #3.
Attempt #1
Using ...
0
votes
1
answer
63
views
Connect mysql to website using php [closed]
How to connect my database wich is create in mysql in terminal?
0
votes
0
answers
469
views
Computer shutdown running command 'dpkg --configure -a'
Whenever I'm installing a package I get the following error:
E: dpkg was interrupted, you must manually run 'dpkg --configure -a' to correct the problem.
I've had the problem before, but now ...
2
votes
1
answer
7k
views
Installing firebird 2.5 on ubuntu 18.10
I want to install firebird 2.5 server on ubuntu 18.10
I followed this installing firebird 2.5, but got stuck in
sudo add-apt-repository ppa:mapopa
it says error
E: The repository 'http://ppa....
0
votes
3
answers
918
views
I want to install and get to building a personal MySQL DB
So how do I go from installing MySQL from the Software Center to inputing data into fields and bringing in a comma delimited file?
I've only had brief experience with MSAccess and OOo Base a long ...
0
votes
1
answer
150
views
How do I make my bash script output data correctly?
I'm struggling with some code I've been writing all day and I'm at a loss, basically, what the code is supposed to do is output a .csv file with all the data in the second to last echo statement, ...
3
votes
2
answers
5k
views
sh script for executing mysql script with entering pass
I'd like to execute a mysql script where the user is asked to enter the password dynamically from the command line, if possible with a message Enter your $root password.
However it doesn't work as ...
3
votes
2
answers
8k
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 ...
0
votes
0
answers
70
views
How to make Oracle database services not start when I turn on my laptop
How do I get Oracle Database Express Edition 11g Release 2 services to not start at boot until I manually activate them? As it is, I have to run sudo service oracle-xe stop to stop the services every ...
0
votes
2
answers
4k
views
'Can't connect to local MySQL server through socket '/path/mysql/mysqld.sock' (2 "No such file or directory")'
After I have changed the datadir of my MariaDB (Ubuntu 16.04), I cannot restart mysql anymore.
I changed the path of the data directory in the /etc/my.cnf file. But if I try to start MariaDB with ...
1
vote
1
answer
964
views
Which database type is /etc/aliases.db?
Which database type is /etc/aliases.db?
It is not SQLite, MySQL or PostgreSQL.
1
vote
0
answers
508
views
Installing Oracle Database (Apex)
I have been trying to install Oracle Database 11g Xpress and I followed the instructions here. Everything went fine. In the end, when I try to start the program using:
sudo /etc/init.d/oracle-xe ...
16
votes
5
answers
41k
views
Postgresql server not started in ubuntu 14.04
My problem is after postgresql installed try to configure postgresql database it's show error message like below:
dineshlap@ss-laptop:~$ sudo -u postgres psql postgres
psql: could not connect to ...
0
votes
0
answers
118
views
MariaDB error on a fresh install of Ubuntu 16.04
Yesterday I installed Ubuntu 16.04 on a real machine, not a virtual one.
And right away installed mariaDB from:
apt install acl apache2 composer fping git graphviz imagemagick libapache2-mod-php7.0 ...
-1
votes
1
answer
2k
views
ERROR 1006 (HY000): Can't create database 'random' (errno: 15435840)
I'm having trouble creating a database on MySQL. I just made a fresh install of Ubuntu and i was installing MySQL but when i access as a root with:
sudo mysql -u root -p
And then I tried to create ...
2
votes
2
answers
4k
views
How to install Rethinkdb in Ubuntu?
I have installed Rethinkdb for a project I am doing with Node.js following the steps of the Rethinkdb website.
But after executing rethinkdb in terminal inside the folder /rethinkdb-2.3.6, it returns:...
3
votes
5
answers
16k
views
Error while installing DBeaver On Ubuntu 14.04
I am trying to install Dbeaver 3.5.6 on Ubuntu 14.04, but it shows some Java run-time missing error even though I've Java7 installed on my system.
Here's how I tried to install
user@Demo:~/Downloads$...
0
votes
1
answer
223
views
Creating database from encrypted external drive (veracrypt + postgreSQL)
I hope I correctly suspect this to be a problem of Ubuntu rather than postgreSQL 10 which I am using. I have an external SSD that is encrypted and mounted to /media/veracrypt1/.
When trying to create ...
0
votes
1
answer
658
views
Unable to resolve host address while installing neo4j database on ubuntu 16.04. How to solve this?
How to solve this?
sudo wget -O - https://debian.neo4j.org/neotechnology.gpg.key | sudo apt-key add -
--2018-07-07 17:23:46-- https://debian.neo4j.org/neotechnology.gpg.key
Resolving debian.neo4j....
0
votes
0
answers
215
views
Error setting up dpkg-dev and fakeroot
When I tried to set up dpkg and fakeroot, I got this error:
Reading package lists... Done
Building dependency tree
Reading state information... Done
build-essential is already the newest ...
0
votes
1
answer
3k
views
Configuration Issue For OpenVswitch Version 2.8.1 on Ubuntu 16.04
I am a new user on Linux platform, I have tried to install openvswitch 2.8.1 on Ubuntu 16.04; but after installation I am observing below error.
root@syed-VirtualBox:/home/syed# ./openvswitch.sh
ovs-...
2
votes
1
answer
3k
views
MongoDB after-installation error, couldn't connect to server
I was following the (https://docs.mongodb.com/manual/tutorial/install-mongodb-on-ubuntu/) instructions to install MongoDB.
After completing till 4th step, i.e., after running the following command:-
...
2
votes
1
answer
13k
views
How to view the data from a .mysql file?
I have a .mysql database file. I need to open it and view the data. I've MySQL Server & MySQL Workbench installed into my Ubuntu 14.04.
Now how do I open the .mysql file and view the data inside ...
0
votes
1
answer
1k
views
Ubuntu upgrade 17.10 to 18.04 moved my MariaDB database to folder /var/lib/mysql-10.2 and downgraded MariaDB from 10.2 to 10.1
[This is more of a How-To-Post]
Ubuntu upgrade process to 18.04 had a window asking me what I wanted to do with my MariaDB install -- install MariaDB in Debian, or keep my install (a working MariaDB ...
2
votes
1
answer
143
views
Give a user access to a database, but not to containing folder
I am making a program in python that stores and modifies the stock of a little shop, using SQLite databases.
Each employer is going to be a user at a Linux system, and a user at the program. As the ...