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

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
0 votes
0 answers
16 views

Failing to connect PySpark Session to Snowflake. DATA SOUCE NOT FOUND error

I am running this code on jupyter notebook through Ubuntu. I'm pretty sure the main issue is probably a compatibility with the JAR files but I am not sure. spark = SparkSession.builder \ ....
Orange010's user avatar
1 vote
2 answers
44 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
86 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
35 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
-1 votes
1 answer
28 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
0 votes
1 answer
72 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
30 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
0 answers
26 views

Mariadb 10 doesnt start after server crashed [closed]

I hope you can help me here with my problem to get my DB back up and running. Yesterday, Strato crashed the node on which our VM is running. And now the DB is not running anymore. :-( The mysqld does ...
TheFreeman's user avatar
0 votes
1 answer
30 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
35 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
29 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
102 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
0 votes
1 answer
242 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
438 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
37 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
138 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
36 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
558 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
225 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
  • 325
-1 votes
0 answers
139 views

MySQL CPU 200% - 300% Help me! [closed]

Good morning everyone, I write to you because I'm desperate and I can't find the solution: I have mysql CPU going over 200-400% causing me to slow down and almost crash the only website hosting the ...
user avatar
0 votes
3 answers
316 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
0 answers
81 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
335 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
76 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
270 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
343 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
287 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
172 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
24 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
170 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
2k 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
231 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
0 answers
127 views

Import error 31 on SQL Server RESTORE

Background I'm attempting to build a vagrant box to share amongst the dev team who use a variety of different languages and systems. One of the databases is SQL Server. I have successfully set this up ...
elb98rm's user avatar
  • 133
0 votes
1 answer
168 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
  • 275
0 votes
1 answer
389 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
243 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
3k 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
697 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
5 votes
3 answers
946 views

Differences in PostgreSQL 14 collation behavior on Linux and Mac

I have PostgreSQL installed on my Mac and Ubuntu Server as shown below: atsweb=# select version(); version ...
Christian Alis's user avatar
1 vote
1 answer
86 views

How can i solve Statement failed problem?

I am trying to connect FDB file on Ubuntu. ubuntu@me:/opt/firebird/bin$ sudo ./isql Use CONNECT or CREATE DATABASE to specify a database No entry for terminal type "xterm-256color"; using ...
sunShine's user avatar
0 votes
1 answer
1k views

PostgreSQL directories explained

I almost 'randomly' dig into some of the classical PostgreSQL installation folders on Ubuntu 22.04.1 and I was naively wondering what exactly are the following different postgres directories intended ...
s.k's user avatar
  • 342
1 vote
1 answer
84 views

Backing-up Postgresql data when only root login is available (Ubuntu)

I have a Ubuntu-based workstation with several boot issues that prevent any user login - only logging in as "root" works. Before formatting the Ubuntu partition to perform a clean ...
Louis15's user avatar
  • 113
0 votes
0 answers
2k views

Sequelize and Mysql throw connect ETIMEDOUT error

Hello everyone this is my first time here but I'm a quite desperate with this situation, I hope you can help me. I have a nodejs server with express and sequelize. When I was in development enviroment ...
Gamaliel Castro's user avatar
0 votes
1 answer
109 views

CRONTAB fail to work

I have cronjob suddenly fail to work. I have pgdump to execute the following command: pg_dump -h 127.0.0.1 -Fc --dbname=postgresql://postgres:[email protected]:5432/db_XP -f /b ...
padjee's user avatar
  • 167
2 votes
1 answer
106 views

MySQL suddenly blocks access from particular IP

I'm using MySQL 5.7.40 on Ubuntu 18.04.6 LTS (GNU/Linux 4.15.0 x86_64) I didn't make any changes since weeks. My websites are on another server. So it's a remote connection. Since some hours ago my ...
David's user avatar
  • 121
0 votes
0 answers
68 views

mariadbd 10.5.18 seems to stop working

I've got a three node galera cluster (mariadb 10.5.18, ubuntu 20.04.5 LTS) with a haproxy as loadbalancer in front of it. Normally, there are up to 80 tcp based connection from a java application, ...
Mrk's user avatar
  • 1
2 votes
1 answer
4k views

Which command to use to restart postgresql 12 service

I am about to restart postgresql 12 service running on Ubuntu 18. First, I check it's status : sudo service postgresql status. Its says : postgresql.service - PostgreSQL RDBMS Loaded: loaded (/lib/...
padjee's user avatar
  • 167
0 votes
1 answer
419 views

How to install MySQL on Ubuntu 22.04LTS?

I want to install the latest version of MySQL on my Ubuntu 22.04.01 LTS desktop, then try to use it as a local database, but I have been confused because there are a lot of different files here: https:...
best_of_man's user avatar
8 votes
1 answer
10k views

What does PostgreSQL Status active (exited) mean?

I have PostgreSQL with PostGIS intalled on Ubuntu 22.04. I can access the PostGIS-Layers from QGIS and work with them. When i check the status of PostgreSQL with: sudo systemctl status postgresql it ...
fsg's user avatar
  • 183

1
2 3 4 5
12