Displaying 20 results from an estimated 6000 matches similar to: "PostgreSQL/SELinux Error - relation "pg_catalog.pg_user" does not exist"
2006 Feb 16
3
Postgresql 8.1.x on CentOS 3.6
Hello everyone,
Does anyone know if there are any Postgresql 8.1.3 RPMs for CentOS 3.6?
I've looked at the Postgresql website but I couldn't find anything
under RHEL3/CentOS3. I've tried installing the RHEL4 RPMs which seem
to work. Unfortunately, I'm getting errors whenever I try to compile
PHP5 from source.
Thanks and Best Regards,
Matt
--
Stand before it and there is no
2005 Apr 28
1
relation "pg_user" does not exist error when running pg_dump
Hi,
I'm trying to move a postgres database to another server and I ran
into some weird problems. Pg_dump command was not giving any output
and the logs got filled with some SELinux errors. So I turned off
SELinux completely (and rebooted). Now I'm getting the following error
message:
# pg_dump -U postgres database > database.out
pg_dump: SQL command failed
pg_dump: Error message from
2005 May 24
2
PostgreSQL/SELinux Error - relation "pg_catalog.pg_u ser" does not exist
>
> The best thing to do is add this to /etc/selinux/config
>
> SELINUX=disabled
>
> And then get on with the real jobs....
>
Listening to all the pros and cons of SELinux.
I'd like to improve the security of our regional web server using SELinux.
We have a main regional web site and several virtual domains, kept up by
private users, all on the same server. Some of
2007 Oct 30
4
Postgresql and shell script
I have a shell script (sh) where I create a user and import data to a
postgres database
<snip>
su -c "createuser -A -D -P $PG_user" postgres
su -c "psql -d$PG_database -h localhost -U$PG_user -W -f postgresql.sql "
postgres
</snip>
when the script executes those command, it ask for a password, how could I
do this without have to enter the passwd, I would like that
2007 Mar 25
4
Cannot execute /usr/bin/fetchmail
Hello everyone,
I'm setting up a fetchmail command to run every five minutes so I can
get email from another POP3 account. The fetchmail package was
installed via yum.
I can execute the command manually on the command line. But I'm having
trouble when it's run from cron.
I have noticed that commands run via cron and execute via /bin/sh, so
I tried to run the fetchmail command
2008 Jun 27
6
African IP addresses list
Hi all,
I am trying to block all IP addresses from Africa due to a high rate
of fraudulent orders coming from them.
I have some found some websites that can generate a range of IP
addresses. However, you would have to enter the ranges by country. I
can use those perhaps but that would mean I would have to get the
ranges for each country one by one.
Has anyone here a list of addresses from
2009 Sep 24
3
Using yum with CentOS-2 mirrors
Hi all,
I was having yum errors while updating our CentOS-2 box. Further
reading lead me to a readme file on the mirrors
(http://mirror.centos.org/centos-2/readme.txt) and it gave me the new
URL to use for CentOS-2 mirrors. I have edited /etc/yum.conf with the
new URLs but I'm still having issues with yum giving me "ValueError:
unpack list of wrong size" errors.
Has anyone been
2010 Aug 06
3
yum-fastestmirror inconsistent exclude behavior
Hi guys,
I'm trying to figure out something wherein excluded repositories for
the yum-fastestmirror plugin are still being used by the system.
To illustrate:
[root at sales ~]# cat /etc/yum/pluginconf.d/fastestmirror.conf
[main]
enabled=1
verbose=0
socket_timeout=3
hostfilepath=/var/cache/yum/timedhosts.txt
maxhostfileage=10
maxthreads=15
#exclude=.gov, facebook
exclude=maulvi, .gov.ph, .vn
2007 Aug 24
3
"Site down for maintenance" - How is this accomplished?
Hello everyone,
Although we use CentOS primarily on our servers, this query is
actually more of a general networking question than something specific
to CentOS.
In the next week or so, we shall be migrating our in-house servers to
a data center. While we're doing that, we'd like to show a "Site down
for maintenance" message while the servers that hosts our websites (we
have
2007 Aug 27
2
Getting info on hardware RAID
Hello everyone,
I'm doing an audit of all our servers here (there aren't that many
maybe around 5-10) and one of the things I'm doing is taking note of
each server's hardware specs (processor, memory, etc).
I can't seem to figure out how to get the information for the hard
drives. The drives are in a hardware RAID5 array and are all SCSI
types. I would like to get each
2008 Mar 04
2
Overwrite target of ln
Hi all,
Sorry if this seems too basic.
But is there a way to overwrite the target of a symbolic link without
first deleting the symlink itself?
For example, if I have this:
public_html -> releases/b2b-20080228
... and there's a new update, I can then just do the following:
$ ln releases/site-latest public_html
I tried using the -f option but it doesn't seem to work as expected.
2008 Mar 28
2
Samba Administration Tool recommendations
Hi All,
I have a project which is to build a customized Linux distribution
with a focus on deploying a Samba as Primary Domain Controller. It's
pretty much like Trixbox but instead of Asterisk and VOIP, will be
focused on Samba.
Right now, I am looking for a solution for an administrator to easily
manage the service. Of particular importance would be to easily add
workstations and set up
2005 Apr 28
0
relation "pg_user" does not exist error when runningpg_dump
> -----Original Message-----
> From: centos-bounces at centos.org [mailto:centos-bounces at centos.org] On
> Behalf Of Andy Masiar
> Sent: Thursday, April 28, 2005 2:41 PM
> To: centos at centos.org
> Subject: [CentOS] relation "pg_user" does not exist error when
> runningpg_dump
>
> Hi,
>
> I'm trying to move a postgres database to another server
2007 Oct 24
1
TFTP server not working as expected when run from xinetd
Hi All,
I have a Trixbox server (CentOS derivative) from which our Cisco IP
phones get their config files via TFTP.
I have noticed that when I run the TFTP server via "service xinetd
start", I am not able to get files via TFTP. I have tested it by doing
a manual transfer via a TFTP client from another machine.
When I try to run the TFTP service manually by doing
2008 Aug 26
1
screen not sourcing .bashrc
Hi everyone,
I use the "screen" command from time to time and what i would still
have to figure out how to do is for it to be able to source .bashrc
and read my user-defined configuration (aliases for example).
I have already added the "source /root/.bashrc" line on
/root/.screenrc but it doesn't seem to be working.
Would anyone know how this should work?
Thanks,
Matt
2009 Aug 29
1
Run GNU screen as a normal user
Hi guys,
I am currently looking for a workaround with regards to running screen
as a normal user.
When I try to run it, I get the following:
[mbaluyos at mla torrents]$ screen
Cannot open your terminal '/dev/pts/0' - please check.
To get around this, I had to chmod 777 /dev/pts/0. It's an insecure
hack so I'm looking for the right way of doing it.
Would anyone be able to guide
2006 Apr 30
16
postgresql duplicate key violates unique constraint
I have a weird problem with creating a new record when using PostgreSQL.
From inside script/console ...
>> entity = Entity.new
>> entity.first_name = "Foo"
>> entity.last_name = "bar"
>> entity.save
Throws an exception due to the following SQL error: duplicate key
violates unique constraint.
The application was working fine before and suddenly
2007 May 11
1
postgres erros on RHEL 4
Hi All,
I set up posgresql on RedHat El4. Below are rpms I installed.
[root at LinuxBox etc]# rpm -qa |grep postgres
postgresql-libs-7.4.16-1.RHEL4.1
postgresql-devel-7.4.16-1.RHEL4.1
postgresql-7.4.16-1.RHEL4.1
postgresql-python-7.4.16-1.RHEL4.1
postgresql-server-7.4.16-1.RHEL4.1
Then, I did below commands to create a user and a database.
[root at box root]# su postgres
bash-3.1$ createuser
2008 May 05
2
RODBC and schemas
I have found that the "schema.table" syntax used in Postgresql (and
Oracle) does not work directly with RODBC.
This works
library(RODBC)
con<-odbcConnect("mydb")
d<-sqlQuery(con,"select * from meso.trees")
However this does not.
d<-sqlFetch(con,"meso.trees")
Error in odbcTableExists(channel, sqtable) :
?meso.trees?: table not found on channel
2007 Jan 22
1
Music on Hold on IP Phones with FreePBX 2.2.0
Hello everyone,
We just installed a new Trixbox 2.0 server and updated FreePBX to
2.2.0 from 2.2.0rc3.
We are having some problems with regards to Music on Hold on IP
phones. When we press the "Hold" button, the caller doesn't hear the
MOH sound. This functionality used to work with the older
Asterisk@Home installation on the same hardware and configuration.
However, we don't