create sqlcipher database on sd-card

[gseebacher]

hi,
i'm using openhelper to create sqlite databases. now i want to move to sqlcipher to encrypt my databases.
when i try to create a database on the sd-card i get an error "sqlite returned: error code = 14, msg = cannot open file at line ..."
creation of internal db works fine.
i have added the WRITE_EXTERNAL_STORAGE - permission to the manifest file.

seems that the onCreate does not get fired.
do you have any idea what is going wrong?
thanks in advance.

[developernotes]

Hi gseebacher,

Are you using SQLiteDatabase.openOrCreateDatabase(...);? What path are you using? Also, have you checked to see if your SD Card is mounted?

[gseebacher]

hi Nick,

thank you very much for your response. in the meantime i managed to get it
working. :-)
do you know by chance if the encryption libraries also work when i want to
create a encrypted sqlite db in windows using jdeveloper?

thanks, ciao
gerhard

2012/11/19 Nick Parker notifications@github.com

Hi gseebacher,

Are you using SQLiteDatabase.openOrCreateDatabase(...);? What path are
you using? Also, have you checked to see if your SD Card is mounted?

—
Reply to this email directly or view it on GitHubhttps://github.com//issues/67#issuecomment-10518448.

[developernotes]

Hi gseebacher,

The SQLCipher for Android binaries require the Android runtime to exist, even with the new x86 build of the binaries. So this is not something that would work.

[gseebacher]

thanks Nick!

2012/11/19 Nick Parker notifications@github.com

Hi gseebacher,

The SQLCipher for Android binaries require the Android runtime to exist,
even with the new x86 build of the binaries. So this is not something that
would work.

—
Reply to this email directly or view it on GitHubhttps://github.com//issues/67#issuecomment-10526323.

[pligor]

Let me share a solution that worked for all android versions and is based upon this stackoverflow answer: http://stackoverflow.com/a/9168969/720484

Written in Scala:

/**
 * Useful to save the database in SD card
 * @param absoluteDirectoryPath the directory under which an sqlite database will be created
 */
class DatabaseContext(val absoluteDirectoryPath: String,
                      val password: String)(implicit val context: Context) extends ContextWrapper(context) {
  private val dbExtension = Some(".db");

  override def getDatabasePath(name: String): File = {
    val dbPath: String = absoluteDirectoryPath + File.separator + {
      if (dbExtension.isDefined && !name.endsWith(dbExtension.get)) name + dbExtension.get;
      else name;
    };

    val result = new File(dbPath);

    val parentFile = result.getParentFile;
    if (parentFile.exists) {
      //nop
    } else {
      parentFile.mkdirs;
    }

    result;
  }

  /*override def openOrCreateDatabase(name: String, mode: Int, factory: CursorFactory) = {
    //if something wrong with the database consider setting the factory argument to null in the line below
    SQLiteDatabase.openOrCreateDatabase(getDatabasePath(name), password, factory);
  }*/
}