Hello,

Skrooge is now prompting for a password on a file I've been using for years. It's even doing this on very old backups of this file. Why would it do this?

I opened this file on Monday for the last time, to add one transaction. Before that, I hadn't used Skrooge for weeks. Then today I find this problem.

I have Skrooge v1.7.1 running on Kubuntu 12.04. Could it be a regression introduced in a recent release?

Cheers,

- Gustavo.

Most of the time, this is due to a "corrupted" file.

Could you check that your file has a normal size (not 0)?
Do you have the same problem with the beta version of my ppa?
http://skrooge.org/ubuntu_installation

If you still have the problem, you can send me your file by email for analysis.
My name is Stephane MANKOWSKI and I am the main developer of Skrooge.

Hi, and thanks for your reply.

The file is 2.8MB. And I tried the latest beta release, but I still could not open the file, not even its old backup.

That said, I tried one thing I hadn't tried before: Create a copy of the file with "skrooge-convert". And it worked! I have a new ".skg" file which I can open with Skrooge. But now I wonder: Will the new file be missing any data from the original?

I guess this points to a bug in the Skrooge GUI, which I'm most happy to help you diagnose. However, is there any way that I can help apart from sending the original file? I have to say, as much as I appreciate the help, I can't help but feel really nervous about sending all of my financial information for the past four years. So, is there any other way that I can help? For example, debugging information, logs, etc. I'd even be happy to send an excerpt of the original file (e.g., the first 100KB) or use "strace".

Cheers,

- Gustavo.

gustavonarea wrote:Hi, and thanks for your reply.

The file is 2.8MB. And I tried the latest beta release, but I still could open the file, not even its old backup.

That said, I tried one thing I hadn't tried before: Create a copy of the file with "skrooge-convert". And it worked! I have a new ".skg" file which I can open with Skrooge.

This is strange because skrooge and skroogeconvert use the same code.
So, I don't understand why skrooge is not able to open your document and why skroogeconvert is not able.

gustavonarea wrote:But now I wonder: Will the new file be missing any data from the original?

Except budgets, all information should be transferred.

gustavonarea wrote:
I guess this points to a bug in the Skrooge GUI, which I'm most happy to help you diagnose. However, is there any way that I can help apart from sending the original file? I have to say, as much as I appreciate the help, I can't help but feel really nervous about sending all of my financial information for the past four years. So, is there any other way that I can help? For example, debugging information, logs, etc. I'd even be happy to send an excerpt of the original file (e.g., the first 100KB) or use "strace".

Yes you can help!
Could you try this from a console?
1-export SKGTRACE=255
2-skrooge --nofork > traces.txt
3-send me by email traces.txt

gustavonarea wrote:Cheers,

- Gustavo.

Thank you for your help.
Stephane

I'll try that now. In the mean time, can you please provide me with your email address (e.g., via PM)?

Ha! Something interesting now happened: If I run Skrooge with the environment variable you asked me to set and "--nofork", it's able to open the file and then migrate it.

But if I open the same file again without doing anything special, it'll prompt for a password which, if not provided, results in the following error message: http://i.imgur.com/2edkM3g.png

I'll send you the traces via email anyway.

Cheers.

gustavonarea wrote:Ha! Something interesting now happened: If I run Skrooge with the environment variable you asked me to set and "--nofork", it's able to open the file and then migrate it.

Hi,
Are you sure because I don't see that in traces?

In traces, I can see that:

Code: Select all

##    SKGDocument::load
##    Input parameter [name]=[Documents/Finances.skg]
##      SKGDocument::close
##      SKGDocument::close RC=[SUC-0]
##      SKGServices::cryptFile
##      Input parameter [iFileSource]=[Documents/Finances.skg]
##      Input parameter [iFileTarget]=[/tmp/.Finances.skg.wrk]
##      Input parameter [iHeaderFile]=[SKROOGE]
...
...
##    SKGDocument::load RC=[ERR-12]: Could not start process Unable to create io-slave:
klauncher said: Unknown protocol ''.


It means that:
1-Skrooge tries to open the file "Documents/Finances.skg".
2-Because this URL is not valid, the load fails with "Unknown protocol".

So, for me, this file has not been loaded and a new empty one has been created.

Now the question is: "Why the URL is not valid?"
Indeed "Documents/Finances.skg" is not a valid file name.
This should be something like this "file:///home/user1/Documents/Finances.skg".

So, how do you select the file to load? By the File/Open function? By the Recent Files? Other?

gustavonarea wrote:But if I open the same file again without doing anything special, it'll prompt for a password which, if not provided, results in the following error message: http://i.imgur.com/2edkM3g.png

I'll send you the traces via email anyway.

Cheers.

Hi Stephane.

I switched to running Skrooge via the CLI as soon as it started prompting for a password, hoping to see something on STDERR.

You're right, "--nofork" doesn't make any difference. I can confirm that Skrooge prompts for a password when it gets the ".skg" file path in an unsupported format. Maybe it'd be best to let the user know that the file couldn't be found? It'd be even better if it supported relative paths.

Cheers,

- Gustavo.

gustavonarea wrote:Hi Stephane.

I switched to running Skrooge via the CLI as soon as it started prompting for a password, hoping to see something on STDERR.

You're right, "--nofork" doesn't make any difference. I can confirm that Skrooge prompts for a password when it gets the ".skg" file path in an unsupported format. Maybe it'd be best to let the user know that the file couldn't be found? It'd be even better if it supported relative paths.

Cheers,

- Gustavo.

Hi,

If the user uses the "File/Open" function, the path is correct and the document loaded.
How did you do to select a relative paths?
Could you send me the detailed scenario?

Thank for help.
Stephane

Hi,

Do you have an answer?
This could hep me to improve quality of Skrooge.

After doing a fresh install of ubuntu 12.04 i encountered this error. trying to open a .skg file that had no trouble opening previously. I am using the same version ubuntu and skrooge 1.7.1 as before the install. The file is not 0 bytes and the .old will not open either. Skroogeconvert failed as above. Asks for password that was never set, regardless how i try to open.

mr1ncred1ble wrote:After doing a fresh install of ubuntu 12.04 i encountered this error. trying to open a .skg file that had no trouble opening previously. I am using the same version ubuntu and skrooge 1.7.1 as before the install. The file is not 0 bytes and the .old will not open either. Skroogeconvert failed as above. Asks for password that was never set, regardless how i try to open.

Could you generate traces as described here http://skrooge.org/node/37 ?

did as you asked and tried opening a copy of my skrooge.skg from my desktop. I used file > open, the open button, and import all asked for a password. Here is cut and paste from traces.txt

Code: Select all

##WARNING: PRAGMA journal_mode=MEMORY
##         returns :database disk image is malformed Unable to execute statement
##WARNING: PRAGMA journal_mode=MEMORY
##         returns :database disk image is malformed Unable to execute statement
##WARNING: PRAGMA journal_mode=MEMORY
##         returns :database disk image is malformed Unable to execute statement

update: I was able to open a backup copy of my .skg file that i accidentally created before i did my fresh install. Seems at some point i grabbed my entire home folder and saved it to an external drive. In that home folder is my Dropbox folder where I actually store the .skg file i use regulary. I store it there so it get's backed up regularly without action from me. Seems that may have something to do with the password and or file corruption issue. Anyway, I was able to open my backup copy no problem. I would suggest that anyone storing there .skg files anywhere other than a local folder make regular backups elsewhere.

Just for information, I created a new version of Skrooge (1.7. without password panel displayed in case of corrupted file.
For ubuntu, this version is available in my beta ppa:
http://skrooge.org/ubuntu_installation