Questions tagged [database]

A database is an organized collection of data for one or more purposes, usually in digital form.

Filter by
Sorted by
Tagged with
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 ...

1 2
3
4 5
7