Re: [Bacula-users] Ubuntu Lucid, Migration from SQLite --> MySQL | MySQL already has 1 DB running.
On 1/27/2011 12:57 AM, J. Echter wrote: > Am 27.01.2011 08:53, schrieb Randy Katz: >> On 1/26/2011 11:37 PM, J. Echter wrote: >>> Am 26.01.2011 17:04, schrieb J. Echter: Hi, im running Ubuntu Lucid Server x64. I'd like to migrate from bacula-sqlite to bacula-mysql, but i have one problem. Im not a MySQL expert and i already have one Database running with MySQL. Can someone advice how to handle my situation without damaging anything? :) I would do the following: 1. dump sqlite db 2. remove sqlite parts of bacula 3. install mysql parts of bacula 4. creating db (there im not sure if can break something if i just use the script from bacula) 5. loading previously dumped tables back to mysql (i dont know how yet) or would postgresql the better choice? cheers juergen -- Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)! Finally, a world-class log management solution at an even better price-free! Download using promo code Free_Logger_4_Dev2Dev. Offer expires February 28th, so secure your free ArcSight Logger TODAY! http://p.sf.net/sfu/arcsight-sfd2d ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users >>> Hi, >>> >>> im currently trying to feed my sqlite dump back into mysql db... Error i >>> get is: >>> >>> mysql -u root -p< bacula.sql >>> Enter password: >>> ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; >>> check the manual that corresponds to your MySQL server version for the >>> right syntax to use near 'PRAGMA foreign_keys=OFF' at line 1 >>> >>> as i said im not so good in this sql stuff :) could anyone point me into >>> the right direction? >>> >>> cheers. >>> >>> juergen. >>> >> hi, you don't need that line, comment out with a # at the beginning, >> please if you have more problems feed the next lines before the >> database/table >> create statements here and I will look them up. Here are some notes on >> converting a google search brings more: >> >> http://stackoverflow.com/questions/18671/quick-easy-way-to-migrate-sqlite3-to-mysql >> >> http://www.google.com/search?q=convert+sqlite+to+mysql&ie=utf-8&oe=utf-8&aq=t&client=firefox-a&rlz=1R1GGLL_en___US399 >> >> >> I hope that helps, take care >> Randy > Hi, > > im stuck on starting bacula-director again. There's no error message but > bconsle cant connect and netstat -tulpen show no listening director on > port 9101. > > any hints how to solve this? > check what is it /var/bacula/working/log and act accordingly. -- Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)! Finally, a world-class log management solution at an even better price-free! Download using promo code Free_Logger_4_Dev2Dev. Offer expires February 28th, so secure your free ArcSight Logger TODAY! http://p.sf.net/sfu/arcsight-sfd2d ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Ubuntu Lucid, Migration from SQLite --> MySQL | MySQL already has 1 DB running.
Am 27.01.2011 09:57, schrieb J. Echter: > Am 27.01.2011 08:53, schrieb Randy Katz: >> On 1/26/2011 11:37 PM, J. Echter wrote: >>> Am 26.01.2011 17:04, schrieb J. Echter: Hi, im running Ubuntu Lucid Server x64. I'd like to migrate from bacula-sqlite to bacula-mysql, but i have one problem. Im not a MySQL expert and i already have one Database running with MySQL. Can someone advice how to handle my situation without damaging anything? :) I would do the following: 1. dump sqlite db 2. remove sqlite parts of bacula 3. install mysql parts of bacula 4. creating db (there im not sure if can break something if i just use the script from bacula) 5. loading previously dumped tables back to mysql (i dont know how yet) or would postgresql the better choice? cheers juergen -- Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)! Finally, a world-class log management solution at an even better price-free! Download using promo code Free_Logger_4_Dev2Dev. Offer expires February 28th, so secure your free ArcSight Logger TODAY! http://p.sf.net/sfu/arcsight-sfd2d ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users >>> Hi, >>> >>> im currently trying to feed my sqlite dump back into mysql db... Error i >>> get is: >>> >>> mysql -u root -p< bacula.sql >>> Enter password: >>> ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; >>> check the manual that corresponds to your MySQL server version for the >>> right syntax to use near 'PRAGMA foreign_keys=OFF' at line 1 >>> >>> as i said im not so good in this sql stuff :) could anyone point me into >>> the right direction? >>> >>> cheers. >>> >>> juergen. >>> >> hi, you don't need that line, comment out with a # at the beginning, >> please if you have more problems feed the next lines before the >> database/table >> create statements here and I will look them up. Here are some notes on >> converting a google search brings more: >> >> http://stackoverflow.com/questions/18671/quick-easy-way-to-migrate-sqlite3-to-mysql >> >> http://www.google.com/search?q=convert+sqlite+to+mysql&ie=utf-8&oe=utf-8&aq=t&client=firefox-a&rlz=1R1GGLL_en___US399 >> >> >> I hope that helps, take care >> Randy > Hi, > > im stuck on starting bacula-director again. There's no error message but > bconsle cant connect and netstat -tulpen show no listening director on > port 9101. > > any hints how to solve this? > > greets > > juergen > > -- > Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)! > Finally, a world-class log management solution at an even better price-free! > Download using promo code Free_Logger_4_Dev2Dev. Offer expires > February 28th, so secure your free ArcSight Logger TODAY! > http://p.sf.net/sfu/arcsight-sfd2d > ___ > Bacula-users mailing list > Bacula-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/bacula-users ok, my bad... i forgot to add new db password in catalog config section. back(ing) up again :) thanks and have a nice day!! juergen -- Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)! Finally, a world-class log management solution at an even better price-free! Download using promo code Free_Logger_4_Dev2Dev. Offer expires February 28th, so secure your free ArcSight Logger TODAY! http://p.sf.net/sfu/arcsight-sfd2d ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Ubuntu Lucid, Migration from SQLite --> MySQL | MySQL already has 1 DB running.
Am 27.01.2011 08:53, schrieb Randy Katz: > On 1/26/2011 11:37 PM, J. Echter wrote: >> Am 26.01.2011 17:04, schrieb J. Echter: >>> Hi, >>> >>> im running Ubuntu Lucid Server x64. >>> >>> I'd like to migrate from bacula-sqlite to bacula-mysql, but i have one >>> problem. Im not a MySQL expert and i already have one Database running >>> with MySQL. >>> >>> Can someone advice how to handle my situation without damaging >>> anything? :) >>> >>> I would do the following: >>> >>> 1. dump sqlite db >>> 2. remove sqlite parts of bacula >>> 3. install mysql parts of bacula >>> 4. creating db (there im not sure if can break something if i just use >>> the script from bacula) >>> 5. loading previously dumped tables back to mysql (i dont know how yet) >>> >>> or would postgresql the better choice? >>> >>> cheers >>> >>> juergen >>> >>> -- >>> >>> Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)! >>> Finally, a world-class log management solution at an even better >>> price-free! >>> Download using promo code Free_Logger_4_Dev2Dev. Offer expires >>> February 28th, so secure your free ArcSight Logger TODAY! >>> http://p.sf.net/sfu/arcsight-sfd2d >>> ___ >>> Bacula-users mailing list >>> Bacula-users@lists.sourceforge.net >>> https://lists.sourceforge.net/lists/listinfo/bacula-users >> Hi, >> >> im currently trying to feed my sqlite dump back into mysql db... Error i >> get is: >> >> mysql -u root -p< bacula.sql >> Enter password: >> ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; >> check the manual that corresponds to your MySQL server version for the >> right syntax to use near 'PRAGMA foreign_keys=OFF' at line 1 >> >> as i said im not so good in this sql stuff :) could anyone point me into >> the right direction? >> >> cheers. >> >> juergen. >> > hi, you don't need that line, comment out with a # at the beginning, > please if you have more problems feed the next lines before the > database/table > create statements here and I will look them up. Here are some notes on > converting a google search brings more: > > http://stackoverflow.com/questions/18671/quick-easy-way-to-migrate-sqlite3-to-mysql > > http://www.google.com/search?q=convert+sqlite+to+mysql&ie=utf-8&oe=utf-8&aq=t&client=firefox-a&rlz=1R1GGLL_en___US399 > > > I hope that helps, take care > Randy Hi, im stuck on starting bacula-director again. There's no error message but bconsle cant connect and netstat -tulpen show no listening director on port 9101. any hints how to solve this? greets juergen -- Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)! Finally, a world-class log management solution at an even better price-free! Download using promo code Free_Logger_4_Dev2Dev. Offer expires February 28th, so secure your free ArcSight Logger TODAY! http://p.sf.net/sfu/arcsight-sfd2d ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Ubuntu Lucid, Migration from SQLite --> MySQL | MySQL already has 1 DB running.
On 1/26/2011 11:37 PM, J. Echter wrote: > Am 26.01.2011 17:04, schrieb J. Echter: >> Hi, >> >> im running Ubuntu Lucid Server x64. >> >> I'd like to migrate from bacula-sqlite to bacula-mysql, but i have one >> problem. Im not a MySQL expert and i already have one Database running >> with MySQL. >> >> Can someone advice how to handle my situation without damaging anything? :) >> >> I would do the following: >> >> 1. dump sqlite db >> 2. remove sqlite parts of bacula >> 3. install mysql parts of bacula >> 4. creating db (there im not sure if can break something if i just use >> the script from bacula) >> 5. loading previously dumped tables back to mysql (i dont know how yet) >> >> or would postgresql the better choice? >> >> cheers >> >> juergen >> >> -- >> Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)! >> Finally, a world-class log management solution at an even better price-free! >> Download using promo code Free_Logger_4_Dev2Dev. Offer expires >> February 28th, so secure your free ArcSight Logger TODAY! >> http://p.sf.net/sfu/arcsight-sfd2d >> ___ >> Bacula-users mailing list >> Bacula-users@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/bacula-users > Hi, > > im currently trying to feed my sqlite dump back into mysql db... Error i > get is: > > mysql -u root -p< bacula.sql > Enter password: > ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; > check the manual that corresponds to your MySQL server version for the > right syntax to use near 'PRAGMA foreign_keys=OFF' at line 1 > > as i said im not so good in this sql stuff :) could anyone point me into > the right direction? > > cheers. > > juergen. > hi, you don't need that line, comment out with a # at the beginning, please if you have more problems feed the next lines before the database/table create statements here and I will look them up. Here are some notes on converting a google search brings more: http://stackoverflow.com/questions/18671/quick-easy-way-to-migrate-sqlite3-to-mysql http://www.google.com/search?q=convert+sqlite+to+mysql&ie=utf-8&oe=utf-8&aq=t&client=firefox-a&rlz=1R1GGLL_en___US399 I hope that helps, take care Randy -- Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)! Finally, a world-class log management solution at an even better price-free! Download using promo code Free_Logger_4_Dev2Dev. Offer expires February 28th, so secure your free ArcSight Logger TODAY! http://p.sf.net/sfu/arcsight-sfd2d ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Ubuntu Lucid, Migration from SQLite --> MySQL | MySQL already has 1 DB running.
Am 26.01.2011 17:04, schrieb J. Echter: > Hi, > > im running Ubuntu Lucid Server x64. > > I'd like to migrate from bacula-sqlite to bacula-mysql, but i have one > problem. Im not a MySQL expert and i already have one Database running > with MySQL. > > Can someone advice how to handle my situation without damaging anything? :) > > I would do the following: > > 1. dump sqlite db > 2. remove sqlite parts of bacula > 3. install mysql parts of bacula > 4. creating db (there im not sure if can break something if i just use > the script from bacula) > 5. loading previously dumped tables back to mysql (i dont know how yet) > > or would postgresql the better choice? > > cheers > > juergen > > -- > Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)! > Finally, a world-class log management solution at an even better price-free! > Download using promo code Free_Logger_4_Dev2Dev. Offer expires > February 28th, so secure your free ArcSight Logger TODAY! > http://p.sf.net/sfu/arcsight-sfd2d > ___ > Bacula-users mailing list > Bacula-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/bacula-users Hi, im currently trying to feed my sqlite dump back into mysql db... Error i get is: mysql -u root -p < bacula.sql Enter password: ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'PRAGMA foreign_keys=OFF' at line 1 as i said im not so good in this sql stuff :) could anyone point me into the right direction? cheers. juergen. -- Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)! Finally, a world-class log management solution at an even better price-free! Download using promo code Free_Logger_4_Dev2Dev. Offer expires February 28th, so secure your free ArcSight Logger TODAY! http://p.sf.net/sfu/arcsight-sfd2d ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Ubuntu Lucid, Migration from SQLite --> MySQL | MySQL already has 1 DB running.
On 01/26/11 11:04, J. Echter wrote: > Hi, > > im running Ubuntu Lucid Server x64. > > I'd like to migrate from bacula-sqlite to bacula-mysql, but i have one > problem. Im not a MySQL expert and i already have one Database running > with MySQL. That's not a problem. The number of DBs you can run on a single MySQL instance is in practical terms limited only by how much hardware you have under it. I support customers every day who have hundreds of DBs (and sometimes, DBs with thousands of tables) on a single MySQL instance. -- Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355 ala...@caerllewys.net ala...@metrocast.net p...@co.ordinate.org Renaissance Man, Unix ronin, Perl hacker, Free Stater It's not the years, it's the mileage. -- Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)! Finally, a world-class log management solution at an even better price-free! Download using promo code Free_Logger_4_Dev2Dev. Offer expires February 28th, so secure your free ArcSight Logger TODAY! http://p.sf.net/sfu/arcsight-sfd2d ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Ubuntu Lucid, Migration from SQLite --> MySQL | MySQL already has 1 DB running.
Hi, im running Ubuntu Lucid Server x64. I'd like to migrate from bacula-sqlite to bacula-mysql, but i have one problem. Im not a MySQL expert and i already have one Database running with MySQL. Can someone advice how to handle my situation without damaging anything? :) I would do the following: 1. dump sqlite db 2. remove sqlite parts of bacula 3. install mysql parts of bacula 4. creating db (there im not sure if can break something if i just use the script from bacula) 5. loading previously dumped tables back to mysql (i dont know how yet) or would postgresql the better choice? cheers juergen -- Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)! Finally, a world-class log management solution at an even better price-free! Download using promo code Free_Logger_4_Dev2Dev. Offer expires February 28th, so secure your free ArcSight Logger TODAY! http://p.sf.net/sfu/arcsight-sfd2d ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Ubuntu Lucid
On Tue, Apr 27, 2010 at 04:08:21PM +0200, Daniel Kamm wrote: > Am 4/27/10 12:50 PM, schrieb Matija Nalis: > > So your options are either to downgrade the client on Lucid (maybe > > there can be found a package for 2.4.x version ? > > You may try to install the Ubuntu package for Karmic Koala or Hardy > Heron, which both are 2.4.4. > > Cheerz, > - Dan > Thanks Dan, that did the trick. I installed the following deb's: bacula-common_2.4.4-1ubuntu5_i386.deb bacula-fd_2.4.4-1ubuntu5_i386.deb downloaded from here: https://launchpad.net/ubuntu/jaunty/i386/bacula-common/2.4.4-1ubuntu5 https://launchpad.net/ubuntu/karmic/i386/bacula-fd/2.4.4-1ubuntu5 Just in case someone searches the archives for a similar problem. All the best, Uwe -- uwe.schuerk...@nionex.net fon: [+49] 5242.91 - 4740, fax:-69 72 Hauptsitz: Avenwedder Str. 55, D-33311 Gütersloh, Germany Registergericht Gütersloh HRB 4196, Geschäftsführer: H. Gosewehr, D. Suda NIONEX ist ein Unternehmen der DirectGroup Germany www.directgroupgermany.de -- ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Ubuntu Lucid
Am 4/27/10 12:50 PM, schrieb Matija Nalis: > So your options are either to downgrade the client on Lucid (maybe > there can be found a package for 2.4.x version ? You may try to install the Ubuntu package for Karmic Koala or Hardy Heron, which both are 2.4.4. Cheerz, - Dan -- ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Ubuntu Lucid
Uwe Schuerkamp schrieb: > Hi folks, > > looks like lucid comes with bacula v5 which seemingly is unable to > talk to our server running bacula 2.4.x: > > bacula-fd -c /etc/bacula/bacula-fd.conf -d 99 -f > bacula-fd: filed_conf.c:452-0 Inserting director res: lotus-mon > lotus-fd: filed.c:275-0 filed: listening on port 9102 > lotus-fd: cram-md5.c:73-0 send: auth cram-md5 > <1993776720.1272363...@lotus-fd> ssl=0 > lotus-fd: cram-md5.c:152-0 sending resp to challenge: > XXX > > > following that, there's a "client rejected hello command" message on > the server. > > Is there any way to turn on 2.x "client compatibility" in a 5.0.1 > client? nope client version must be <= server version Ralf -- ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Ubuntu Lucid
On Tue, Apr 27, 2010 at 12:50:08PM +0200, Matija Nalis wrote: > On Tue, Apr 27, 2010 at 12:27:11PM +0200, Uwe Schuerkamp wrote: > > Hi folks, > > > > looks like lucid comes with bacula v5 which seemingly is unable to > > talk to our server running bacula 2.4.x: > > Your other clients are all 2.4.x I guess. > > > following that, there's a "client rejected hello command" message on > > the server. > > > > Is there any way to turn on 2.x "client compatibility" in a 5.0.1 > > client? > > No. > > So your options are either to downgrade the client on Lucid (maybe > there can be found a package for 2.4.x version ? If not, you may need > to build it yourself) > > Or you can upgrade your director and SDs (it is usually possible to > have a newer directory/SD talk to older FD client; but not the other > way around. However 5.0 to 2.4 might be quite a stretch). Thanks for the info, Matija. I'll do a client-only compile from source using version 2.4.x then. All the best, Uwe -- NIONEX ist ein Unternehmen der DirectGroup Germany www.directgroupgermany.de -- ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Ubuntu Lucid
On Tue, Apr 27, 2010 at 12:27:11PM +0200, Uwe Schuerkamp wrote: > Hi folks, > > looks like lucid comes with bacula v5 which seemingly is unable to > talk to our server running bacula 2.4.x: Your other clients are all 2.4.x I guess. > following that, there's a "client rejected hello command" message on > the server. > > Is there any way to turn on 2.x "client compatibility" in a 5.0.1 > client? No. So your options are either to downgrade the client on Lucid (maybe there can be found a package for 2.4.x version ? If not, you may need to build it yourself) Or you can upgrade your director and SDs (it is usually possible to have a newer directory/SD talk to older FD client; but not the other way around. However 5.0 to 2.4 might be quite a stretch). -- ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Ubuntu Lucid
Hi folks, looks like lucid comes with bacula v5 which seemingly is unable to talk to our server running bacula 2.4.x: bacula-fd -c /etc/bacula/bacula-fd.conf -d 99 -f bacula-fd: filed_conf.c:452-0 Inserting director res: lotus-mon lotus-fd: filed.c:275-0 filed: listening on port 9102 lotus-fd: cram-md5.c:73-0 send: auth cram-md5 <1993776720.1272363...@lotus-fd> ssl=0 lotus-fd: cram-md5.c:152-0 sending resp to challenge: XXX following that, there's a "client rejected hello command" message on the server. Is there any way to turn on 2.x "client compatibility" in a 5.0.1 client? Thanks much in advance, Uwe -- NIONEX ist ein Unternehmen der DirectGroup Germany www.directgroupgermany.de -- ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users