Carl Karsten wrote: > 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? >
Because the server creates the new db and has to have write permission where the db should be created. This means you have to choose a path where the user firebird has write permissions. On my machine i put all databases into /opt/firebird/data which is owned by user firebird and group firebird. >> 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? > As i said i currently have no access to a ubuntu box. I have opensuse 10.2 here. But given that the ubuntu package is working, there shouldn't be any differences between running this on suse or ubuntu. >> 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. > Yes, but only if there are no other connection opened to that db. >> 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. > Come on, i was willing to help and i spend more time than needed for this today. You insisted to do what i told you. And i think reading a quickstart guide when you start using a new database system is the minimum you have to do. If you asked for help to get a testenviroment for Paul in the first place and he absolutly needed this as a script, then i would have spend my time on writing the script and it would have long been there. > 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 > To Paul: Do you need a python-script similar to test_dCursorMixin.py from your sandbox branch? If so, let me know and i try to do it tomorrow. Uwe _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev
