Re: [Bacula-users] Install bacula using MySQL where MySQL isn't on same server
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 John Steel wrote: Is this possible? There is a dedicated MySQL server on the LAN which isn't the same as the one which will run bacula (with the tape in). I built and ran it fine on my home server and noticed it pulling in the MySQL headers etc, but that server hosted everything (RH6). It is certainly possible to have the MySQL base on a different server, check out the manual: http://www.bacula.org/rel-manual/FileSet_Resource.html#SECTION00159 You may also have to adapt the make_bacula_tables (and similar) scripts before running them. The fact that Bacula pulls in the MySQL headers when compiling is normal, without them, it wouldn't be able to 'speak MySQL'. Greetings, Michel -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.7 (MingW32) iD8DBQFGJiES2Vs+MkscAyURAgshAJ9KQkmd/kzKpNAzZ+hjeGsTLZoeaACeMzoc SfJtGL1HWj8lgDp7J3B+Blo= =oj5+ -END PGP SIGNATURE- - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Install bacula using MySQL where MySQL isn't on same server
Is this possible? There is a dedicated MySQL server on the LAN which isn't the same as the one which will run bacula (with the tape in). I built and ran it fine on my home server and noticed it pulling in the MySQL headers etc, but that server hosted everything (RH6). Now I'm getting familiar with bacula I want to do the same in the office, which has the setup I described. Thanks. -- -- http://www.phonewebcam.com [EMAIL PROTECTED] - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Install bacula using MySQL where MySQL isn't on same server
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 John Steel wrote: Is this possible? There is a dedicated MySQL server on the LAN which isn't the same as the one which will run bacula (with the tape in). I built and ran it fine on my home server and noticed it pulling in the MySQL headers etc, but that server hosted everything (RH6). Now I'm getting familiar with bacula I want to do the same in the office, which has the setup I described. Thanks. It is possible, just a bit more difficult. I haven't done it personally. There may be information in the manual, but I'm not sure. - -- _ _ _ _ ___ _ _ _ |Y#| | | |\/| | \ |\ | | |Ryan Novosielski - Systems Programmer III |$| |__| | | |__/ | \| _| |[EMAIL PROTECTED] - 973/972.0922 (2-0922) \__/ Univ. of Med. and Dent.|IST/AST - NJMS Medical Science Bldg - C630 -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.5 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFGJip8mb+gadEcsb4RAtBqAKCn3Hl1dD4x5pvLycigWshjmSMbsgCgvm/L pkHEQqS31unagrC6oYdeMEk= =TX46 -END PGP SIGNATURE- - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Install bacula using MySQL where MySQL isn't on same server
John Is this possible?
Yup, it's possible. I have it setup just this way on my home
network. Unfortunately, it's not supported right out of the box.
John There is a dedicated MySQL server on the LAN which isn't the
John same as the one which will run bacula (with the tape in). I
John built and ran it fine on my home server and noticed it pulling
John in the MySQL headers etc, but that server hosted everything
John (RH6). Now I'm getting familiar with bacula I want to do the
John same in the office, which has the setup I described. Thanks.
You need to make some tweaks to a couple of scripts and configuration
settings, so that you use the mysql '-h hostname' option.
Let's see, I hacked the /etc/bacula/scripts/make_catalog_backup to
take a fourth parameter, which is the hostname of the system to
contact for mysql backups.
In the Catalog { ... } definition in the bacula-dir.conf I had to add
the line DB Address = hostname
I think that was it really.
John
-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Install bacula using MySQL where MySQL isn't on same server
John Stoffel wrote:
In the Catalog { ... } definition in the bacula-dir.conf I had to add
the line DB Address = hostname
I think that was it really.
John
Thanks, and that will be great for running it. But I'm more concerned
about the build. will ./configure --with-mysql work with no mysql-devel
etc on the machine?
Do you have to temporarily do a full install of MySQL ( devel) ?
--
--
http://www.phonewebcam.com
[EMAIL PROTECTED]
-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Install bacula using MySQL where MySQL isn't on same server
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 John Steel wrote: Thanks, and that will be great for running it. But I'm more concerned about the build. will ./configure --with-mysql work with no mysql-devel etc on the machine? No, you will need mysql-devel to compile in MySQL support. Do you have to temporarily do a full install of MySQL ( devel) ? You normally don't need MySQL to install the -dev packages (at least that's not the case on my distro). Greetings, Michel -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.7 (MingW32) iD8DBQFGJmua2Vs+MkscAyURAhIxAKC73iKjbJ9wx9tbpOiWannkWHMyewCgrwzP wZQFWWS4lOHNT+Fvia5G8JI= =OKp1 -END PGP SIGNATURE- - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Install bacula using MySQL where MySQL isn't on same server
John Thanks, and that will be great for running it. But I'm more John concerned about the build. will ./configure --with-mysql work John with no mysql-devel etc on the machine? Do you have to John temporarily do a full install of MySQL ( devel) ? I doubt it will work, since you need the mysqllibs (at least) so that you can connect to the remote DB. But I'm honestly not sure, I just installed mysql on my main machine but don't have it configured to start or anything. Hmm... looking at my system more closely, I'm using Debian, with the provided bacula packages, I think if you just have the mysql-client stuff installed, you should be all set. And/or the libmysqlclient15dev packages. Good luck! John - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Install bacula using MySQL where MySQL isn't on same server
On 18 Apr 2007 at 16:59, John Stoffel wrote: John Thanks, and that will be great for running it. But I'm more John concerned about the build. will ./configure --with-mysql work John with no mysql-devel etc on the machine? Do you have to John temporarily do a full install of MySQL ( devel) ? I doubt it will work, since you need the mysqllibs (at least) so that you can connect to the remote DB. But I'm honestly not sure, I just installed mysql on my main machine but don't have it configured to start or anything. Hmm... looking at my system more closely, I'm using Debian, with the provided bacula packages, I think if you just have the mysql-client stuff installed, you should be all set. And/or the libmysqlclient15dev packages. FWIW, on FreeBSD, the port will install the MySQL client on that box. Not the MySQL Server. HTH. -- Dan Langille : Software Developer looking for work my resume: http://www.freebsddiary.org/dan_langille.php PGCon - The PostgreSQL Conference - http://www.pgcon.org/ - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Install bacula using MySQL where MySQL isn't on same server
Dan == Dan Langille [EMAIL PROTECTED] writes: Dan FWIW, on FreeBSD, the port will install the MySQL client on that Dan box. Not the MySQL Server. Hey, whaddaya know, on Debian Unstable (etch maybe? Gotta check my sources some day...) bacula depends on mysqlclient12, which depends on mysql-common, which is version 4.0.24 of mysql. Neat! Thanks for making to bother to look Dan. John - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
