Skip to main content
Share Your Experience: Take the 2024 Developer Survey

Questions tagged [ubuntu]

Ubuntu is a desktop and server operating system based on Debian GNU/Linux. Note that http://askubuntu.com is specifically dedicated to Ubuntu questions.

Filter by
Sorted by
Tagged with
0 votes
0 answers
13 views

Ubuntu How to change the username PGAdmin tries to use to login

I uninstalled Postgresql and PGAdmin4 from ubuntu and installed them back but, now, when I open PGAdmin and click on servers/local, it requests for the password of a user no longer exists and there's ...
HuLu ViCa's user avatar
  • 141
0 votes
1 answer
26 views

SQL and Management Nodes on same server in NDB cluster. SQL Nodes not connecting

I've setup a ndb cluster with 7 nodes. 3 data nodes on their own servers, and 2 management nodes that each have a sql node on them on 2 servers. I've narrowed down what I think my issue is. My cluster ...
Mr. Berzerk's user avatar
0 votes
1 answer
25 views

Mongod starting issue on ubuntu

When I try to check the status of mongodb I get the following: × mongod.service - MongoDB Database Server Loaded: loaded (/lib/systemd/system/mongod.service; enabled; vendor preset: enabled) ...
Rime Tazi's user avatar
0 votes
0 answers
13 views

Why does removing `skip-grant-tables` cause resource conflict error for mysqld?

After hours of searching, I have managed to narrow a mysqld issue down to a point, which I cannot find reason for. I am attempting to launch multiple instances of mysqld on my Ubuntu server. When ...
user10709800's user avatar
0 votes
0 answers
18 views

How do I convert master-slave to multimaster database replication in MySQL?

Currently, I have one master and two slaves in my setup. How can I convert it so that I have three masters instead? I need all three nodes to be writable and to update each other accordingly. Most of ...
flyerz's user avatar
  • 1
0 votes
3 answers
146 views

Mariadb threads blocking randomly

We have a mariadb instance hosted on Ubuntu 22.04. We are regularly seeing some threads getting stalled on relatively high activity tables(although the tables are not huge ones). Once stuck, it never ...
vamyip's user avatar
  • 121
0 votes
0 answers
114 views

Moving MysQL data directory error: Can't create test file mysqld_tmp_file_case_insensitive_test.lower-test

I'm trying to move mysql datadir to another location on external drive which is formatted with ext4. I'm betting following error: # lsblk -f .. sdb ...
Vaughn's user avatar
  • 101
1 vote
0 answers
27 views

Failed to start MySQL Community Server on Ubuntu 20

I'm currently facing an issue with starting MySQL on my Ubuntu system. Upon attempting to restart the MySQL service, an error message stating 'Failed to start MySQL Community Server' appeared. As part ...
user avatar
0 votes
1 answer
35 views

Ram usage increases in MySQL after backup

I have a mysql 8.0.31 running in docker form (the server is running ubuntu) the problem i am having is that after each backup that i run (i run it every hour) the ram consumption increases and never ...
Pablo Arriola's user avatar
1 vote
1 answer
83 views

How should I troubleshoot a very slow MySQL server droplet?

I'm new to the DBA forum, but not SO, and I've searched for answers on this, and tried what I've found. We have a Rails app that lives on a Digital Ocean droplet, and a bigger and more powerful ...
nimmolo's user avatar
  • 111
0 votes
1 answer
21 views

mysql configuration file order of read

I was reading about my.cnf in mysql docs and I dont understand this part On Unix and Unix-like systems, MySQL programs read startup options from the files shown in the following table, in the ...
user avatar
1 vote
0 answers
47 views

PostgreSQL isn't using all available vCPUs of the VM

Running some procedures takes too much time and if I check htop I can see just one vCPU of the Ubuntu VM that is running and the others aren't: postgresql.conf max_connections = 50 shared_buffers = ...
Saad elMoustarhfir's user avatar
1 vote
0 answers
46 views

How would I connect to a SQL Server (running in a VM using Ubuntu Server), using Access or Visual Studio on my host?

I have tried to connect various ways already and have not been successful. I need a more specific guide on how to/if you can connect this way. I have specific limitations that you need to account for, ...
Vividlee's user avatar
0 votes
1 answer
143 views

Can't link building C++ application with pqxx library

I had to re-install my operating system and I switched from Ubuntu 22.04 to Linux Mint 21.2. I installed PostgreSQL 16 from the postgres repository. It seems to work fine. Then I downloaded libpqxx 7....
Zephyrus's user avatar
  • 301
1 vote
0 answers
83 views

Odoo 16 restoring 350 MB database Ubuntu Nginx

What I am trying: I am trying to restore Odoo 16 enterprise database with size 350MBs and I am using Digitaloceans and Nginx as a proxy. Error I am getting: Error Code: 413 Request Entity Too Large ...
Tele oceans's user avatar
0 votes
0 answers
21 views

SSMS. Anyway to connect via AWS session-manager to an mssql instance?

I have a sqlserver (express) instance running on an ubuntu server ec2 instance. This is on an AWS private subnet so I cannot just open port 1433 for sql access. We use AWS session manager to connect ...
Jamie GF's user avatar
1 vote
2 answers
96 views

Safe upgrade routine for Cassandra

I've been tasked with upgrading an Ubuntu based Cassandra cluster - having no prior experience with Cassandra. I've tried digging through the docs but have been unable to find any instructions on how ...
azzid's user avatar
  • 113
0 votes
0 answers
127 views

Moving from MySQL to MariaDB, slower performance with some query's

recenty we've have moved all of our server to new hardware and to MariaDB . I've installed a new server with VirtualMin for managing all of our company's applications. at a first glance most of the ...
Stefx's user avatar
  • 9
0 votes
0 answers
52 views

Problem restoring partial mariabackup

I follow this method to perform a partial and incremental backup of my database on two servers, bskpserver and devserver. Everything works fine except for some tables. When I try to restore them on ...
elarichi.y's user avatar
0 votes
1 answer
36 views

OS Upgrade Path for DB and Application

Are there any best practices which define which Operating System Upgrade Path we should choose and any rational behind it? Path 1: Upgrade Database OS then Upgrade Application OS. Path 2: Upgrade ...
Veeru Sharma's user avatar
-1 votes
1 answer
454 views

How do i fix "InnoDB Plugin initialization aborted with error Generic Error"

i am running a Nextcloud Server on a Ubuntu 20.04 which was running fine. I wanted to upgrade the Nextcloud Version and make a backup before. This is what i did: plugged in a external harddrive (/dev/...
user avatar
0 votes
1 answer
59 views

postgres was not the same version as pg_ctl in PostgreSQL 12

As per the log files, I am getting the below errors. The program "postgres" was found by "/usr/lib/postgresql/12/bin/pg_ctl" but was not the same version as pg_ctl. Check your ...
Anubhav Ranjan's user avatar
0 votes
1 answer
124 views

Galera Cluster Upgrade

I have 3 node Galera Cluster on Ubuntu 18.04. As part of Ubuntu LCM, I'm upgrading my Setup to 22.04 along with this Galera MariaDB cluster will also upgrade. I have designed below plan to upgrade my ...
Veeru Sharma's user avatar
0 votes
0 answers
93 views

Cannot connect to PostgreSQL DB over a Virtual IP (VIP)

I am running a PostgreSQL DB Server v12.16 on an Ubuntu 20.04 virtual machine. When I attempt to connect to DB directly from host, it WORKS! When I attempt to connect to DB via the VIP, it DOESN'T ...
user3051574's user avatar
0 votes
1 answer
32 views

Cannot access MySQL on Ubuntu remotely

I installed MySQL on DigitalOcean Droplet Ubuntu. Here is the solution I tried but not working Changed the bind-address to 0.0.0.0 in /etc/mysql/mysql.conf.d file Created an user whose host value is %...
hh54188's user avatar
  • 101
0 votes
0 answers
324 views

TimeZone Setting On PostgreSQL Databases

I have a Patroni cluster with two Ubuntu 22 db server. The timezone of my instances was set to UTC. I have needed to edit them to set the local timezone to Europe/Istanbul. I have made the timezone ...
user avatar
1 vote
2 answers
683 views

Assigning multiple IP addresses to MongoDB 7.0 on Ubuntu

The Problem I am trying but failing, in MongoDB 7.0, on Ubuntu, to bind multiple IP addresses to net.bindIp in mongod.conf What I have tried I have tried 127.0.0.1,x.x.x.x, 127.0.0.1;x.x.x.x, [127.0.0....
Yenmangu's user avatar
0 votes
0 answers
1k views

PostgreSQL Server Timeout Issue with pgAdmin, pgAdmin Web, and DBeaver

I am using PostgreSQL 15.4 on Ubuntu 22.04. Initially, I used pgAdmin 4 for managing the database. However, I've been facing an issue where pgAdmin stops responding after some time. This issue seems ...
Purushottam Nawale's user avatar
0 votes
0 answers
57 views

How to create replica set of mongodb in ubuntu and enable it?

I am using MongoDB community edition in Ubuntu 22.04. How can I make replica set in my local machine and how can I enable it to use in my node js application?
user avatar
0 votes
1 answer
410 views

Cannot restore MySQL into existing DB - get ERROR 1050 (42S01): Table 'blahblah' already exists

I can restore from mysqldump wordpress-db > mysqldump-wpdb.sql to new DB fine with $ sudo mysql wordpress-db001 < mysqldump-wpdb.sql But if the DB already exists (as they generally do with a ...
TickboxPhil's user avatar
0 votes
1 answer
39 views

mongod binary path is not obtained by "db.serverStatus().process" on Ubuntu 20.04

I am unable to get mongod binary path using "db.serverStatus().process" on Ubuntu 20.04. I need to incorporate this command in a script. But "db.serverStatus().process" gives just '...
satya's user avatar
  • 11
0 votes
1 answer
659 views

Error when trying to view data in PGAdmin4, PostgreSQL10, on Ubuntu 22.04

I've installed PGadmin4 on my Ubuntu 22.04 system, with this repository : https://ftp.postgresql.org/pub/pgadmin/pgadmin4/apt/$(lsb_release -cs) pgadmin4 main PGAdmin4 runs, but if I want to see ...
V Damoy's user avatar
  • 103
0 votes
1 answer
469 views

Postgres service does not start after abrupt reboot

Postgres 9.6.1 does not start automatically after an "abrupt" reboot (Ubuntu 18.04). Postgres service is configured to start on reboot, but the server does not come up at all! The only way ...
Christian's user avatar
  • 335
0 votes
3 answers
893 views

How can I purge MySQL binlogs if MySQL is turned off

I am using Digital Ocean droplets for my WordPress Site. There are more than 60 binlog files in /var/lib/mysql. Most of the solutions say that I should purge them from MySQL. The storage is so full ...
Sky Lurk's user avatar
  • 101
0 votes
1 answer
145 views

Upgrade Pgbouncer

I need some advice for upgrading pgbouncer. I couldn't find any document which tells me how to upgrade pgbouncer. I tried the command apt install pgbouncer I wonder if there is another good, ...
user avatar
0 votes
1 answer
494 views

I can't connect MySQL (on Ubuntu 22.04 Host) connect to remote server (Ubuntu 22.04 on VMWare Guest)

I want to create new MySQL connection to remote Django server that is inside virtual machine on VMWare (located at address 127.0.0.1 on port 33061). The problem is that MySQL shows the message "...
Abstract _42's user avatar
0 votes
0 answers
85 views

Mysql on ubuntu 20.04 access just stops

I have been wrestling with mysql for some time and just did a clean install of ubuntu 20.04 myqsl 8.0 and my lamp server. got everything back to where I was all running fine and then access denied ...
Tom Jerram's user avatar
0 votes
1 answer
343 views

How to install MySQL Server 8.0.33 on Ubuntu 20.04 with FIPS enabled without encountering the 'Unable to determine if daemon is running' error?

Installing MySQL Server 8.0.33 on a Ubuntu 20.04 server with FIPS enabled results in an error. This error doesn't occur when installing the previous MySQL Server version (8.0.32). The error also doesn'...
Nate's user avatar
  • 11
-1 votes
3 answers
622 views

I am very frustrated by problems trying to set up mysql-cluster. There are no service files for NDB daemons

I am trying to get mysql-cluster going on Ubuntu 22 from the official MySQL apt repo. I keep running into complications. Certain ndb-related daemons are required ... like ndbd. But there are no ...
elyograg's user avatar
  • 103
0 votes
1 answer
586 views

Error after changing/moving mysql datadir in ubuntu sys

I followed the answer in the Q&A Moving the MySQL data directory Ubuntu 16.04. However, it's not working and gives me the following error: mysql.service - MySQL Community Server Loaded: ...
evol's user avatar
  • 11
0 votes
2 answers
250 views

Can't drop an NDB database because the storage engine is unavailable

I tried to set up a MySQL cluster and failed. I finally got it switched back to standard MySQL, but now I have an ndbinfo database that I cannot drop. It causes my automysqlbackup cron job to report ...
elyograg's user avatar
  • 103
0 votes
1 answer
32 views

What is the connection between Evolution, Berkeley DB and SQLite format 3 (Ubuntu 22.04.2 LTS)

I'm wondering what the connection is between Evolution Database Server (EDS), Berkeley DB and SQLite format 3. When I look at the dependencies for EDS (for example here), I see that libdb5.3 (Berkeley ...
Ray Culp's user avatar
1 vote
0 answers
300 views

PostgreSQL data_directory doesn't match value set in postgresql.conf [closed]

I've recently updated from version 14 to 15 and I can't figure out why it's still using the data directory for 14. I've verified that I'm using version 15. $ sudo -u postgres psql -V psql (PostgreSQL) ...
bdoubleu's user avatar
  • 111
1 vote
1 answer
3k views

Cannot connect on psql specifying connection string postgres

On my Ubuntu machine, I have installed postgres 15. I created a new superuser called "test" (with password "test"). Then, I created a database called "test" as well and ...
aprospero's user avatar
  • 111
0 votes
1 answer
317 views

MongoDB Server on Ubuntu Crashes again and again

The mongodb server on my ubuntu Virtual Private Server Crashes on regular basis. mongod.service - MongoDB Database Server Loaded: loaded (/lib/systemd/system/mongod.service; enabled; vendor ...
sameer arora's user avatar
0 votes
1 answer
278 views

Import big mongodb bson archive > 300Mb

I've installed mongodb the next way on Ubuntu 20.04: wget -qO - https://www.mongodb.org/static/pgp/server-6.0.asc | sudo apt-key add - echo "deb [ arch=amd64,arm64 ] https://repo.mongodb.org/apt/...
Gryu's user avatar
  • 285
0 votes
1 answer
597 views

Why is there no performance_schema.threads?

I am trying to diagnose an issue where a phpBB message board hangs (becomes unresponsive) for about five minutes about once every hour. (It is not exactly on the hour every hour, but it is a little ...
Robert K S's user avatar
1 vote
1 answer
291 views

Allow connection to mongo only from my server droplet

Recently I created a server with MongoDB preinstalled on a DigitalOcean droplet following these tutorials DigitalOcean - Initial server setup DigitalOcean - How to secure MongoDB on Ubuntu Medium - ...
Fernando's user avatar
0 votes
2 answers
6k views

How to install mongodb 3.6 on ubuntu 22.04

Installing mongodb 3.6 on ubuntu 22 keeps throwing this error!! The following packages have unmet dependencies: mongodb-org-mongos : Depends: libssl1.0.0 (>= 1.0.2~beta3) but it is not installable ...
user avatar
1 vote
0 answers
874 views

Getting error as "ERROR: permission denied for schema public" while executing a sql script in Postgres sql

I am using ubuntu 18.04 and running postgres sql in a docker container running on port 5432 on a VM powered by GCP. First of all I entered sudo -u postgres psql to enter into the database as ...
Talib's user avatar
  • 11

1
2 3 4 5
13