Questions tagged [centos-7]
The centos-7 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 ...
