Questions tagged [centos-7]
The centos-7 tag has no usage guidance.
1
vote
2answers
56 views
PostgreSQL 11 error: column p.proisagg does not exist
Using phpPgAdmin v5.6 and PostgreSQL v11.2 on CentOS v7, when I try to access the Functions tab within the public schema, I get the following error:
ERROR: column p.proisagg does not exist
LINE 18: ...
0
votes
1answer
51 views
How to remote connect with PostgreSQL 11 CentOS server?
My Server: CentOS 7 x64, PostgreSQL 11.2
My Client: Navicat, pgAdmin 4.5 . Error at client:
FATAL: no pg_hba.conf entry for host "14.248.254.146", user "postgres", database "postgres", SSL off
I ...
0
votes
0answers
33 views
InnoDB full of data dead
I have a DB in server that gives this error after filling the database with 12GB of data
2019-03-22 07:50:05 18705 [ERROR] Can't open the mysql.plugin table.
Please run mysql_upgrade to create it....
0
votes
1answer
27 views
MongoDB Replication Set Configuration Issue on CentOS 7
My mongodb instance will not run as standalone and I haven't been able to discover why. Its probably something simple. Please point me in the right direction.
Linux myserver 3.10.0-514.el7.x86_64 #...
0
votes
1answer
33 views
how to install PL/SQL Developer on centos
Can we install and run PL/SQL Developer on CentOS 7 server? I couldn't find installation documents anywhere. If the installation is possible can someone guide me on this.
1
vote
0answers
240 views
mysql 8 is failure to start after upgrade from 5.7
I've upgraded one of the slave server from mysql 5.6 to 5.7 and now 5.7 to 8.
But after up-gradation steps done when i use systemctl start mysqld.service or systemctl restart mysqld facing error and ...
0
votes
1answer
168 views
Oracle 11g stuck at installation in oracle linux no error msg only showing | and stuck
oracle not install on centos7 while installation it is stuck at 84% no error msg showing
0
votes
1answer
43 views
MariaDB replication from master to slave
After doing some research around this topic, I should be attempting this task soon. However, I have two questions going around my head - could do with an experienced professional answering them.
I am ...
0
votes
1answer
339 views
Change in bind_ip value is not reflecting
I have mongo installed on Centos instance in AWS and I am connecting to the mongoDB server from my system. To connect from remote system we need to change bind_ip value to 0.0.0.0 in /etc/mongod.conf ...
0
votes
2answers
6k views
psql: FATAL: password authentication failed for user “postgres”
I am running postgresql-9.6 on Rhel7. I know that the default/root user doesnt have a password, however i will like to use phpPgAdmin to do my work. the problem is I have edited my pg_hba.conf file to ...
0
votes
1answer
974 views
Cannot login to postgres with newly created users
I have created a number of users in postgres using createuser --interactive --password but whenever I run sudo -i -u newuser I receive the following error:
sudo: unknown user: staging
sudo: unable to ...
1
vote
0answers
170 views
Error on cassandra-3.11.3-1.noarch centos7
I've a cluster consisting of 5 cassandra nodes. The cassandra version used is
cassandra-3.11.3-1.noarch
The keyspace strategy and is defined as follows:
CREATE KEYSPACE my_keyspace
WITH ...
2
votes
1answer
64 views
Database Directory storage is full need to change link it to new Partition
My mysql Database Directory size is full. So I want to change it to another partition where there is large amount of space. The database version am using is MySQL 5.7.23 and OS is CentOS 7.
After ...
1
vote
1answer
546 views
Parse error in pg_hba.conf [closed]
Hope this is not as stupid a question as I think it is. But I'm in a loop and unable to find a solution.
I installed Postgres in centos machine. The installation worked fine (apparently). Now I have ...
1
vote
2answers
49 views
SQL Server 2016 - write output file to mapped Samba share (CentOS 7)
I have a stored proc that's going through the tables, getting data, and write the result into a csv file (mainly to provide up to date data for FTP customers).
When writing it to the local D: drive, ...
1
vote
2answers
494 views
Unable to Restart PostgreSQL after attempting to move pg_xlog to different partition
I am having problems getting PostgreSQL back up and running on my CentOS 7 server.
Some Context:
After noticing that I was quickly running out of storage space on the /root partition of the server, I ...
0
votes
1answer
1k views
Binding specific ips with Mongodb
I am using Mongodb 3.6.3 on Centos 7.
I am running the below command:
sudo mongod --storageEngine wiredTiger --dbpath /data --bind_ip_all --logpath /var/log/mongodb/mongod.log --fork
and ...
0
votes
1answer
281 views
Mongodb 3.6.3 disappears after 2 weeks on centos 7 ec2 instance
My Mongodb has disappeared 2 times, after 2 weeks, over the weekend within a 4 week time period.
I had a snapshot to recover from but I can't keep on recovering my db every 2 weeks. In an ec2 ...
3
votes
4answers
446 views
How to best store pixels in a database?
When loading data into a table, I get the following error:
ERROR: row is too big: size 8680, maximum size 8160
The table has 1000+ columns in it, which appears to be the problem. The general ...
5
votes
5answers
49k views
How to restart PostgreSQL server under CentOS 7
I installed PostgreSQL 10.1 under a CentOS 7.3 environment.
The service is started (postmaster.pid file present under /var/lib/pgsql/10/data), but I need to reload configuration or restart the server ...
0
votes
2answers
156 views
Mysqld process not showing all options on command line in CentOs 7
Mysqld process showed all config file options on command line in CentOs 5 and CentOs 6. But its not showing the same in CentOs 7. I am using mysql 5.7.21 on CentOs 7 example stated below and 5.7.19 on ...
0
votes
1answer
803 views
MongoDB 3.4 Server not starting with bind error following a CentOS 7.4 security update
MongoDB 3.4 server is failing to start following a CentOS security update and reboot.
No configuration changes made. The previous update and reboot a couple of days earlier did not cause any ...
1
vote
1answer
5k views
How to install pgcrypto extension in postgres 10 on CentOS 7
I'm in the process of creating a postgres database for production in CentOS 7. So I already installed (yum install postgresql10-server postgresql10 after adding the repos of course) and configured ...
0
votes
1answer
194 views
Issue with MongoDB Replication Set
I have 3 "CentOs 7" VM's in AWS environment in which I have setup MongoDB Repication Set using below command.
mongod --fork --logpath "/var/rs1/1.log" --replSet yogi --dbpath "/var/rs1/" --port 27017
...
0
votes
1answer
1k views
MongoDB Replication - “Failed with No route to host”
Hi,
Running MongoDB version 3.4.9 on two separate servers running Centos 7.
Trying to add a create a replica set but when ever I try to add a second server I get this error:
devshardcfgrs:PRIMARY> ...
0
votes
1answer
966 views
How to do PostgreSQL replication on CentOS 7?
Followed this guide to do the PostgreSQL replication:
https://www.digitalocean.com/community/tutorials/how-to-set-up-master-slave-replication-on-postgresql-on-an-ubuntu-12-04-vps
I didn't do this:
...
0
votes
1answer
2k views
Can't add another node from primary node with MongoDB replication set
On CentOS 7.
MongoDB version: 3.2.15
There are two nodes:
node1
node2
node1
/etc/hosts
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4 node1
::1 localhost ...
2
votes
2answers
6k views
Can't run rs.initiate() when do mongodb replication set
Using CentOS 7.
MongoDB version: 3.2.15
Hostname: node1
Make directory:
mkdir /mongo-metadata
/etc/mongod.conf
# mongod.conf
# for documentation of all options, see:
# http://docs.mongodb.org/...
0
votes
1answer
207 views
Free space after removing ibdata1 file
My ibdata1 file was taking up a lot of space so I followed the steps explqined on How to shrink/purge ibdata1 file in MySQL
However after deleting the ibdata file and recreating the DB I'm still not ...
1
vote
1answer
2k views
Node unable to join a MariaDB Galera Cluster
I'm trying to setup a third node for my MariaDB cluster. I copied over the server.cnf file from my second node (which joins the cluster and can start its own cluster). The first two work fine using a ...
6
votes
3answers
12k views
Resolving port 5500 not free issue during Oracle 12c Release 2 Database Configuration Assistant installation on CentOS
Background
I am attempting to install Oracle 12c on CentOS 7 (deployed as a Hyper-V virtual machine) as outlined by this installation guide.
Problem
Everything with my installation goes well except ...
1
vote
1answer
299 views
How to avoid intermittent “duplicate entry” error on slave when replicating mysql.time_zone_transition?
Rarely, but intermittently, MariaDB 5.5 fails to replicate the timezone tables onto a completely new replica (instance creation is all automated, so there's no room for missing/changed steps). We ...
0
votes
1answer
2k views
ERROR! MySQL is running but PID file could not be found - MariaDB 10.1 - CentOS 7 - Fresh VM
So I'm having a little trouble with a BRAND new VM I just created today to test a Galera Cluster.
What I have done so far is...
Download and install the latest CentOS 7 in a VM.
Install open-vm-...
1
vote
2answers
4k views
Install mysql-workbench failed: Requires: proj, tinyxml, python-paramiko >= 1.15.1
I am installing mysql-workbench to migrate Postgres database to Mysql.
OS System Version: Red Hat Enterprise Linux Server release 7.2 (Maipo)
I am installing mysql-workbench and follow these ...
1
vote
1answer
63 views
How to debug trivial MariaDB query with simple execution plan which often runs really slowly?
The query (with literal ? for dynamic query goodness):
SELECT UNIX_TIMESTAMP(my_timestamp_field) AS my_name
FROM my_table
WHERE my_column=?
This query is one of the most common in my slow query ...
1
vote
2answers
7k views
How to properly change “innodb_buffer_pool_size” value for mysql?
I have following environment:
# cat /etc/redhat-release
CentOS Linux release 7.2.1511 (Core)
# rpm -qa | grep ^mysql-community-
mysql-community-common-5.5.48-2.el7.x86_64
mysql-community-libs-5.5....
1
vote
1answer
572 views
Can't promote PostgreSQL warm standby server to start serving data
Scenario:
Two CentOS 7 machines, with ips 10.0.2.15 and 10.0.2.4
Both running PostgreSQL 9.4.6. First one (10.0.2.15) as master, and second one (10.0.2.4) as slave, not listening for clients (just ...
2
votes
1answer
1k views
postgresql 9.3: two instances on same port and two different ip adresses don't work
i'm setting up multiple instances of postgres 9.3 on the same machine (centos 7). I have 2 virtual ip addresses, one instance is bound to first address and second is bound to second one. Same ...
