Re: [Firebird-devel] Firebird SQL's backup/restore uses magic words for stdin and stdout
Here is an example how to make backup over web: #!/bin/bash shortname=database_backup`date +'_%d%m%Y_%R'`.gbk.zip echo "Content-Type:application/x-download" echo "Content-Disposition:attachment;filename=$shortname" echo /opt/firebird/bin/gbak -B stdout | zip -q -D -- Doychin Bondzhev dSoft-Bulgaria Ltd. PowerPro - billing & provisioning solution for Service providers PowerStor - Warehouse & POS http://www.dsoft-bg.com/ Mobile: +359888243116 <>-- Master HTML5, CSS3, ASP.NET, MVC, AJAX, Knockout.js, Web API and much more. Get web development skills now with LearnDevNow - 350+ hours of step-by-step video tutorials by Microsoft MVPs and experts. SALE $99.99 this month only -- learn more at: http://p.sf.net/sfu/learnmore_122812Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Firebird SQL's backup/restore uses magic words for stdin and stdout
Hi Steve, On 11/01/13 15:56, Steve Friedl wrote: > Hi folks, > > I'm the writer of the blog post that raised this issue, I had already posted > an issue for the tracker before I blogged about it for Google. > > I believe that it's *only* a documentation issue, because even though the > behavior is somewhat unconventional for a UNIX/Linux system, it works now on > all the systems you support, and that means it's probably too painful (and > unnecessary) to change. > > It does occur to me that the code could be changed a bit so that if gbak > gets the EPIPE error, the failure message could somehow mention that, as it > would probably give a better searchable error, but mucking with the code is > a lot more work (and risk) than just enhancing the docs. > > I appreciate the consideration you folks have given to this issue. > > Steve This has been fixed and the latest docs are online for your delectation here (HTML) http://www.firebirdsql.org/file/documentation/reference_manuals/user_manuals/html/gbak.html and here (PDF) http://www.firebirdsql.org/file/documentation/reference_manuals/user_manuals/Firebird-gbak.pdf Enjoy and thanks for bringing it to my attention. Cheers, Norm. -- Norman Dunbar Dunbar IT Consultants Ltd Registered address: Thorpe House 61 Richardshaw Lane Pudsey West Yorkshire United Kingdom LS28 7EL Company Number: 05132767 -- Master HTML5, CSS3, ASP.NET, MVC, AJAX, Knockout.js, Web API and much more. Get web development skills now with LearnDevNow - 350+ hours of step-by-step video tutorials by Microsoft MVPs and experts. SALE $99.99 this month only -- learn more at: http://p.sf.net/sfu/learnmore_122812 Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Firebird SQL's backup/restore uses magic words for stdin and stdout
Afternoon all, I can confirm that the online docs at http://www.firebirdsql.org/file/documentation/reference_manuals/user_manuals/Firebird-gbak.pdf and http://www.firebirdsql.org/file/documentation/reference_manuals/user_manuals/html/gbak.html have been updated at 16:15 ish (UTC) with the latest version which is release 1.7 dated 11 January 2013. I've added a description of the stdin and stdout file names along with a number of "interesting" examples of their use, viz: * creating a local database clone without using an intermediate dump file. * creating a local clone of a remote database over an ssh connection. * cloning a local database to a remote server using an ssh connection. * cloning a remote database on one server, to another (different) server. If you click on the pdf link above, you should get the latest document. The html link appears cached on my system, but if should expire/refresh soon. Cheers, Norm. On 11/01/13 15:56, Steve Friedl wrote: > Hi folks, > > I'm the writer of the blog post that raised this issue, I had already posted > an issue for the tracker before I blogged about it for Google. > > I believe that it's *only* a documentation issue, because even though the > behavior is somewhat unconventional for a UNIX/Linux system, it works now on > all the systems you support, and that means it's probably too painful (and > unnecessary) to change. > > It does occur to me that the code could be changed a bit so that if gbak > gets the EPIPE error, the failure message could somehow mention that, as it > would probably give a better searchable error, but mucking with the code is > a lot more work (and risk) than just enhancing the docs. > > I appreciate the consideration you folks have given to this issue. > > Steve -- Master HTML5, CSS3, ASP.NET, MVC, AJAX, Knockout.js, Web API and much more. Get web development skills now with LearnDevNow - 350+ hours of step-by-step video tutorials by Microsoft MVPs and experts. SALE $99.99 this month only -- learn more at: http://p.sf.net/sfu/learnmore_122812 Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Firebird SQL's backup/restore uses magic words for stdin and stdout
Hi folks, I'm the writer of the blog post that raised this issue, I had already posted an issue for the tracker before I blogged about it for Google. I believe that it's *only* a documentation issue, because even though the behavior is somewhat unconventional for a UNIX/Linux system, it works now on all the systems you support, and that means it's probably too painful (and unnecessary) to change. It does occur to me that the code could be changed a bit so that if gbak gets the EPIPE error, the failure message could somehow mention that, as it would probably give a better searchable error, but mucking with the code is a lot more work (and risk) than just enhancing the docs. I appreciate the consideration you folks have given to this issue. Steve -Original Message- From: Norman Dunbar [mailto:nor...@dunbar-it.co.uk] Sent: Friday, January 11, 2013 3:25 AM To: firebird-devel@lists.sourceforge.net Subject: Re: [Firebird-devel] Firebird SQL's backup/restore uses magic words for stdin and stdout Morning all, On 11/01/13 09:54, Lester Caine wrote: > *IS* the problem described simply documentation. Since the functions > are available in various OS's, 'stdout' seems reasonable to me ... I > expect it to work on Linux but probably due to coming from a windows background? I've updated the gbak docs to cover this. I'll be uploading soon when I've checked spelling and so on and correctness of build. I've posted a bit more detail in the docs mailing list. The version you will want is 1.7 dated 11 january 2013. Cheers, Norm. -- Norman Dunbar Dunbar IT Consultants Ltd Registered address: Thorpe House 61 Richardshaw Lane Pudsey West Yorkshire United Kingdom LS28 7EL Company Number: 05132767 -- Master HTML5, CSS3, ASP.NET, MVC, AJAX, Knockout.js, Web API and much more. Get web development skills now with LearnDevNow - 350+ hours of step-by-step video tutorials by Microsoft MVPs and experts. SALE $99.99 this month only -- learn more at: http://p.sf.net/sfu/learnmore_122812 Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel -- Master HTML5, CSS3, ASP.NET, MVC, AJAX, Knockout.js, Web API and much more. Get web development skills now with LearnDevNow - 350+ hours of step-by-step video tutorials by Microsoft MVPs and experts. SALE $99.99 this month only -- learn more at: http://p.sf.net/sfu/learnmore_122812 Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Firebird SQL's backup/restore uses magic words for stdin and stdout
Morning all, On 11/01/13 09:54, Lester Caine wrote: > *IS* the problem described simply documentation. Since the functions are > available in various OS's, 'stdout' seems reasonable to me ... I expect it to > work on Linux but probably due to coming from a windows background? I've updated the gbak docs to cover this. I'll be uploading soon when I've checked spelling and so on and correctness of build. I've posted a bit more detail in the docs mailing list. The version you will want is 1.7 dated 11 january 2013. Cheers, Norm. -- Norman Dunbar Dunbar IT Consultants Ltd Registered address: Thorpe House 61 Richardshaw Lane Pudsey West Yorkshire United Kingdom LS28 7EL Company Number: 05132767 -- Master HTML5, CSS3, ASP.NET, MVC, AJAX, Knockout.js, Web API and much more. Get web development skills now with LearnDevNow - 350+ hours of step-by-step video tutorials by Microsoft MVPs and experts. SALE $99.99 this month only -- learn more at: http://p.sf.net/sfu/learnmore_122812 Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Firebird SQL's backup/restore uses magic words for stdin and stdout
On Fri, Jan 11, 2013 at 09:54:54AM +, Lester Caine wrote: > > *IS* the problem described simply documentation. Since the functions are > available in various OS's, 'stdout' seems reasonable to me ... I expect it to > work on Linux but probably due to coming from a windows background? On unix systems, it is a widely respected convention that telling a command to write to standard output or read from standard input is done either by omitting the file name or by using "-". Using a string like "stdin" or "stdout" which looks like a normal filename is really unusual, unexpected and surprising. I remember I've been also very surprised when I found out (or rather when I was told). However, as gbak has been working this way for a long time, I guess properly documenting the behaviour should be sufficient. After all, the risk that someone would accidentally name their backup file "stdin" or "stdout" is very low. Michal Kubecek -- Master HTML5, CSS3, ASP.NET, MVC, AJAX, Knockout.js, Web API and much more. Get web development skills now with LearnDevNow - 350+ hours of step-by-step video tutorials by Microsoft MVPs and experts. SALE $99.99 this month only -- learn more at: http://p.sf.net/sfu/learnmore_122812 Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Firebird SQL's backup/restore uses magic words for stdin and stdout
On 01/11/13 13:54, Lester Caine wrote: > marius adrian popa wrote: >> http://blog.unixwiz.net/2013/01/unhappy-surprise-firebird-sqls-backuprestore-uses-magic-words-for-stdin-and-stdout.html > *IS* the problem described simply documentation. Since the functions are > available in various OS's, 'stdout' seems reasonable to me ... I expect it to > work on Linux but probably due to coming from a windows background? > 'stdin/stdout' work cross-OS. Moreover, they work in services since 2.5.2 (stream is delivered from/to fbsvcmgr). Certainly /dev/std* can't replace existing approach in all aspects. On the other hand /dev/std* is standard de-facto for unix now, moreover with file redirection gbak works fine using them - only pipe is a problem. I think we may easily fix it. -- Master HTML5, CSS3, ASP.NET, MVC, AJAX, Knockout.js, Web API and much more. Get web development skills now with LearnDevNow - 350+ hours of step-by-step video tutorials by Microsoft MVPs and experts. SALE $99.99 this month only -- learn more at: http://p.sf.net/sfu/learnmore_122812 Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Firebird SQL's backup/restore uses magic words for stdin and stdout
marius adrian popa wrote: > http://blog.unixwiz.net/2013/01/unhappy-surprise-firebird-sqls-backuprestore-uses-magic-words-for-stdin-and-stdout.html *IS* the problem described simply documentation. Since the functions are available in various OS's, 'stdout' seems reasonable to me ... I expect it to work on Linux but probably due to coming from a windows background? -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http://lsces.co.uk EnquirySolve - http://enquirysolve.com/ Model Engineers Digital Workshop - http://medw.co.uk Rainbow Digital Media - http://rainbowdigitalmedia.co.uk -- Master HTML5, CSS3, ASP.NET, MVC, AJAX, Knockout.js, Web API and much more. Get web development skills now with LearnDevNow - 350+ hours of step-by-step video tutorials by Microsoft MVPs and experts. SALE $99.99 this month only -- learn more at: http://p.sf.net/sfu/learnmore_122812 Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-4031) make install wrong under Debian Ubuntu 64
make install wrong under Debian Ubuntu 64 - Key: CORE-4031 URL: http://tracker.firebirdsql.org/browse/CORE-4031 Project: Firebird Core Issue Type: Bug Components: Installation Affects Versions: 2.5.2 Environment: Debian or Ubuntu 64 Reporter: Philippe Makowski Priority: Minor working on the daily build and tests, I got a bug in 'make silent_install' under Debian Ubuntu 64 libraries have symlinks in /usr/lib64, but /usr/lib64 is the wrong place and don't normally exist under Debian Ubuntu 64 so when you do a 'make silent_install', ldconfig doesn't work -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira -- Master HTML5, CSS3, ASP.NET, MVC, AJAX, Knockout.js, Web API and much more. Get web development skills now with LearnDevNow - 350+ hours of step-by-step video tutorials by Microsoft MVPs and experts. SALE $99.99 this month only -- learn more at: http://p.sf.net/sfu/learnmore_122812 Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Firebird SQL's backup/restore uses magic words for stdin and stdout
On Fri, 11 Jan 2013 11:33:29 +0200, marius adrian popa wrote: > I will post more info from now on , i guess i'm used to the short > messages on twitter Thanks; btw even 'link-only' tweets are usually spam :) Mark -- Master HTML5, CSS3, ASP.NET, MVC, AJAX, Knockout.js, Web API and much more. Get web development skills now with LearnDevNow - 350+ hours of step-by-step video tutorials by Microsoft MVPs and experts. SALE $99.99 this month only -- learn more at: http://p.sf.net/sfu/learnmore_122812 Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Firebird SQL's backup/restore uses magic words for stdin and stdout
I will post more info from now on , i guess i'm used to the short messages on twitter On Fri, Jan 11, 2013 at 10:18 AM, Mark Rotteveel wrote: > On Fri, 11 Jan 2013 10:01:40 +0200, marius adrian popa > wrote: >> > http://blog.unixwiz.net/2013/01/unhappy-surprise-firebird-sqls-backuprestore-uses-magic-words-for-stdin-and-stdout.html > > Why are you just posting URLs? I find it slightly confusing and mildly > annoying to get a message with just an URL in it and no further > information, especially as that is also the way some spam messages work. > > Could you please include some additional info when sending these kinds of > things to the lists? > > Mark > > -- > Master HTML5, CSS3, ASP.NET, MVC, AJAX, Knockout.js, Web API and > much more. Get web development skills now with LearnDevNow - > 350+ hours of step-by-step video tutorials by Microsoft MVPs and experts. > SALE $99.99 this month only -- learn more at: > http://p.sf.net/sfu/learnmore_122812 > Firebird-Devel mailing list, web interface at > https://lists.sourceforge.net/lists/listinfo/firebird-devel -- Master HTML5, CSS3, ASP.NET, MVC, AJAX, Knockout.js, Web API and much more. Get web development skills now with LearnDevNow - 350+ hours of step-by-step video tutorials by Microsoft MVPs and experts. SALE $99.99 this month only -- learn more at: http://p.sf.net/sfu/learnmore_122812 Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Firebird SQL's backup/restore uses magic words for stdin and stdout
On Fri, 11 Jan 2013 10:01:40 +0200, marius adrian popa wrote: > http://blog.unixwiz.net/2013/01/unhappy-surprise-firebird-sqls-backuprestore-uses-magic-words-for-stdin-and-stdout.html Why are you just posting URLs? I find it slightly confusing and mildly annoying to get a message with just an URL in it and no further information, especially as that is also the way some spam messages work. Could you please include some additional info when sending these kinds of things to the lists? Mark -- Master HTML5, CSS3, ASP.NET, MVC, AJAX, Knockout.js, Web API and much more. Get web development skills now with LearnDevNow - 350+ hours of step-by-step video tutorials by Microsoft MVPs and experts. SALE $99.99 this month only -- learn more at: http://p.sf.net/sfu/learnmore_122812 Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] Firebird SQL's backup/restore uses magic words for stdin and stdout
http://blog.unixwiz.net/2013/01/unhappy-surprise-firebird-sqls-backuprestore-uses-magic-words-for-stdin-and-stdout.html -- Master HTML5, CSS3, ASP.NET, MVC, AJAX, Knockout.js, Web API and much more. Get web development skills now with LearnDevNow - 350+ hours of step-by-step video tutorials by Microsoft MVPs and experts. SALE $99.99 this month only -- learn more at: http://p.sf.net/sfu/learnmore_122812 Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
