Hi Bin,
You should use a .pgpass file that pg_dump will use. You can find more
info at http://www.postgresql.org/docs/8.3/static/libpq-pgpass.html
This file should be stored in the home directory of the user that is
used to run the Sequoia controller.
Hope this helps,
Emmanuel
Thanks very much and you are right, there's something wrong with
access control.
The error message shows as:
2008-10-23 11:36:22,468 INFO backup.backupers.NativeCommandExec
Command "pg_dump -h 192.168.5.1 <http://192.168.5.1> -p 5432 -U
username -f /tmp/test.dump.sql jmango" logged 1 errors and terminated
with exitcode 1
2008-10-23 11:36:22,469 INFO
backup.backupers.AbstractPostgreSQLBackuper pg_dump: [archiver (db)]
connection to database "jmango" failed: fe_sendauth: no password supplied
But the Sequoia controller did ask for username and password, and I
entered the right password. I tried to change the access methods in
pg_hba.conf file to password and md5, but the error still poped up,
unitil I changed to trust, the error went away. But it is not
desirable, is there anyway I can use md5 encreption?
On Thu, Oct 23, 2008 at 2:05 AM, Emmanuel Cecchet
<[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>> wrote:
Hi,
You probably have a problem with your Postgres setup. You can set
the backuper logger to DEBUG in log4j.properties to see what
command is exactly executed:
log4j.logger.org.continuent.sequoia.controller.backup=DEBUG,
Console,Filetrace
This is usually a problem with the password or access control
policies that prevent pg_dump to backup the database.
Keep us posted with your findings,
Emmanuel
I am having problems to backup the database, and the error is
pg_dump execution did not complete successfully!
Detailed message from the log is as follows:
ERROR controller.RequestManager.test Backup command failed
org.continuent.sequoia.common.exceptions.BackupException:
pg_dump execution did not complete successfully!
at
org.continuent.sequoia.common.exceptions.SequoiaException.fillInStackTrace(SequoiaException.java:103)
at java.lang.Throwable.<init>(Throwable.java:196)
at java.lang.Exception.<init>(Exception.java:41)
at
org.continuent.sequoia.common.exceptions.SequoiaException.<init>(SequoiaException.java:57)
at
org.continuent.sequoia.common.exceptions.BackupException.<init>(BackupException.java:50)
at
org.continuent.sequoia.controller.backup.backupers.PostgreSQLPlainTextBackuper.backup(PostgreSQLPlainTextBackuper.java:164)
at
org.continuent.sequoia.controller.requestmanager.RequestManager.backupBackend(RequestManager.java:2955)
at
org.continuent.sequoia.controller.virtualdatabase.VirtualDatabase.backupBackend(VirtualDatabase.java:2391)
at
org.continuent.sequoia.controller.virtualdatabase.management.VirtualDatabase.backupBackend(VirtualDatabase.java:403)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at
com.sun.jmx.mbeanserver.StandardMBeanIntrospector.invokeM2(StandardMBeanIntrospector.java:93)
at
com.sun.jmx.mbeanserver.StandardMBeanIntrospector.invokeM2(StandardMBeanIntrospector.java:27)
at
com.sun.jmx.mbeanserver.MBeanIntrospector.invokeM(MBeanIntrospector.java:208)
at
com.sun.jmx.mbeanserver.PerInterface.invoke(PerInterface.java:120)
at
com.sun.jmx.mbeanserver.MBeanSupport.invoke(MBeanSupport.java:262)
at
javax.management.StandardMBean.invoke(StandardMBean.java:391)
at
com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanServerInterceptor.java:836)
at
com.sun.jmx.mbeanserver.JmxMBeanServer.invoke(JmxMBeanServer.java:761)
at
org.continuent.sequoia.controller.jmx.ChainedMBeanServer.invoke(ChainedMBeanServer.java:318)
at
org.continuent.sequoia.controller.jmx.AuthenticatingMBeanServer.invoke(AuthenticatingMBeanServer.java:127)
at
javax.management.remote.rmi.RMIConnectionImpl.doOperation(RMIConnectionImpl.java:1426)
at
javax.management.remote.rmi.RMIConnectionImpl.access$200(RMIConnectionImpl.java:72)
at
javax.management.remote.rmi.RMIConnectionImpl$PrivilegedOperation.run(RMIConnectionImpl.java:1264)
at
javax.management.remote.rmi.RMIConnectionImpl.doPrivilegedOperation(RMIConnectionImpl.java:1366)
at
javax.management.remote.rmi.RMIConnectionImpl.invoke(RMIConnectionImpl.java:788)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at
sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:305)
at sun.rmi.transport.Transport$1.run(Transport.java:159)
at sun.rmi.transport.Transport.serviceCall(Transport.java:155)
at
sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:535)
at
sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run0(TCPTransport.java:790)
at
sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:649)
at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:885)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907)
at java.lang.Thread.run(Thread.java:619)
and my configuration file is as follows:
<SEQUOIA>
<VirtualDatabase name="test">
<Distribution>
<MessageTimeouts/>
</Distribution>
<Backup>
<Backuper backuperName="postgres"
className="org.continuent.sequoia.controller.backup.backupers.PostgreSQLPlainTextBackuper"/>
</Backup>
<AuthenticationManager>
<Admin>
<User username="admin" password=""/>
</Admin>
<VirtualUsers>
<VirtualLogin vLogin="" vPassword=""/>
</VirtualUsers>
</AuthenticationManager>
<DatabaseBackend name="postgresql-prod0-test"
driver="org.postgresql.Driver"
url="jdbc:postgresql://192.168.5.1:5432/jmango
<http://192.168.5.1:5432/jmango>
<http://192.168.5.1:5432/jmango>"
connectionTestStatement="select now()">
<DatabaseSchema dynamicPrecision="table"/>
<ConnectionManager vLogin="sa" rLogin="" rPassword="">
<VariablePoolConnectionManager initPoolSize="20"
minPoolSize="5" maxPoolSize="0" idleTimeout="180"
waitTimeout="0"/>
</ConnectionManager>
</DatabaseBackend>
<RequestManager>
<RequestScheduler>
<RAIDb-1Scheduler level="passThrough"/>
</RequestScheduler>
<RequestCache>
<MetadataCache/>
<ParsingCache/>
<ResultCache granularity="table" />
</RequestCache>
<LoadBalancer>
<RAIDb-1>
<WaitForCompletion policy="first"/>
<RAIDb-1-LeastPendingRequestsFirst/>
</RAIDb-1>
</LoadBalancer>
<RecoveryLog driver="org.postgresql.Driver"
url="jdbc:postgresql://192.168.5.1:5432/recovery
<http://192.168.5.1:5432/recovery>
<http://192.168.5.1:5432/recovery>" login="" password="">
<RecoveryLogTable/>
<CheckpointTable/>
<BackendTable/>
<DumpTable/>
</RecoveryLog>
</RequestManager>
</VirtualDatabase>
</SEQUOIA>
Is there anything wrong with it? Any advise would be appreciated.
------------------------------------------------------------------------
--
Emmanuel Cecchet
FTO @ Frog Thinker
Open Source Development & Consulting
--
Web: http://www.frogthinker.org
email: [EMAIL PROTECTED]
Skype: emmanuel_cecchet
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
