Home / user-219540

hdr's questions

Martin Hope
hdr
Asked: 2014-12-12 20:00:07 +0800 CST
  • 1

When I was trying to perform replication from Master to Server, the replication was able to run on the Master server, but the table in the slave database did not receive and apply the changes.

According to the Bucardo mailing list, to see the schema needed to perform the sync, type the /dn command to show it.

On Master side, the command reveals this:

 postgres=#\dn
 List of schemas
 Name       |   Owner
 bucardo    |   bucardo
 public     |   postgres
 test       |   postgres
 testschema |   postgres

On the Slave side, however:

 postgres=#\dn
 List of schemas
 Name       |   Owner
 public     |   postgres

Another suggestion is to insert data into the table at the master side, and see if there are changes made on the slave side but there is no change. And when running bucardo status on the master server, it shows this:

 PID of Bucardo MCP: 1852
 Name       State       Last Good   Time        Last I/D        Last Bad
 =========================================================================
 Example    Good        Dec 10, 2014    18h 37m 55s 0/0     none 
                           16:10:19

But on the slave server the result is:

 DBI connect (‘dbname=bucardo’, ‘bucardo’,…) failed: fe_sendauth: no password supplied at /usr/local/bin/bucardo line 296

I’ve tried removing the recovery.conf file in the slave server so that I can install Bucardo and add the user Bucardo to the database but it failed to do so.

postgresql
Martin Hope
hdr
Asked: 2014-09-30 00:16:24 +0800 CST
  • 0

I'm trying to install some software in my Ubuntu Server 12.04 installation, but whenever I try to install it using apt-get or aptitude, I would usually get an error message like this:

E: unable to locate package postgresql-plperl-9.0
E: couldn't find any package by regex 'postgresql-plperl-9.0'

The contents of my /etc/apt/sources.list file is (all of it are uncommented):

deb http://archive.ubuntu.com/ubuntu precise universe multiverse
deb-src http://archive.ubuntu.com/ubuntu precise universe multiverse

deb http://us.archive.ubuntu.com/ubuntu/ precise universe
deb-src http://us.archive.ubuntu.com/ubuntu/ precise universe
deb http://us.archive.ubuntu.com/ubuntu/ precise-updates universe
deb-src http://us.archive.ubuntu.com/ubuntu/ precise-updates universe

deb http://us.archive.ubuntu.com/ubuntu/ precise multiverse
deb-src http://us.archive.ubuntu.com/ubuntu/ precise multiverse
deb http://us.archive.ubuntu.com/ubuntu/ precise-updates multiverse
deb-src http://us.archive.ubuntu.com/ubuntu/ precise-updates multiverse

deb http://security.ubuntu.com/ubuntu precise-security universe
deb-src http://security.ubuntu.com/ubuntu precise-security universe
deb http://security.ubuntu.com/ubuntu precise-security multiverse
deb-src http://security.ubuntu.com/ubuntu precise-security multiverse

Any help on why I am encountering this issue is greatly appreciated.

ubuntu
Martin Hope
hdr
Asked: 2014-09-24 17:34:19 +0800 CST
  • 10

I'm new to managing servers, especially postgresql on Ubuntu Server, so bear with me.

I'm trying to synchronize between two databases on two different computers, but I'm not sure what I did wrong, since whatever I tried to do, it seems to have configured the servers into read-only mode.

For example, if I wanted to create a role, I would get:

ERROR: cannot execute CREATE ROLE in a read-only transaction

Or if I want to create a table, I would get an error message:

ERROR: cannot execute CREATE TABLE in a read-only transaction.

I have no idea what to do here, so advice on how to resolve this issue is greatly appreciated.

I'm running PostgreSQL version 9.1 on Ubuntu Server 12.04 for by the way.

ubuntu
Martin Hope
hdr
Asked: 2014-05-14 04:29:34 +0800 CST
  • 5

So I was following this guide on how to install Snort, Barnyard 2 and the like.

I've set up Snort so it would run automatically, by editing the rc.local file:

ifconfig eth1 up

/usr/local/snort/bin/snort -D -u snort -g snort \
-c /usr/local/snort/etc/snort.conf -i eth1
/usr/local/bin/barnyard2 -c /usr/local/snort/etc/barnyard2.conf \
-d /var/log/snort \
-f snort.u2 \
-w /var/log/snort/barnyard2.waldo \
-D

And I then restarted the computer. Snort was able to run and detect the attack, but the log files (including barnyard2.waldo) remained blank, even if a new log entry was created for each attack.

I'm not sure what went wrong here, since it's supposed to log any attacks and store it in the log directory, right?

Then, I tried changing the parameter to:

    /usr/local/snort/bin/snort -D -b -u snort -g snort \
-c /usr/local/snort/etc/snort.conf -i eth1

And when I checked the log file, there are two log files, one in u2 and another in tcpdump format, but they're both blank and is approximately 0 bytes.

So I thought I'd run it from the console to see if it would work from there, using this command:

/usr/local/snort/bin/snort -A full -u snort -g snort \

-c /usr/local/snort/etc/snort.conf -i eth1

and I then checked the log file to see if it would log the attack, and it still doesn't.

snort