Uwe Grauer wrote: > Carl Karsten wrote: >> Uwe Grauer wrote: >>>> So if you can provide scripts that can setup a test db, including removing >>>> a >>>> previous one, I will run them. >>>> >>>> Carl K >>> I send the sql-script but if this isn't enough just do a restore of >>> the testdb i attached to http://dabodev.com/tracker/0274 >>> >>> Use the following comandline: >>> >>> /opt/firebird/bin/gbak -c -v -user SYSDBA -password masterkey >>> all_types_fb2.fbk hostname:/yourpath/test_all.fdb >>> >>> Change your username, password, hostname and filepath according >>> to what you are using. >> >> sudo apt-get install firebird2-super-server firebird2-utils-super >> wget http://dabodev.com/tracker/0274/all_types_fb2.fbk >> >> ++ gbak -c -v -user SYSDBA -password foo all_types_fb2.fbk >> localhost:test_all.fdb > > What's your login and your current directory when you run gbak?
user:juser dir: ~/test Why does that matter? > Provide the right path when you use gbak. > The server has to have write access there. I have no idea what defines "right path." I am surprised it is not a server default, and something the client has to specify. > > gbak is a client tool. The server doesn't know your current working > directory. > >> gbak: opened file all_types_fb2.fbk >> gbak: transportable backup -- data in XDR format >> gbak: backup file is compressed >> gbak: ERROR: Expected backup version 1, 2, or 3. Found 7 >> gbak: Exiting before completion due to errors >> > > I tested this my machine and it worked. Did you install the ubuntu package? > The md5-sum of the backup file is: > d0d73f191dea742e952e4783aefdc1a4 /home/uwe/tmp/testit/all_types_fb2.fbk > >> What is the command line way to run the CREATEs you posted to >> http://dabodev.com/tracker/0274 ? >> > > Don't know how to do it exactly with isql out of my head. > As i told you i haven't used isql for a long time. > Read it up for yourself. > >> Using a backup file to run tests on creates an unknown. one could probably >> figure them out, but better to use the CREATE. > > What do you mean with this? Don't understand whats your problem. For running tests, it is good to know what you are testing against. the easier it is to read/understand, the easier it is to debug. to me, that means a script. and a script is good because it allows you to wipe it out the server and rebuild it as part of the test. > Instead of calling isql you call gbak in the script. > > I told you. You have to know what you are doing here. > Running DDL scripts while there are open connections to an already > existing database doesn't work in firebird. > > Read this for a start: > http://firebirdsql.org/pdfmanual/Firebird-2.0-QuickStart.pdf > I don't have time to figure it out. You seemed to have an interest and the needed knowledge, so I asked if you could give steps to setup the test environment. I was assuming you would be able to do this easily. I was not expecting any of us to have to do research. I feel we have made some progress. as long as we are making sufficient progress, I am still willing to run things I can put in a script. Carl K _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev
