[Owncloud] Virtual Machine for Oracle Testing / Development

[Jörn Friedrich Dreyer]

Hi List, dear testers,

I wanted to get this out ASAP. Here is a downloadable VirtualBox VM with
debian wheezy, apache, php5 and Oracle XE 11g R2:
https://s3.owncloud.com/owncloud/public.php?service=files&t=d87645d07b443c4591c5a8aea77d94e2
Yeah, hosted on s3! 1.4GB with a snapshot containing a prestine /var/www.

The vm uses the hostname 'ocoradeb' and you should be able to access the
vm via
ssh ocoradeb.local -l <user>


    what works:

you can login with:
user:user ... not really needed, install asked for it
www-data:www-data - has a bash shell and /var/www/core contains a git
checkout of core, configured for the oracle db.
root:root - in case you need to fix anything

the currently checked out oracle_fixes branch already contains a lot of
fixes needes to make OC compatible with OC5.
most changes can also already be reviewed in th github branch
https://github.com/owncloud/core/commits/oracle_fixes

oh and you can get an awkward oracle sqlplus shell with:
sqlplus owncloud at localhost/XE

password for sys and system is oracle

If you ever want to install OC again, use
owncloud as dbuser,
owncloud as dbpassword,
XE as dbname (this one is important),
leave tablespace empty
localhost as dbhost

the checked out branch already contains fixes to make connections
actually work with these parameters. I'll submit a PR for OC4.5.10 that
fixes some connection problems there, too.


    what doesn't work:

well ... OC5 on oracle. I removed the not null constraint of the path
column in the oc_filecache table which causes MDB2 to try and migrate
the schema (I upped the revision in the version number) this fails, and
then I had to go debug customer js problems ...

I don't really know why the MDB2 based versioning also breaks. Beats me
... I'll have an extra drink on oracle ans JS tomorrow ;)

so long

Jörn
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/owncloud/attachments/20130509/c8b3591b/attachment.html>