Questions tagged [database]
A database is an organized collection of data for one or more purposes, usually in digital form.
336
questions
3
votes
1
answer
38
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: ...
- 31
0
votes
0
answers
49
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:
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 ...
- 5,485
0
votes
1
answer
2k
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 ...
- 247
0
votes
0
answers
143
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 ...
-1
votes
1
answer
161
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 ...
- 1
0
votes
0
answers
100
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 ...
0
votes
1
answer
97
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 ...
0
votes
1
answer
267
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 ...
- 11
0
votes
1
answer
225
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: ...
0
votes
0
answers
241
views
MySQL service is masked
I have installed MySQL version 5.7 on an Ubuntu machine (v20.04.5). The mysql server instance runs properly for days and then on its own the corresponding mysql service becomes masked.
I then unmask ...
- 1
0
votes
0
answers
2k
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/...
- 19
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
219
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
33
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 ...
- 1
0
votes
0
answers
1k
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 ...
- 11
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
839
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 ...
- 175
1
vote
1
answer
679
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&...
- 11
1
vote
0
answers
59
views
Firewall setting are correct but port still closed form outside
I setting up machien for connect to postgresql remotly
I check somthing and it's apeare all things is correct
Checking the port status :
$> sudo netstat -tulpn | grep LISTEN | grep 5432
tcp 0 0 0....
- 11
1
vote
0
answers
184
views
Enabling password authentication for new postgres user
How do I make ubuntu prompt me for a password after creating a new postgres user. It doesn't ask for a password with the postgres user but I want to change this under an added user
- 41
0
votes
0
answers
153
views
Set up Postgres
I recently istalled PostgresSQL , but when I enter psql to the terminal, if gives me the error:
psql: error: connection to server on socket "/tmp/.s.PGSQL.5432" failed: No such file or ...
- 55
0
votes
1
answer
499
views
Can I run MS Access with Ubuntu? [duplicate]
I do have Ubuntu but wondering if I can run MS Access on Linux? I really need it for college. I do have Windows 10 but I rather use Linux.
Does it work with Wine?
- 81
0
votes
2
answers
2k
views
Trouble installing MongoDB on Linux Ubuntu 20.04
Others have asked this question, but I have found no answer that works for me. I am trying to install MongoDB on Ubuntu 20.04. I have been following the guide at https://docs.mongodb.com/manual/...
0
votes
1
answer
62
views
server not rendering website after failed mysql server configuration
I started getting this error when I installed mysql_server on my server as root, I am using ufw, I don't know if I am supposed to allow mysql server through my ufw if I am supposed to, I don't know ...
0
votes
0
answers
1k
views
MongoDB failed to start Ubuntu 18.04
I installed mongoDB using this link www.digitalocean.com
on sudo systemctl status mongod I get the following errors
● mongod.service - MongoDB Database Server
Loaded: loaded (/lib/systemd/system/...
0
votes
1
answer
46
views
which mongoDB should I download?
I'm using Ubuntu 20.10 and I need to download mongoDB Community Server. but in the documentation they don't say which version is supported.
so please tell me which version I need to download and how ...
- 1
0
votes
0
answers
67
views
newer to coding not sure if this is the correct way to manage variables for a project anyone have a second to help me?
Here is a log (I've only included the matching lines there is a lot of other stuff in the real log)
/home/steam/pavlovserver/Pavlov/Saved/Logs/Pavlov-backup-2021.07.07-08.51.08.log:[2021.07.06-17.30....
1
vote
1
answer
2k
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 ...
- 83
0
votes
0
answers
35
views
(Ubuntu server 20.04) MySQL DB failing to reinstall
I tried to make a login system but inexperienced in servers and backend as I am, I followed two tutorials with different login credentials for the DB and now I've locked myself out. The first password ...
- 1
0
votes
0
answers
424
views
Error: Could not find or load main class oracle.net.ca.NetCA
I'm getting this error message, how do I fix it?
2
votes
0
answers
192
views
dbeaver, font problem
I have problem in DBeaver with russian (azbuka) chars. Everything was fine, but now I see this.
It is on OS level or it is app related? How can I fix it? OS Ubuntu 20.04.
Thank you.
- 840
0
votes
0
answers
40
views
After updating to Ubuntu 20.04.2 LTS. Access 2016 tables stored on the server are behaving strangely
I have a microsoft access table backend stored on the server and 4 users on windows desktops logging into database with the tables being used as link tables.
This has been running since 14.4 upgrade ...
- 21
1
vote
0
answers
667
views
Not able to start mysql service in Ubuntu 20.10
Issue Details:
I was running MySQL v8 on one of my Raspberry Pi 4 (8 GB) for a few months, however the I am unable to start mysql using sudo service mysql start since morning and receiving below error ...
0
votes
0
answers
192
views
Trouble wih bundle exec rake install
I am getting this rake aborted message after running bundle exec rake install command for git repository project I am working on.This is the code of trace of operations and error message.
/home/...
0
votes
1
answer
715
views
Use port 995 for MYSQL on ubuntu 20.04 server
In my MYSQL configuration file, when I replace port 3060 (original) by 995, that don't work, when I service mysql restart, I have:
Job for mysql.service failed because the control process exited with ...
- 13
1
vote
1
answer
459
views
How to change field name in LibreOffice Base?
I have table as shown below
Then I tried to format the field.
Why there is no option to change the name? It is possible to change the field name?
- 123
0
votes
1
answer
996
views
database import error using pgadmin 4 v4.28 in ubuntu20.4
I m trying upload database file in local server which name postgresql pgadmin4 v4.28 and facing request timeout issues how can solve this ?
I m also increase max upload file limit and have made ...
1
vote
2
answers
24k
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 ...
- 11
0
votes
1
answer
3k
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:~$ ...
- 1,064
0
votes
2
answers
445
views
Why doesn't MariaDB or MySQL start?
Apparently purging, and/or reinstalling mysql and mariadb can cause conflicts, so tried:
root@mordor:~#
root@mordor:~# sudo apt purge mariadb-server mariadb-client mysql-client mysql-server
Reading ...
- 1,064
0
votes
1
answer
244
views
What does grep -cE ">" myfile.txt do?
I understand how to use grep; however, I am having trouble understanding the function of using ">" in my command?
- 11
1
vote
0
answers
124
views
pgAdmin4 will open as if it was a book after switching desktop environments
I use KDE Plasma on Ubuntu. I started a session on regular Ubuntu desktop then switched back. Now, pgAdmin will open on Calibre (ebook management sofware). I tried running pgadmin4 directly on the ...
- 73
0
votes
1
answer
132
views
Where is the database for feedreader?
It's implied:
https://code.launchpad.net/~eviltwin1/feedreader/sqlite
that feedreader uses sqlite or that it can be configured to do so.
I looked in the .config folder, but didn't see anything ...
- 1,064
0
votes
1
answer
4k
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
0
votes
1
answer
38
views
How do I Install Ubuntu for all my purposes by removing Windows 10 without loosing my other data files?
I have installed a SATA 480 GB HDD dedicated for the C drive. This does not have any partition. I kept the old HDD with the PC and that has 4 partitions. I also added an 8 GB of RAM with the previous ...
-1
votes
2
answers
178
views
Databases for a single user, is there a non server mode?
I want to store and query large amounts(possibly millions of rows) of stock market data in database. I'm going to be the only user. It's on my desktop machine. The last time I did extensive work on ...
- 96
0
votes
1
answer
541
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 ...
3
votes
3
answers
4k
views
How to install emma for ubuntu 20.04?
I cannot install emma database GUI for Ubuntu 20.4.
$ sudo apt update
$ sudo apt install emma
Reading package lists... Done
Building dependency tree
Reading state information... Done
E: Unable ...
- 111
2
votes
1
answer
83
views
Downloading mongoDB error
Last month downloaded mongoDB onto my Ubuntu 20.04 using sudo apt install mongodb-org I found the package, installed it and mongodb was working fine. I however deleted it and when I try reinstalling ...
- 121