Hi 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 -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]>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>" >> 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>" login="" >> password=""> >> <RecoveryLogTable/> >> <CheckpointTable/> >> <BackendTable/> >> <DumpTable/> >> </RecoveryLog> >> >> </RequestManager> >> >> </VirtualDatabase> >> >> </SEQUOIA> >> >> >> Is there anything wrong with it? Any advise would be appreciated. >> ------------------------------------------------------------------------ >> >> _______________________________________________ >> Sequoia mailing list >> [email protected] >> https://forge.continuent.org/mailman/listinfo/sequoia >> > > > -- > 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 > -- www.jmango.com.au Email [EMAIL PROTECTED] Office +61 3 9863 8144 Fax +61 3 9866 1330
_______________________________________________ Sequoia mailing list [email protected] https://forge.continuent.org/mailman/listinfo/sequoia
