Trying psql was the first check I did when I saw the problem.
As you suggested, I tried with snoop, and verified that the 280 was actually connecting to the correct machine.
So, I looked into the postgres.log of the remote db machine...and found this.... :
LOG: incomplete startup packet
So I monitored the log during bacula Director startup: everything was ok.
Then I monitored during bconsole "list volumes", and the LOG came up....
....?!?!?!
Postgres is absolutely the same version. Solaris 10 is the same release.
The only difference is that the 280 is a SPARC processor, and the DB machine is an Intel one.
If I use "psql" from the 280 and connect to the DB on Intel, I can issue any "select" on the bacula db.
I even created the DB using the scripts on the 280, adding "-h intel-machine".
...pls...help....I am confused....
Da: MaxxAtWork <[EMAIL PROTECTED]>
A: Gabriele Bulfon <[EMAIL PROTECTED]> bacula-users@lists.sourceforge.net
Data: 11 settembre 2006 15.26.45 CEST
Oggetto: Re: [Bacula-users] Bacula-dir and remote Postgres
As you suggested, I tried with snoop, and verified that the 280 was actually connecting to the correct machine.
So, I looked into the postgres.log of the remote db machine...and found this.... :
LOG: incomplete startup packet
So I monitored the log during bacula Director startup: everything was ok.
Then I monitored during bconsole "list volumes", and the LOG came up....
....?!?!?!
Postgres is absolutely the same version. Solaris 10 is the same release.
The only difference is that the 280 is a SPARC processor, and the DB machine is an Intel one.
If I use "psql" from the 280 and connect to the DB on Intel, I can issue any "select" on the bacula db.
I even created the DB using the scripts on the 280, adding "-h intel-machine".
...pls...help....I am confused....
|
|
|
Gabriele Bulfon - Sonicle S.r.l. Tel +39 028246016 Int. 30 - Fax +39 028243880 Via Felice Cavallotti 16 - 20089, Rozzano - Milano - ITALY http://www.sonicle.com |
Da: MaxxAtWork <[EMAIL PROTECTED]>
A: Gabriele Bulfon <[EMAIL PROTECTED]> bacula-users@lists.sourceforge.net
Data: 11 settembre 2006 15.26.45 CEST
Oggetto: Re: [Bacula-users] Bacula-dir and remote Postgres
On 9/11/06, Gabriele Bulfon <[EMAIL PROTECTED]> wrote:Hi,The original setup was one Sun280R machine running all the daemons and postgres.
This machine is responsible for backups.
Because the DB is too slow, and slow down the overall backup performance (from 10K it slows down to 1K...), I wanted to move Postgres.
So now, all bacula daemons are still running on Sun280R, and here I'm also running bconsole.
I only changed the configuration to connect to the new DB on the other host.
And actually the Director is connecting correctly.
Probably, the scheduling will run.
But I need to add volumes and run a job by hand now, to check performance, and bconsole is giving problems.
When I run bconsole, it correctly connects to the Director, and its prompt is there ready to accept commands. But any command comes out with that error.
just a couple of ideas:
- did you try to use the postgres terminal (psql) from your 280R where you have the director? Just try to connect as bacula and perform some query, to check that password is ok, etc.
- use 'snoop' command on the Solaris, or even better ethereal/wireshark if you have it installed, in order to sniff the DB traffic between the two servers. That should help you to follow what happens when your director is trying to contact the database.
Regards
--
Maxx
------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
