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
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 ' 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 = " 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 = " > > 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