Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [database]

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

0
votes
0answers
5 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
1answer
36 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, ...
0
votes
0answers
23 views

Is it possible for me to deploy Ubuntu studio tools in Ubuntu Canonical 18.04LTS?

I have a powerful machine that is a laptop with Nvidia Gforce graphics, 1TB HDD, 16gigabytes RAM and an i5 processor. I have already installed Ubuntu 18.04 LTS, and since I don't have another machine ...
0
votes
0answers
10 views

Importing data into database(Valentina Studio) [closed]

In my database there are 100 tables. but 1 table is there which contains 4 crore data but useless. I need to import data to other system. while importing how can i ignore that table which contains ...
0
votes
1answer
140 views

Error while configuring ORACLE 18c XE

I have installed the rpm of 18c express edition. But while configuring the database Iam getting the below error root@venky:/opt/oracle/cfgtoollogs/dbca# /etc/init.d/oracle-xe-18c configure /etc/init....
0
votes
0answers
88 views

DataGrip MySQL connection: user/password combination is rejected

In DataGrip, I have this error when I try to test the connection to my local MariaDB instance: The specified database user/password combination is rejected: [28000][1045] Access denied for ...
0
votes
0answers
23 views

dconf database how to remove duplicate & triplicates?

My dconf database ~/.config/dconf/user/ has many entries that are duplicated or triplicated. Some are "normal" single entries. To display gsettings in GUI I used this one-liner answer. Then I: ...
0
votes
0answers
18 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
2answers
227 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 ...
0
votes
1answer
87 views

Which database type is /etc/aliases.db?

Which database type is /etc/aliases.db? It is not SQLite, MySQL or PostgreSQL.
3
votes
2answers
209 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 ...
0
votes
0answers
37 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 ...
0
votes
0answers
35 views

Oracle Standard edition Installation

I know this question has been asked a lot in this forum and i tried various blogs to install the Oracle 11g R2 standard edition in my Ubuntu 16.04 but with no luck. I am stuck at this for over a week. ...
0
votes
0answers
35 views

How to backup mysql database to remote server

How to backup mysql database to remote server (windows file sharing/ftp server) using a cron job?
0
votes
0answers
68 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 ...
0
votes
0answers
202 views

Oracle XE ( 11.2.0 ) Database Configuration failed on Ubunto 14 and 16

I am facing Error while configuring Oracle XE after installation. I Follow this Tutorial How to install Oracle 11gR2 on Ubuntu 14.04? When I run this statement for database Configuration. /etc/...
0
votes
0answers
39 views

Problem Installing Oracle 10g XE R2 on ubuntu 14.04

Im facing the below error on installing oracle 10g XE R2 in ubuntu 14.04. root@ubuntu:~/Downloads# dpkg -i oracle-xe_10.2.0.1-1.0_i386.deb (Reading database ... 202492 files and directories ...
-1
votes
1answer
145 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 ...
4
votes
0answers
855 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
50 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
1answer
99 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....
1
vote
2answers
991 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:...
0
votes
1answer
712 views

Database connection error

I never used Ubuntu, and now I installed Ubuntu 18.04, and I have a problem with connection to Database. I'm not so familiar with the working with servers and things like that, so can anyone tell me ...
0
votes
0answers
47 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
1answer
581 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
1answer
73 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 ...
0
votes
0answers
54 views

how to edit/view/access the var/cache/apt/pkgcache.bin

as the pkgcache.bin and scrpkgcache.bin in the folder /var/cache/apt/ contains detail information about any package, can I access to these files to edit or copy information?
5
votes
4answers
12k views

Install mysql 5.6 on Ubuntu 18.04 LTS

I'm unable to install mySql 5.6 on my newly installed Ubuntu 18.04. I have tried solution from lots of links ( link1 link2 ... ) but no success at all. I have 5.7 installed, but due to client's ...
1
vote
1answer
2k views

Ubuntu 18.04 MSSQL Repos

I'm excited to see the release of 18.04. My build needs the ability to connect to a MSSQL server running on Ubuntu 18.04 via PHP. Has a repo been released for mssql-server on this version of Ubuntu?
2
votes
1answer
951 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:- ...
0
votes
0answers
24 views

I can't install languages or anything else

Software database broken: pablow@pabluntu:~$ sudo apt-get install -f [sudo] password for pablow: Reading package lists... Done Building dependency tree Reading state information... Done ...
1
vote
0answers
32 views
1
vote
0answers
64 views

How can I assign a column to represent the x axis values in libre office calc?

Currently my attempt at making a chart looks like this: The goal, nonetheless Is that subdivisions, should be the x axis and not a series of data entries in the chart. I have looked it up but I am ...
1
vote
0answers
27 views

Watchdog on cloud based server and database?

I am running a cloud based server and two database. I have python scripts that connects to the databases and moves data between them. When the cloud databases have been updated or outages, the ...
0
votes
0answers
12 views

Contest web server keeps restarting in CMS(Contest manegment system)

I have set up CMS on my PC. When I try to run cmsResourceService -a All the services work except for ContestWebServer , PrintingService and ProxyService because they keep restarting. When I access "...
-1
votes
1answer
60 views

Is there a freeware program for databases similar to Microsoft Access? [duplicate]

Is there a freeware program anyone can recommend that is comparable to Microsoft Access? I need to store a lot of data and want to access it quickly by category and query.
-1
votes
1answer
781 views

install robot 3t :- usr/local/bin/robomongo/lib’: Directory not empty [duplicate]

I am trying to install robo3t in ubuntu 14.04 new in linux Those commands work wget https://download.robomongo.org/0.9.0/linux/robomongo-0.9.0-linux-x86_64-0786489.tar.gz tar -xvzf robomongo-0.9.0-...
0
votes
1answer
769 views

Pgadmin4 not running in python 3.6 and Ubuntu 17.10

I am new for pgadmin4. I have installed python 3.6. I try to install pgAdmin4 with this guide. But I am not able to run the pgadmin. Here are the commands I ran with the error messages: (pgadmin4) ...
0
votes
0answers
2k views

Is the server running locally and accepting connections on Unix domain socket “/var/run/postgresql/.s.PGSQL.5432”?

After some time the Postgres database stopped working. when I try to enter the command, psql produces an error psql: could not connect to server: No such file or directory Is the server ...
0
votes
1answer
110 views

Database backup

I want to take backup of Xampp database available in /opt/lampp/var/mysql `but I am unable to do it. I used below command /opt/lampp/htdocs/vivek.s$ sudo mysqldump -u root -p vive.se > 07feb....
2
votes
1answer
854 views

mysql_connect error

I've executed the below command in sublime text editor mysql_connect('localhost','root',''); And got the below error: Fatal error: Uncaught Error: Call to undefined function mysql_connect() in /opt/...
0
votes
1answer
969 views

Creating database access denied

Here is what I've done: user@name /my/path # mysql -u root -p<myPassword> mysql> create database spy; ERROR 13 (HY000): Can't get stat of './spy' (Errcode: 13 - Permission denied) How can ...
-2
votes
3answers
3k views

mysqldump a zipped dump

Till now I've created and zipped mysql dumps this way: mysqldump -u root -p --all-databases > /var/www/html/db-$(date +\%F-\%T).sql zip /var/www/html/db-$(date +\%F-\%T).zip /var/www/html/db-*.sql ...
0
votes
1answer
225 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-...
0
votes
0answers
169 views

large data import phpmyadmin

I Cannot import the database on my local ubuntu16.04 phpmyadmin. I'm getting this error while trying to import. [enter image description here][1] You probably tried to upload a file that is too ...
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
2k views

Freetds can't connect to MSSQL

I had to upgrade to php 7.1 and then my connection to mssql via freetds aren't working PHP 7.1.12-1+ubuntu16.04.1+deb.sury.org+1 Ubuntu 16.04.3 LTS SQL Server 2008 r2 The tsql -C tsql -C Compile-...
4
votes
3answers
14k views

Where is mongo database folder on the filesystem

I'm using Ubuntu 16.04. I have set up a database MongoDB. When I start it (with mongod command) it says that database is located at /data/db (dbpath=/data/db). The database works fine. But in files ...
1
vote
1answer
302 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
159 views

DHCP server & MAC address

I have database, where are MAC addresses stored and base on that database I assigned the static IP address to them. Is there a way to automatically assign the IP address to users, who don't have MAC ...