Questions tagged [database]
A database is an organized collection of data for one or more purposes, usually in digital form.
340
questions
-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 /...