Re: [Bacula-users] bscan and non-local database/port
Does anyone have an idea whether this should work or not? Am I typing the command incorrectly? Is there another way to re-introduce the catalog data from a tape to a remote database on a non-standard port? Thanks in advance! -JPH [EMAIL PROTECTED] wrote: Dan Langille wrote: [EMAIL PROTECTED] wrote: I am trying to use bscan to retrieve catalog information into my catalog. the catalog database is on another server, and on a non-standard port. I cannot figure out how to get it to talk to the remote database on the non-standard mysql port. Here is one of the commands I am trying. ../sbin/bscan -d 5 -h 10.1.2.5:3309 -u ** -P * -n bacula_brightserv -v -V VTAPE_brightserv_0009 /data/bacula_data/VTAPE/brightserv It always times out talking to the database: 13-Feb 20:33 bscan: ERROR TERMINATION at bscan.c:277 mysql.c:164 Unable to connect to MySQL server. Database=bacula_brightserv User=** It is probably not running or your password is incorrect. On the same machine, can you connect to the database using mysql and the same parameters you supplied above? From the same server as above, I can connect with the credentials: mysql -h 10.1.2.5 --port 3309 -u *** -p bacula_brightserv Enter password: Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 8237791 to server version: 5.0.18-standard-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql show databases; ++ | Database | ++ | information_schema | | bacula_brightserv | ++ 2 rows in set (0.00 sec) - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] bscan and non-local database/port
On Fri, Feb 15, 2008 at 8:18 AM, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Does anyone have an idea whether this should work or not? Am I typing the command incorrectly? Is there another way to re-introduce the catalog data from a tape to a remote database on a non-standard port? Yes. Well at least postgresql works remotely with bscan. I know that because my database is not on the same machine as my director and never has been... John - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] bscan and non-local database/port
John Drescher wrote: On Fri, Feb 15, 2008 at 8:18 AM, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Does anyone have an idea whether this should work or not? Am I typing the command incorrectly? Is there another way to re-introduce the catalog data from a tape to a remote database on a non-standard port? Yes. Well at least postgresql works remotely with bscan. I know that because my database is not on the same machine as my director and never has been... John - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users could you show me what command line you use to tell it to use another port? Thanks! -JPH - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] bscan and non-local database/port
John Drescher wrote: could you show me what command line you use to tell it to use another port? Thanks! Sorry. I do not use a nonstandard port. That is most likely the problem. My first stab at this is you could use an SSH tunnel to map the default port (for mysql) on the local machine to the nonstandard port on the remote. See TCP Port Forwarding in this link: http://suso.org/docs/shell/ssh.sdf John - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users That is a good idea, I will try that. Thanks for your help. -JPH - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] bscan and non-local database/port
could you show me what command line you use to tell it to use another port? Thanks! Sorry. I do not use a nonstandard port. That is most likely the problem. My first stab at this is you could use an SSH tunnel to map the default port (for mysql) on the local machine to the nonstandard port on the remote. See TCP Port Forwarding in this link: http://suso.org/docs/shell/ssh.sdf John - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] bscan and non-local database/port
[EMAIL PROTECTED] wrote: John Drescher wrote: could you show me what command line you use to tell it to use another port? Thanks! Sorry. I do not use a nonstandard port. That is most likely the problem. My first stab at this is you could use an SSH tunnel to map the default port (for mysql) on the local machine to the nonstandard port on the remote. See TCP Port Forwarding in this link: http://suso.org/docs/shell/ssh.sdf John - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users That is a good idea, I will try that. Thanks for your help. -JPH - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users I finally found the right combination of options to make this work on a remote machine and nonstandard port for mysql: Here are the settings and command I used, maybe of some use to someone else. apparently, mysql client automatically expects to use 3306 if remote host or a local file socket (/var/lib/mysql.sock or similar) to connect. since I cannot specify the port number to the bscan command, I told mysql to default to the port number and host by setting environment variables: export MYSQL_HOST=10.1.2.5 export MYSQL_TCP_PORT=3309 export MYSQL_UNIX_PORT=3309 Then you still have to tell bscan to use the remote host too: ../sbin/bscan -d 5 -h 10.1.2.5 -u ** -P ** -n bacula_brightserv -v -V VTAPE_brightserv_0009 /data/bacula_data/VTAPE/brightserv Thanks! -JPH - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] bscan and non-local database/port
I am trying to use bscan to retrieve catalog information into my catalog. the catalog database is on another server, and on a non-standard port. I cannot figure out how to get it to talk to the remote database on the non-standard mysql port. Here is one of the commands I am trying. ../sbin/bscan -d 5 -h 10.1.2.5:3309 -u ** -P * -n bacula_brightserv -v -V VTAPE_brightserv_0009 /data/bacula_data/VTAPE/brightserv It always times out talking to the database: 13-Feb 20:33 bscan: ERROR TERMINATION at bscan.c:277 mysql.c:164 Unable to connect to MySQL server. Database=bacula_brightserv User=** It is probably not running or your password is incorrect. I apologize if this is a FAQ question, but I could not find an answer anywhere. I am using: Version: 1.38.11 (28 June 2006) Any help is very appreciated! Thanks to the list! -JPH - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] bscan and non-local database/port
[EMAIL PROTECTED] wrote: I am trying to use bscan to retrieve catalog information into my catalog. the catalog database is on another server, and on a non-standard port. I cannot figure out how to get it to talk to the remote database on the non-standard mysql port. Here is one of the commands I am trying. ../sbin/bscan -d 5 -h 10.1.2.5:3309 -u ** -P * -n bacula_brightserv -v -V VTAPE_brightserv_0009 /data/bacula_data/VTAPE/brightserv It always times out talking to the database: 13-Feb 20:33 bscan: ERROR TERMINATION at bscan.c:277 mysql.c:164 Unable to connect to MySQL server. Database=bacula_brightserv User=** It is probably not running or your password is incorrect. On the same machine, can you connect to the database using mysql and the same parameters you supplied above? -- Dan Langille - http://www.langille.org/ BSDCan - The Technical BSD Conference: http://www.bsdcan.org/ PGCon - The PostgreSQL Conference:http://www.pgcon.org/ - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] bscan and non-local database/port
Dan Langille wrote: [EMAIL PROTECTED] wrote: I am trying to use bscan to retrieve catalog information into my catalog. the catalog database is on another server, and on a non-standard port. I cannot figure out how to get it to talk to the remote database on the non-standard mysql port. Here is one of the commands I am trying. ../sbin/bscan -d 5 -h 10.1.2.5:3309 -u ** -P * -n bacula_brightserv -v -V VTAPE_brightserv_0009 /data/bacula_data/VTAPE/brightserv It always times out talking to the database: 13-Feb 20:33 bscan: ERROR TERMINATION at bscan.c:277 mysql.c:164 Unable to connect to MySQL server. Database=bacula_brightserv User=** It is probably not running or your password is incorrect. On the same machine, can you connect to the database using mysql and the same parameters you supplied above? From the same server as above, I can connect with the credentials: mysql -h 10.1.2.5 --port 3309 -u *** -p bacula_brightserv Enter password: Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 8237791 to server version: 5.0.18-standard-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql show databases; ++ | Database | ++ | information_schema | | bacula_brightserv | ++ 2 rows in set (0.00 sec) - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users