World: r3wp

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 
?

Sorry, 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.

rebooting CureCode...

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.

OK. Trying...

hmm, failed to log on...

Works like a charm !

right, works now.

index.rsp doesn't work !

(Accueil link)

let me see that...

works here

right, works only when Projects selector is set to "all"

There's a bug in %index.rsp from a change I did last week in the 
statistics SQL code. Fixing...

Fixed

Should work ok now.

The "Attached Files" zone in ticket edition mode is not yet working 
so just ignore it.

ok. Must go. See later

If someone can do a step by step blow on installing curecode ( including 
what ever one has to do with mysql ) .. I will try and set it up 
as well .. I need a public bug tracking database too.