I've figured it out with your help! Is it also possible to encrypt it from the start? Or do I always have to run the tool?
Thanks, Jeff On Apr 2, 8:49 pm, Thomas Mueller <[email protected]> wrote: > Hi, > > > "Encryption error 90049" > > If you try out the 'Error Analyzer' on the home page (Reference / > Error Analyzer,http://www.h2database.com/html/sourceError.html) you > will see that this error means "trying to open an encrypted database > with the wrong file encryption password or algorithm." > > If the database already exists and you want to encrypt it later on (or > decrypt it), you need to use the ChangeFileEncryption tool, > seehttp://www.h2database.com/javadoc/org/h2/tools/ChangeFileEncryption.html > (please note the new Javadoc format!) You can run the tool from the > command line or from the H2 Console (Tools). > > Regards, > Thomas > > On Thu, Apr 2, 2009 at 5:04 AM, Abyric <[email protected]> wrote: > > > Sorry to add yet another post.. (wish I could edit my mails!) but the > > reason why I wish to use SSL on a local embedded database is because > > the user/pass can be intercepted. > > This is not desirable when you wish restrict access to your > > applications DB. > > > On Apr 2, 4:56 am, Abyric <[email protected]> wrote: > >> Right after posting I've found a relevant post when searching the > >> forum for another question I had. > > >>http://groups.google.com/group/h2-database/browse_thread/thread/4b80e... > > >> I get the impression that File encryption is only available when > >> running a server? and SSL also for that matter? > > >> Is SSL and File Encryption also available for the embedded version of > >> H2? > > >> On Apr 2, 4:34 am, Abyric <[email protected]> wrote: > > >> > Hi, after reading the manual and trying numerous times I keep getting > >> > stuck at trying to encrypt my DB files. > > >> > What Im doing is connect to my DB with the following URL in the H2 web > >> > console: > > >> > jdbc:h2:~/database;schema=testschema;CIPHER=AES > >> > username: sa > >> > password: filepw<space>sa > > >> > I altered admin user "SA"'s password to "sa". > >> > I keep getting an "Encryption error 90049" > > >> > What am I doing wrong? > > >> > Thanks! --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/h2-database?hl=en -~----------~----~----~----~------~----~------~--~---
