Support

UNiTE, Remote CLI, eXtract Wizard

#3489 Failed to open database jpremote.s3db

Posted in ‘UNiTE and Remote CLI’
This is a public ticket

Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.

Environment Information

PHP version
n/a
Tool
UNiTE
Tool version
n/a

Latest post by nicholas on Wednesday, 13 May 2009 05:44 CDT

user1016
Hello there , first I want to congratule Joomlapack team for this great piece of software that make our lives easy.

Today I updated to latest version of native tools(2009.1.0.0) , in the first place i didnt uninstall the previous version. Thenh when I started the program i get the following error:

failed to open database jpremote.s3db and I keep getting popup windows auntill the end of the world.(you have to close the program throught the task manager)

Then I tried to uninstall all versions and do it from the start with the same results , same error. I dont know what to do now.

Thanks for your time.

dlb
The newer versions use a SQLite database instead of the previous ini file to store their data. I think that's where the problem is. I'll ask Nicholas to take a look at this.

Dale


Dale L. Brackin
Support Specialist


us.gifEnglish: native


Please keep in mind my timezone and cultural differences when reading my replies. Thank you!


????
My time zone is EST (UTC -5) (click here to see my current time in Philadelphia, PA)

nicholas
Akeeba Staff
Manager
Are you using it as a portable application, or through the regular desktop installer? Does your Windows user name contain any non-ASCII (e.g. accented, Cyrillic, Greek or ideographic) characters?

Nicholas K. Dionysopoulos

Lead Developer and Director

🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

user1016
Hi , thanks for your prompt reply , the username is in regular characters. I installed the normal windows installer, weird.

nicholas
Akeeba Staff
Manager
Normally, JoomlaPack tries to create the jpremote.s3db (the settings SQLite database) on the Documents and Settings\YourUserName\Local Settings\Application Data\JoomlaPack Remote folder. Please verify that this directory is writable. Also tell me if the jpremote.s3db file is there.

If it exists, it may have become corrupt. You can delete it (uninstallation doesn't remove it) and re-run JoomlaPack Remote. Of course, this approach means that you lose your settings, but I'm not aware of an easy way to check and fix an SQLite database file.

Nicholas K. Dionysopoulos

Lead Developer and Director

🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

user1016
Hi Nicholas , thank you.

I checked everything , the folder you mention is empty and there is no file inside(not even hidden file) and the folder have the apropiate permissions to write.

nicholas
Akeeba Staff
Manager
OK, since there is no file, the error message means that it can't create the file. Is there a JoomlaPackRemote.ini inside the application's directory? This file is normally used to run Remote in portable mode. So, if there is, Remote will try to create the jpremote.s3db file inside the application's directory. Since permissions are more strict in there, this might fail and give you an error. Deleting the INI file should let Remote create the file. The same applies if there is a jpremote.s3db file in the same directory as the application. Remove it too if it exists.

If this still doesn't work, there is some other filesystem related problem which doesn't allow the creation of the s3db file in the pre-defined location. In this case, you may want to use the ZIP version of Native Tools, extract is somewhere inside your My Documents folder and follow the instructions in the "Using Remote as a portable application" section of the documentation. Specifically, you'll have to create a text file named "JoomlaPackRemote.ini" with the following contents:
[Global]
Portable=-1

This will instruct JoomlaPack Remote to write its configuration file in the same directory as the application files. Since it's now a subdirectory of your "My Documents" directory, Remote should be able to write to it.

Nicholas K. Dionysopoulos

Lead Developer and Director

🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

user5515
i have the same problem, i use OS XP (Spanish), framework 3.5, Visual Studio 2008, MS Server Express 2005, and still dont work.

i have a notebook with Vista and work perfectly.

forgive my bad English

dlb
Did you attempt the solutions that Nicholas described in this thread? We need to know what you have done in order to know what to try next.

Dale


Dale L. Brackin
Support Specialist


us.gifEnglish: native


Please keep in mind my timezone and cultural differences when reading my replies. Thank you!


????
My time zone is EST (UTC -5) (click here to see my current time in Philadelphia, PA)

user5526
I have the same problem.

I solved it creating the ini file in the directory of the app. There is no need to uninstall and/or reinstall or unzip. If you got this problem, until the developers find the reason, you can simply create the ini file and run the app.

( Some data for the developers
Windows XP - Pro SP2
installed in D: (C: for swapping)
app installed in e:

Apps installed:
ORACLE, MySQL, Apache, JBOSS, Eclipse, NetBeans, etc.

)

Thanks!

dlb
I'm glad you got it running! Nicholas will have this thread flagged from the previous posting, so he will see the additional information when he checks in.

Dale


Dale L. Brackin
Support Specialist


us.gifEnglish: native


Please keep in mind my timezone and cultural differences when reading my replies. Thank you!


????
My time zone is EST (UTC -5) (click here to see my current time in Philadelphia, PA)

nicholas
Akeeba Staff
Manager
I have tried that on Windows XP Pro + SP3 at work, but I had no problem. This seems to be some obscure Windows permissions problem. Normally, the user has enough permissions to write to his own profile directory, or at least that's the whole idea of user profile directories. Normally, writing to the application's directory should be impossible, at least on the "Professional" variants of Windows :shock: I can't get why this workaround works :?

So far, I have met no problem with the standard configuration on XP Home SP2, XP Home SP3, XP Pro SP3, Windows 7 Beta. Lack of an affected system makes it very difficult to debug it, or at least figure out what's going on.

Nicholas K. Dionysopoulos

Lead Developer and Director

🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

Support Information

Working hours: We are open Monday to Friday, 9am to 7pm Cyprus timezone (EET / EEST). Support is provided by the same developers writing the software, all of which live in Europe. You can still file tickets outside of our working hours, but we cannot respond to them until we're back at the office.

Support policy: We would like to kindly inform you that when using our support you have already agreed to the Support Policy which is part of our Terms of Service. Thank you for your understanding and for helping us help you!