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.
591
questions
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 ...
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 \
....
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 ...
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 ...
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 ...
-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 ...
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/...
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 ...
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 ...
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 ...
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 ...
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 %...
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 ...
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....
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 ...
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?
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 ...
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 '...
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 ...
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 ...
-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 ...
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 ...
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, ...
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 "...
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 ...
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'...
-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 ...
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: ...
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 ...
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 ...
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) ...
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 ...
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 ...
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 ...
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/...
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 ...
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 - ...
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
...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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,
...
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/...
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:...
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 ...