RTFM 2.4.2 and SQLite?

Peter_Roosakos · March 3, 2010, 3:52am

I’m currently running a development environment with RT 3.8.7 in development
mode and SQlite. I downloaded RTFM 2.4.2 and attempted to install. Make
initdb failed, as it could not find the appropriate schema file. I took a
peek in etc and it appears that there are schema files for mysql, postgres,
oracle, but none for SQLite. I tried using the postgres schema and acl
files by copying to schema.SQLite and acl.SQLite. Make initdb succeeded
with no errors.

Creating a class in the UI finished with ‘object created’, but generates a
bunch of log errors, and although a record ends up in the FM_Classes table,
it must not be complete, as the class does not show up in the UI.

In short, it looks like using the postgres acl and schema files didn’t work.
Has anyone else gotten this combination to work?

Peter

Kevin_Falcone · March 3, 2010, 3:12pm

I’m currently running a development environment with RT 3.8.7 in development mode and SQlite.
I downloaded RTFM 2.4.2 and attempted to install. Make initdb failed, as it could not find
the appropriate schema file. I took a peek in etc and it appears that there are schema files
for mysql, postgres, oracle, but none for SQLite. I tried using the postgres schema and acl
files by copying to schema.SQLite and acl.SQLite. Make initdb succeeded with no errors.

I’ve never run RTFM with SQLite and likely it would require more than
just copying the schema files.

Creating a class in the UI finished with `object created’, but generates a bunch of log
errors, and although a record ends up in the FM_Classes table, it must not be complete, as the
class does not show up in the UI.

You don’t list the errors, which makes it impossible to offer any
suggestions.

In short, it looks like using the postgres acl and schema files didn’t work. Has anyone else
gotten this combination to work?

-kevin

Peter_Roosakos · March 3, 2010, 8:07pm

The specific error message upon attempting make initdb after successful make
install is:

Couldn’t finish ‘schema’ step.

ERROR: Couldn’t find schema file(s) ‘*’

…returned with error: 65280

make: *** [initdb] Error 255

The specific error messages generated when trying to create a class AFTER
installing RTFM by using acl.Pg and schema.Pg to install on SQLite are: