On Sun, Feb 15, 2009 at 6:56 PM, Nigel Westbury
<nigelipse@xxxxxxxxxx> wrote:
I have always been
hoping the Babel server could be used on open source projects such as those
hosted on SourceForge. I therefore tried to install Babel on SourceForge's
servers. I had a couple of problems.
The first is that
SourceForge do not allow us to create triggers. I have sent an e-mail to
SourceForge to ask for the reason and whether there would be any possibility of
getting such permission. If we can't create triggers then I was wondering
how much effort it would be have a version of Babel that does not use
triggers. I assume the PHP script could invoke the same statements that
would have been done by the trigger. This may be a problem not just at
SourceForge but on other installations on ISP hosted
servers.
Of course, and that's a problem for Intalio as well. Our hosted version of Babel had to work around the problem, and we had to fork the code for that.
So triggers are really specific to the Eclipse configuration.
If you have a good generic solutions for this, it'd be great. We need to create admin pages to deal with users.
I removed the
'create trigger' and 'drop trigger' statements from the setup script and the
script then ran successfully. However, when I try to go to the login page
I get:
An error has been encountered in accessing this page.
1. Server: jmoney.sourceforge.net
2. URL path: /error.php
3. Error notes: NONE
4. Error type: 404
5. Request method: GET
6. Request query string: errNo=101301
That means the database connection didn't work. Somehow a failed DB connection shows a blank page with that error. I think that's a leftover, and it never was well documented.
To work around that, add those lines to db_connection.class.php:
error_reporting(E_ALL);
ini_set("display_errors", 1);
Not being very
experienced with PHP and server side issues, I don't know how to debug
this. Searching on the error number shows nothing and I don't even know
where this number comes from. If I navigate directly to the help_babel.php
file then it shows fine. I did not set up an Apache alias so might this be
the problem? (I don't know if SourceForge allows aliases). Could the
absence of the triggers explain this?
Looks great!
Thanks,
Antoine