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
0 answers
26 views

email scrap and send software [closed]

any email send and scrape software for ubuntu lunbuntu for free or cheap? Cant get scrape to work. any way to collect and gather emails on 22.04 unbuntu or lunbuntu? any free or cheap chrome ...
0 votes
1 answer
6k views

how to fix Error: Port conflict: another instance is already running

I fired two command sudo apt-get update sudo apt-get upgrade It will give me error after upgrade(after press "Y") Setting up postgresql-9.1 (9.1.19-0ubuntu0.12.04) ... * Starting ...
0 votes
1 answer
52 views

Running Java code in Ubuntu 22.04 distributive

I'm new in this field, and trying to do some tests using java in Ubuntu I wrote a code in Java to connect my localhost mssql server and create a new database. the code is tested on windows and it's ...
1 vote
0 answers
37 views

How do you access and modify data on an IDB file in Ubuntu?

I am running a mobile and web app off of Docker, the data is stored in a mysql folder under various files with extension .idb Is there a way to modify this data directly in the server i.e. using PUTTY ...
2 votes
1 answer
4k views

Create firebird database in specific directory

I want to be able to create a firebird database in a specific directory. I know that the firebird user needs to have r/w/x permissions to the directory where I want to create the db. I created a group ...
0 votes
1 answer
4k views

How to run and configure postgres when installed from snap?

Having installed postgres how do I now use it? postgres@mordor:~$ postgres@mordor:~$ whoami postgres postgres@mordor:~$ postgres@mordor:~$ pwd /home/postgres postgres@mordor:~$ postgres@mordor:~$ ...
0 votes
1 answer
5k views

Can't install or uninstall oracle-database-ee-19c on my Ubuntu 20.04

So I tried to install Oracle 19c database on my Ubuntu 20.04 (as in my pc, not a virtual machine or anything, my OS is Ubuntu itself) I downloaded the .rpm file instead of the zip (there was no deb ...
1 vote
3 answers
5k views

MythTV cannot connect to database

I'm new to Ubuntu, just installed Mythbuntu 12.04.3 (64-bit) from an iso (single fontend/backend combo). Seemed to instal fine, rebooted my machine only to find I was faced with a screen asking for ...
1 vote
2 answers
28k views

Cannot use psql "sudo: unknown user" "sudo: unable to initialize policy plugin"

I've been working on a bot for Discord which utilizes a PostgreSQL database and I'm trying to install it on a Vultr server (Ubuntu 20.04). Everything is working fine until I get to the part where I'm ...
0 votes
3 answers
5k views

MariaDB bind-address not updating?

I'm trying to set the bind-address of my MariaDB installation to 0.0.0.0 to allow external connections. I edited /etc/mysql/mysql.conf.d/mysqld.cnf and updated the [mysqld] section to the following: ...
1 vote
1 answer
8k views

Can't login to pgadmin4

I've successfully installed postgres and pgadmin4. When I try to access pgadmin4 in the browser I'm being asked to login in with an email and password. What should I do?
21 votes
5 answers
74k views

Install postgresql. Why is initdb unavailable?

I'm following these instructions, however I can only get to step 17.2. Despite installing postgresql successfully via the sudo apt-get install postgresql command, upon running initdb -D /usr/...
3 votes
6 answers
32k views

How to log in to MySQL shell when the user has no password?

I got this error: root@sys3026:/home/sys3026# mysql --user=root --password Enter password: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) Any one please ...
1 vote
2 answers
1k views

How to import multiple postgres databases using single file in another ubuntu installation?

Is there a way to move all databases from Pgadmin 3 one ubuntu installation to another. I have created a big dump (a single file to export all database from one system). Now I want to import that big ...
-2 votes
1 answer
783 views

HOW to INSTALL Libre Base in Ubuntu OS?

Why no is there no Libre Base included with Libre applications that came with Ubuntu? HOW do I INSTALL Libre Base in my Ubuntu OS? Yes I've tried searching this online. So far found nothing that works ...
22 votes
2 answers
110k views

Remove MariaDB (MySQL) Databases

How do I completely remove MariaDB so I can reset the root password?
1 vote
0 answers
250 views

After installing SQL*Plus, how do I find out the default username and password in my 20.04 ubuntu?

Results of the sqlplus command:
3 votes
1 answer
97 views

Installing DBSqlite Browser on Ubuntu

I tried to install DBSqlite Browser for Ubuntu and Derivatives. After installation, I enter the command to open Ubuntu in the terminal: "sqlitebrowser" and the following crashes: qt.qpa.xcb: ...
37 votes
5 answers
152k 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 ...
0 votes
0 answers
18 views

Is there a class of Application that combines MQTT and a RDMBS?

I am planning to install Ubuntu on a Raspberry Pi substitute (Libre lePotato): https://hub.libre.computer/t/ubuntu-server-vs-desktop-vs-base/2218 The goal is to setup a portable MQTT server that ...
0 votes
1 answer
5k views

"Unable to connect to server: connection failed: FATAL: password authentication failed" on brandly installed postgres and PGAdmin4

I want to create a new server and a new postgres database from the PGAdmin4 UI just-installed on Ubuntu 22.04 I already did this before but I don't remember how did I do id. The server I created last ...
0 votes
1 answer
4k 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
0 answers
248 views

mysql workbench login error but working on terminal

mysql-workbench is throughing some error but it works in terminal i have installed mysql and set user and password by using sudo codes in Ubuntu. but when i open mysql-workbench, it shows the same ...
36 votes
4 answers
67k views

ER diagram software

ER diagram software for Ubuntu?
-1 votes
1 answer
243 views

how to export db sql database to microsoft access database mdb?

i need to export a database in "db" format to access database "mdb" in Ubuntu db browser for sql lite don't have the option to export to mdb - it just have the option to export to ...
0 votes
0 answers
161 views

Installation problem of MongoDB in Ubuntu 20.04

This message show in terminal.... You might want to run 'apt --fix-broken install' to correct these. The following packages have unmet dependencies: mongodb-org-database : Depends: mongodb-org-server ...
1 vote
1 answer
778 views

mongod cmd won't connect after downloading MongoDB

I have an issue where I cannot connect to the MongoDB server using the cmd mongod after downloading MongoDB. this is what the terminal shows when using mongod: $ mongod {"t":{"$date&...
0 votes
1 answer
231 views

Install mutillidae and DVWA on the same machine?

I am using Ubuntu 22.04.1 LTS, I installed mutillidae and it worked perfectly, but now I wanted to install DVWA and it also worked, but when I entered mutillidae again I got this error: " The ...
7 votes
4 answers
43k views

adminer- None of the supported PHP extensions (MySQLi, MySQL, PDO_MySQL) are available

whenever i login to the adminer, it always show: No Extension None of the supported PHP extensions (MySQLi, MySQL, PDO_MySQL) are available. I just installed this a while ago using ...
0 votes
1 answer
395 views

400% CPU usage on Linux server

Recently we moved our full stack website to new server (Vultr instance). After moving to new server we are constantly getting 400% CPU usage issue. It's been fifth day since we are getting 400% CPU ...
0 votes
1 answer
327 views

Increase Mysql row size

When I run a laravel migration i get an error complaining about row size how can i solve i have run a couple of commands but not changed anything SQLSTATE[42000]: Syntax error or access violation: ...
4 votes
4 answers
27k 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
0 answers
3k views

postgres 12 suddenly stop accepting connection: connection to server on socket "var/run/postgresql/.s.pgsql.5432 failed no such file or directory

I don't know whats going on, my database just stop running. suddenly when I want to run postgres using user postgres ($postgres psql), it gives me error "connection to server on socket "var/...
13 votes
4 answers
80k views

How can I open .db files?

I've imported a .db file from my android device and I wish to open it using Libreoffice Base or something similarly basic with a simple GUI. How do I achieve this?
0 votes
1 answer
20 views

Directory CMDs are not working [duplicate]

I am unable to trigger commands in my command line for example, :~$ cd downloads Bash: cd: downloads: Bo such file or directory
1 vote
3 answers
248 views

Why do I need to use backslash or escape character in order to access a sql file i.e. "/home/algolix/Downloads/poolstore_co_uk_primary\ .sql"

I'm trying to import mysql database using: mysql -u root -p poolstore < /home/algolix/Downloads/poolstore_co_uk_primary.sql but I can't and it says: No such file or directory however, when I ...
0 votes
0 answers
47 views

Installing Kingbase Database

I have been trying to install KingbaseES Database and I followed the instructions here. Everything went fine. In the end, when I try to start the program using: sudo /etc/init.d/kingbase-xe start It ...
73 votes
13 answers
188k views

What is a good MongoDB GUI client?

I've been using Rockmongo on Windows - it's a php based web tool. But on Ubuntu (12.04) it's behaving funny - queries timing out often - and I'm looking for better clients. Does anyone know anything ...
1 vote
1 answer
3k views

How can I see only the database I have access to in pgAdmin 4?

I created a free postgres database on Heroku, when connecting it to my pgAdmin4 the connection is done normally, however, thousands of databases appear along with mine. All the databases that appear I ...
2 votes
2 answers
5k views

Wine ODBC connection to local PostgreSQL database

I'm running PostgreSQL server which I want to access from program under wine. I installed necessary wine software to be able to make ODBC connection. But is it possible to access local PostgreSQL ...
2 votes
1 answer
1k views

PHP's UTF-8 charset does not match SQL Server's latin_1 charset

My site has a webform and its submission data is written to a Microsoft SQL Server table. My site is built on a PHP / Apache / Ubuntu-Server stack. The charset of the website is UTF-8, but the charset ...
1 vote
2 answers
6k 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 ...
0 votes
1 answer
557 views

Can't Remove or Install Mysql in ubuntu

I tried to remove the mysql-server but i got this problem 0 upgraded, 0 newly installed, 1 to remove and 0 not upgraded. 2 not fully installed or removed. After this operation, 111 kB disk space will ...
11 votes
4 answers
42k views

64-bit DB2 10.5 missing 32-bit libpam and 64-bit libaio on Ubuntu 12.04

This happened to me. If it's happening to you, maybe this can save you a bit of time. I was installing 64-bit DB2 10.5 server (not sure exactly what product package -- someone gave it to me) on a ...
0 votes
0 answers
2k views

Cannot find TOCBLOCK, database may be corrupt

I opened Logs today and saw this error which says: ldm_parse_tocblock(): Cannot find TOCBLOCK, database may be corrupt. I am NOT dual-booting, my PC is running under Ubuntu 20.04.3 LTS version, any ...
0 votes
1 answer
2k views

Postgresql 12 shuts down randomly

I'm using ubuntu 18.04 and postgresql 12, See journalctl below: Dec 16 09:39:19 server sudo[55084]: postgres : TTY=unknown ; PWD=/var/lib/postgresql/12/main ; USER=root ; COMMAND=/usr/sbin/sysctl ...
-1 votes
1 answer
1k views

java.net.ConnectException : Error connecting to server localhost on port 1,527 with message Connection refused (Connection refused)

I'm running into problems with the use of Apache Derby with IntelliJ's Ultimate edition. When creating the Data Source and Drivers, after filling the form, I test the connection and I get the ...
2 votes
3 answers
7k views

Lost ability to connect remotely to Firebird database after upgrading to Ubuntu Server 13.10

I decided to upgrade my Ubuntu server from 13.04 to 13.10. When finished, I lost the ability to remotely connect to my Firebird 2.5 database (works locally / 127.0.0.1)! I didn't change anything in ...
1 vote
2 answers
14k views

How to install Redis-Server 6.0.1 in Ubuntu 20.04?

I have Redis version 5.0.7 in my system, is there any command to update to 6.0.1?
1 vote
1 answer
815 views

How to restore my Firebird database and modify owner settings in a single command line?

I am using Ubuntu 18.04.4 LTS and I've recently upgraded from Firebird 2.5 to Firebird 3.0. Prior to upgrading, I was restoring my local database with the following unzip&replace command: zcat /...

1
2 3 4 5
7