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.
1
vote
1answer
20 views
Error while installing Oracle 11g in Ubuntu 18.04
Also getting a runfixup.sh script which is also giving error
root@szh-server:/tmp/CVU_11.2.0.1.0_zuman# ./runfixup.sh
Response file being used is :./fixup.response
Enable file being used is :./fixup....
0
votes
0answers
18 views
I am not able to see the postgres databse created by me in the list
Logged into postgres database by following command
sudo -u postgres psql postgres
created a postgres database by following command:
create database tukatechgarmentstore_production
But when I ...
2
votes
1answer
65 views
SQL Server 2019 CTP 2.1 on Ubuntu fails after powering off
I've installed Microsoft SQL Server 2019 (CTP2.1) - 15.0.1100.94 (X64) on my VirtualBox Ubuntu 16.04.5 LTS. Everything seemed to work properly until I've powered off the machine. Since then SQL Server ...
0
votes
0answers
53 views
MongoDb can't work without set dbpath command enabled
I upgraded my mongodb on ubuntu 16.04 from 3.6 to 4 and now I can't start my mongodb. Only if I run this command sudo mongod --dbpath /var/lib/mongodb/ --journal in separate tap and do not close my ...
0
votes
0answers
19 views
How to configure mirror servers in ubuntu server 16.04?
I have 3 servers with the Ubuntu Server 16.04 system and at any time as SQL Server 2017 Developer. I am trying to perform an espionage configuration between these 3 servers (main, mirror and witness) ...
0
votes
0answers
28 views
How to access my online Postgres DB on my local machine in pgAdmin4?
I am able to run command line queries and statements on my online database but not able to create a server instance on my local machine through pgAdmin4.
My local PG admin is running on windows 8 ...
0
votes
0answers
18 views
Can't move mysql datadir to a shared folder on Lubuntu guest virtual machine
Some preliminary specs:
Host: Windows 10.
Guest: Lubuntu 18.04.
MySQL version: 5.7.24 (installed on Lubuntu guest)
I need to move mysql datadirto an external folder that should be accessible by ...
0
votes
0answers
12 views
How we can store MongoDB Installation on specific folder on Ububtu 18.04 LTS version rather than default one
I am newbie on Ubuntu Platform (Past was on Windows 10). I want to create specific directory where my MongoDB data will be store.
Expectation of Designing the Structure
Mongodb is a main Parent ...
0
votes
1answer
70 views
Installation of PostgreSQL-11: Depends: libllvm6.0 (>= 1:6.0~svn298832-1~) but it is not installable
I've added the official repository to my sources.list,
deb http://apt.postgresql.org/pub/repos/apt/ cosmic-pgdg main 11
When I try to install PostgreSQL-11 on Ubuntu Cosmic (18.10), I get the ...
1
vote
1answer
47 views
Should I stop my PostgreSQL server before reboot?
Every week I do an apt-get upgrade and dist-upgrade on the server where my PostgreSQL is running. After that, I do a sudo reboot now.
Should I stop the PostgreSQL service before this reboot?
0
votes
1answer
13 views
VIM returns “Error detected while processing” and “Sorry, the command is not available in this version”
When I run VIM with \e inside of psql, I get
Error detected while processing /home/ecarroll/.vimrc:
line 11:
E319: Sorry, the command is not available in this version: call plug#begin('~/.vim/...
0
votes
0answers
12 views
Updating the OS datetime backwards while mariadb is up causes a hang during daemon stop
When I update the OS datetime backwards while mariadb is running, it causes mariadb to hang when I command it's service to stop.
Why is it hangs and how can I avoid it?
I've also noticed that this ...
0
votes
0answers
74 views
ERROR 2006 (HY000) MySQL server has gone away
There are several question about this error, this one I think it's pretty unusual.
I successfully imported a 6GB sql using MySQL Workbench. Now I'm trying to import another 600MB sql file.
I tried ...
1
vote
1answer
162 views
Mysql (MariaDB 10.3.9) can not start
I updated my mysql and I can't start it now. I try:
sudo service mysql start
Result:
Job for mariadb.service failed because a timeout was exceeded. See
"systemctl status mariadb.service" and "...
0
votes
1answer
214 views
Failed to start MySQL Community Server
A lot of stuff stopped working on my server because the sda3 partition became full. After fixing that issue, I cannot start the mysql service:
root@abcd:~# sudo service mysql start
Job for mysql....
0
votes
1answer
524 views
MariaDB startup failure on Ubuntu 18.04
I have installed MariaDb hundreds of times on previous Ubuntu versions, but on Ubuntu 18.04 I'm struggling. After the installation finishes, once I restart the PC, MariaDB starts for around 2 minutes ...
1
vote
1answer
63 views
I can not get Postgres to listen on anything but localhost
I have been on this for MANY hours and can not understand why Postgres will not listen on anything other than localhost. I an running on Ubuntu 18.04 clean install + Django, Postgres and nginx. All up ...
0
votes
1answer
256 views
Workbench freezes on connecting after Ubuntu 18.04 upgrade
I recently upgraded to Ubuntu 18.04 and started having this issue, I can connect to my local mysql server via the terminal fine using
mysql -u root -p
however when I try to use mysql workbench it ...
2
votes
0answers
155 views
Postgres 9.6.10 pg_hba.conf altered
We have an Ubuntu dedicated server. A couple of weeks ago we started to notice that when the postgresql service restarts, the directory /var/lib/postgresql turns readonly.
We changed the permissions ...
1
vote
0answers
80 views
MongoDB Warning impossible to clear
I'm using Ubuntu 16.04 and MongoDB 4.0.1. When I use mongo shell I got this :
I STORAGE [initandlisten]
I STORAGE [initandlisten] ** WARNING: Using the XFS filesystem is strongly recommended with ...
1
vote
0answers
145 views
Got signal: 11 (Segmentation fault) Mongo DB v4.0.0 [closed]
I am using an AWS t2.micro instance (1cpu, 1gb ram) and Ubuntu 16.04 x86_64. I am getting a FATAL error Got signal: 11 (Segmentation fault).
This seems to match a bug reportedly fixed in version 3.6 (...
-2
votes
2answers
72 views
pg_ctl still pointing to 9.5.4 after upgrade to postgres 10 [closed]
I have updated postgres from 9.5.4 to the latest 10.4 on Ubuntu 14.
But after installing postgres 10 I am seeing
support@platform1:/usr/bin$ ls -lah pg_ctl
lrwxrwxrwx 1 root root 34 Jun 13 08:59 ...
1
vote
0answers
30 views
Can't add new node to Galera Cluster
I have a 5 node Galera 3 Cluster running MySQL 5.6 on Ubuntu 16.04 (I tried running 5.7 but ran into the AppArmor issue).
I'm trying to add another node to the cluster but it continually fails. The ...
0
votes
2answers
176 views
Ubuntu cannot open shared library mysqlx.so
MySQL Server version:
Ubuntu: 5.7.23-0ubuntu0.18.04.1-log (Ubuntu)
MySQL installed using apt-get.
When installing a plugin with the following command:
mysql> INSTALL PLUGIN mysqlx SONAME '...
1
vote
1answer
44 views
error connecting to master 'replica@192.168.57.10:3306' mac-ubuntu
Server info:
Master server (Vmware): Ubuntu 18.04 IP: 192.168.57.10
Slave server1 (Vmware): Ubuntu 18.04 IP: 192.168.57.11
Slave server2 (mac): macOS High Sierra IP: 192.168.0.3
MySQL Server ...
0
votes
0answers
9 views
How to reinstall only Mysql on LAMP?
My MySql stopped working and i dont know why. I've posted the problem in many forums but couldn't find a solution.
Everything on Xampp works well, except MySql.
So how can i reinstall only MySql ...
0
votes
1answer
109 views
MariaDB Galera Cluster on Ubuntu 16.04 does not start after rebooting [closed]
I've installed a MariaDB Galera Cluster on Ubuntu 16.04 in 2 nodes.
Here the info from node1:
root@localhost:~# sudo more /etc/mysql/conf.d/galera.cnf
[mysqld]
binlog_format=ROW
default-storage-...
1
vote
1answer
298 views
Why is MySQL slow on the Ubuntu dedicated machine while fast on the Ubuntu VM?
I have a dedicated machine with intel i5, 8GB RAM, 7200RPM HDD with Ubuntu 18.04 OS. I have installed only MySQL-5.7.22 in it, see the configuration file's content at the end of this question. I ...
1
vote
1answer
757 views
Installing SQL Server, I get unmet dependencies libc++1 and libjemalloc1 but it is not installable
Here is the output,
$ sudo apt install -y mssql-server
Reading package lists... Done
Building dependency tree
Reading state information... Done
Some packages could not be installed. This may ...
0
votes
1answer
406 views
Mysql upgrade 5.7.22 to 8.0, server not starting after upgrade
I followed the upgrade guide Upgrading MySQL.
Already installed version of mysql is 5.7.22
Verified all Upgrade Prerequisites for MySQL 5.7 Installation
SET GLOBAL innodb_fast_shutdown = 1;
then ...
0
votes
0answers
87 views
Intermittend DB service error (Ec2+RDS)
I have a EC2 Ubuntu server with the database as RDS. It is connecting fine and the db connections are low but intermittently showing a DB service error.
SQLSTATE[HY000] [2002] ...
2
votes
2answers
498 views
Moving Postgres 10 data dir on Ubuntu 18
I am trying to move the initial Postgres data dir from
/var/lib/postgresql/10/main
to another harddrive. The harddrive is accessable within the terminal via
/media/chris/Datenspeicher
I used ...
1
vote
0answers
154 views
DPKG error: uninstall percona xtradb server 5.7
Trying to uninstall percona, as I broke installation. No luck:
>$ sudo apt remove percona-xtradb-cluster-server-5.7
Reading package lists... Done
Building dependency tree
Reading state ...
0
votes
0answers
21 views
MongoDB start script - how does it choose configuration file?
I'm new to the MongoDB. I have the MongoDB server version 3.6.5 installed on my Xubuntu 14.04 VM, and I see it running (look at configuration file name):
ps -ef|grep mongodb
mongodb 79884 1 0 ...
-4
votes
1answer
250 views
PSQL copy-paste tab-completion and inserting errant parenthesis
Note, I use tabs. Frequently, when I write answers on this site, I write them in vim with the assistance of vim-surround, especially when I'm migrating a fixed-width table/grid to a DDL. Here is an ...
1
vote
0answers
35 views
Why postgresql can't been accessed after added Datadog agent?
After added Datadog agent for postgresql, restarted Datadog. Reference:
https://docs.datadoghq.com/integrations/postgres/
Then check postgresql status, it's fine. But can't find in the process:
...
0
votes
0answers
26 views
Retrieving Mongo Databases without connecting directly to an instance
Hope someone can help.
I have two MongoDB 3.6 installation set up on Windows Server and Ubuntu. Both installations (Windows and Ubuntu) have 5 databases each including the default databases.
I've ...
0
votes
1answer
979 views
psql gives Invalid data directory error
I have VM with ubuntu 18.04 server installed. I have installed postgres 10 from the repo.
Default installation. I made some connection count related changes in postgres.conf and connection security ...
0
votes
0answers
187 views
Too many open files - Mongodb 3.2.4 , Ubuntu
I have a client's server, with a downed mongod.
The log shows an error on mongodb 3.2.4 and ubuntu 16
Distributor ID: Ubuntu
Description: Ubuntu 16.04.3 LTS
Release: 16.04
Codename: ...
2
votes
1answer
99 views
When trying to connect to an external postgres database using pgAdmin, I get an error
I get the following error when trying to connect:
"FATAL: no pg_hba.conf entry for host "", user "postgres", database "postgres", SSL off"
The db is installed on an Ubuntu machine in Azure. I have ...
1
vote
1answer
465 views
How do I disable MySQL on Linux from starting on boot or statup?
After adding MySQL to Ubuntu, it automatically starts up on server boot. I would like it to not start up with the system.
How can I disable it and manually start it?
1
vote
1answer
60 views
How to synchronize a Windows database for Linux?
I have some database (PostgreSQL 9.5) on a Windows server, and I would like this data to be synchronized to a Linux server, that is connected in an application.
Is it possible to synchronize?
0
votes
1answer
227 views
Unable to add a new connection to server in PostgreSQL using pgAdmin
I am new to PostgreSQL and trying to configure it. After installing the PostgreSQL. I am trying to add a new connection to server using pgAdmin. I know there is a by default created on port 5432 but I ...
0
votes
0answers
63 views
How do I force an update of local transactions when a off line InnoDB multi-primary mode cluster member rejoins the cluster?
How do I force an update of local transactions when a off line InnoDB multi-primary mode cluster member rejoins the cluster?
GOAL:
Small office with <50 users. Each user will work on a desktop ...
2
votes
1answer
205 views
How to change MySQL InnoDB cluster from single primary mode to multi primary mode?
My goal is to setup, in a lab environment, a MySQL InnoDB cluster in multi-primary mode.
I have read much, but I cannot get this setup to work.
Ubuntu 16.04.3 server LTS x 3
SQL0 - SQL2
Ubuntu 16....
3
votes
2answers
43 views
Connect to SQL Server on Linux over the network
I have setup Microsoft SQL Server on an Ubuntu VM.
I know how to connect to SQL Server on Windows using SSMS -> but unfortunately I can not install SSMS on Ubuntu.
Which leads me to the question ...
4
votes
2answers
4k views
Can Microsoft SQL Server be installed on Ubuntu 18.04 LTS?
Trying to install SQL Server on Ubuntu 18.04, I'm getting
# sudo apt-get install -y mssql-server
Reading package lists... Done
Building dependency tree
Reading state information... Done
Some ...
0
votes
1answer
51 views
SSL errors with Couchdb on Ubuntu 14.04
I am beginning to set up CouchDB on an Ubuntu 14.04 Server (yes, it expires next year) and I'm having troubles setting up SSL connections. For the moment, I don't have any CA signed certs for it, so I'...
0
votes
1answer
262 views
MySQL Group Replication stuck on RECOVERING
I'm testing MySQL Group Replication.
Environment:
Microsoft Azure
Ubuntu 16.0.4
I've followed this guide:
https://www.digitalocean.com/community/tutorials/how-to-configure-mysql-group-replication-on-...
2
votes
1answer
218 views
Flask mongodb assertion 13 not authorized for query on flask_session.sessions
Need help resetting mongodb back to its original state.
We have a flask app running with mongodb with authentication turned off. Running on Ubuntu with std Flask. We tried ALL sorts of combinations ...
