Questions tagged [centos-7]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
1answer
166 views

Oracle Database Client Installation 12c minimal install - Centos / Red Hat 7

I'm looking at reducing the Linux package prerequisites when installing the Oracle Database Client 12c on the below headless application server / stack: Install file: V839967-01.zip Application ...
0
votes
0answers
20 views

AllowNoPassword

I installed phpmyAdmin on CentOS7 but I am not able to login. It I try to login without password, it gives following error. Login without a password is forbidden by configuration (see AllowNoPassword)...
2
votes
3answers
3k 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
435 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
56 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
54 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
114 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
371 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 ...
1
vote
1answer
255 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
52 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
501 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
11k 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
2k 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
223 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
82 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
893 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
63 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
591 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
305 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
467 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 ...
7
votes
5answers
63k 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
180 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
960 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 ...
2
votes
2answers
6k 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
268 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
2k 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
1k 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
3k 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
9k 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
249 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 ...
7
votes
3answers
13k 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
314 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 ...
1
vote
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
66 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
10k 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
705 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 ...