[!CureCode] web-based bugtracking tool
Good reasons, and I agree, the best way to do this. We nee da universal XML export import with ID compare. In other words, CureCode needs to be able to export itself as XML (Easy). It needs to import XML (Easy) It needs to import XML and update the old XML keying on some ID value. Not so easy. Once done, building things like RSS feeds with just the top 10 recent changes becomes easy. Also, then we can sync Qtask and CureCode. There are a lot of cool side effects though… - We have an integrated file share, so you can link to screen shots. - Qtask has the ability to have conversation about each issue. - You can throw your issues onto a calendar view. I know this is not your concern right now, but this is the direction we are going in, and need to learn how to best allow this type of integration. Much as you have made one thing to test another, we have the same problem constantly.
R: if both QTask and CureCode are Rebol, why the need for the XML middle man? Especially when Rebol exchange data is more versatile than XML.
Because this is not about Qtask, or Cheyenne (CureCode), it is about building things that lets others know that what they have can be made better by working with us, and if we work well with others (and each other) then we all win. XML sucks, and sure we could exchange RBF (Rebol Block Format). But millions of programs work with XML, so just use it. Let's pick out battles…
I really like having a full example of a Cheyenne RSP solution and appreciate the effort that Doc made to build and disclose his coding approach.
I've thought about interfacing with external world. I need first to define a consistent kernel for CureCode (partially done in the DB abstraction layer) then I could easily interface with outside world through reb|web-services, REST, XML, RSS,...
Syncing with Qtask, why not, CureCode just needs to be a little bit more mature. One cool thing I'd like to have is an embeddable version of CureCode : I'd like to distribute a single binary with Cheyenne and CureCode bundled together (using sqlite as backend) for fast and very easy enterprise deployment. All the product will remain FOSS, but my company could sell support, customization and specific interfacing with third-party softwares.
All cool stuff...
typo: Reproductibility = should be Reproducibility
Where can I download the latest version of curecode ? The links posted are dead. thanks
TRETBASE might work as a backend, at the minimum the newest builds since it is server based.
The files were not restored after last disk crash. It's done now, so this URL will work : http://softinnov.org/dl/curecode-r091.zip
Btw, here's also the data model used by Curecode : http://softinnov.org/dl/DB-schema.png
Paul : if TRETBASE can support the same DB structure, support SQL JOINs (or similar feature), user and security management, not being more verbose than SQL, and being as fast as MySQL without using more memory, I'll drop MySQL at once and use TRETBASE as a backend in all my projects.
Doc give me a bit more time and I will have that. It isn't ACID compliant yet so wouldn't recommend in its current state except in very controlled situations.
Doc, nice DB schema pic. What have you used to create it?
How does virtual domains work?
Schema : I'm using Microsoft Visio.
Virtual domains: Is your question related to CureCode or Cheyenne ?
Replying in Cheyenne group.
that picture reminds me Ladybird a Database designer wirted in rebol (project by reprotizer and Coccinelle)
hum curecode is a ticket tracker ? like rambo but done with cheyenne that's right ?
sorry i'm discovering it ....
CureCode is a lightweight bugtracker inspired by Mantis (a popular tracker in php). It's implemented using RSP and use MySQL as a backend.
it's nice anyway good job dock ^^
Doc, how hard would it be to switch to SQLite in the backend?
It's a planned feature. It just needs a SQLite REBOL driver with an API compatible with my MySQL driver or RT's DB drivers.
I guess that it would also needs a few changes in the SQL requests also, MySQL specific features like LAST_INSERT_ID( ) need to be ported. Anyway, it shouldn't take more than a couple of hour to make it work with SQLite (once you have the right driver).
On http://softinnov.org:8000/curecode I have tried to create an account to test it a bit. But, when using the link in the mail to confirm my account I have an error in curecode :
> RSP Error Trapped< Error Code : 310 Description : script error ! validate-user has no refinement called update Near : [if not validate-user/update request/content [err?: yes]] Where : protected-exec
I have downloaded Curecode source. The func is defined in "db-abstract.r" and has the missing refinment ! So what ? Is just the installed file on the site not up to date ?
I'm not familiar with RSP, but it seems it's loaded one time then run with the webserver (not like cgi that are loaded on each call). So maybe it just need to be restart to handle already corrected code !?
Thanks, DideC, I'll fix that tonight.
Just a note... I had to restart the server to get CC running... reloading config is not enough.
Also I'm missing basic instalation notes... 1. to add into httpd.conf: webapp [ virtual-root "/curecode" root-dir %www/curecode-r091/ ;or different dir ] 2. To get a known admin password, change in private/build-db.sql: EE10C315EBA2C75B403EA99136F5B48D to 21232F297A57A5A743894A0E4A801FC3 ;(enbase/base checksum/method "admin" 'md5 16) = so the known password will be 'admin' for admin account 3. to run private/install.r script
And there must be something more as registering new user gives error: Error Code : 500 Description : access error ! Cannot open /c/rebol/server/Cheyenne/www/curecode-r091/www/curecode-r091/nonenone/email-activation.tpl Near : [template: read join locale/get-path %email-activation.tpl] Where : send-confirmation
to get rid of the first none, it's resuired to add: locales-dir %locales/ into webapp block... the second none is difficult. at least i really cannot find, how to set the 'lang in locales. The 'default-lang in 'webapp seems not to be working and in main httpd.conf as well. It must be a bug (or missing feature) in public version of the Cheyenne.
Admin install password is "nimda"
It requires also a valid SMTP server in %private/curecode.conf.
should be : locales-dir %private/locales/
Didec : the bug you've found is related to the Cheyenne instance version (0.9.17) CureCode's demo is running on. It's a typical case of global context word collision between several apps defining global functions using the same name. That's why I've sandboxed, by default, all RSP webapps in v0.9.19.
Is the reboot done ? I get "La connexion avec le serveur a été réinitialisée pendant le chargement de la page." while trying the confirmation link.
It's down currently, I'm trying to migrate the CureCode webapp to the main Cheyenne instance on the server, but it seems I've messed up something in the config file.
Ah, looks like it's missing a user right access in MySQL.
Up and working now.
Ah, important notice : URL has changed, it's now http://softinnov.org/curecode/
You may need to remove the :8000 part in the activation link.
hmm, failed to log on...