Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange
Make your voice heard. Take the 2019 Developer Survey now

Questions tagged [centos-7]

The tag has no usage guidance.

1
vote
0answers
13 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
38 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
26 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 ...
-1
votes
0answers
19 views

Can not start mysql cluster localhost mix with remote address

I am trying to use mysql cluster installer ndb_setup.py to set up 2 nodes mysql cluster and getting following error 2018-12-13 00:25:50 [MgmtSrvr] WARNING -- at line 35: [DB] BackupMaxWriteSize ...
0
votes
1answer
41 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
1answer
2k 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
394 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
105 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
49 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
309 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 ...
0
votes
0answers
177 views

MySQL database uses too much CPU and run very slow, help configuration

I really need your help, for setting up the best configuration for my website. I have a MySQL database which is used, but it uses too much CPU. It starts out 30-40% and then goes up to 100% and then ...
1
vote
2answers
39 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
402 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
832 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
210 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
421 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 ...
2
votes
5answers
32k 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
107 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
597 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
4k 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
129 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
858 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 ...
1
vote
2answers
5k 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
0answers
139 views

Failure: Package DBMS_LOB does not exist on CentOS7 with Oracle 12c - safenet protactDB

I have issue about DBMS_LOB package on CentOS7 with Oracle 12c (I'm Oracle beginner). I try to install the SafeNet protactDB for Oracle but with no success. [xxx@xxx_poc safenet]$ ./install.sh ...
0
votes
1answer
164 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
1k 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
10k 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
259 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
3k 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
60 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 ...
0
votes
2answers
5k 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
431 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 ...