[Building Sakai] Error during tomcat startup

[Matthew Jones]

Since it's failing on initIndexes I'm guessing you don't have
permission on the database to create indexes.

grant create index to user_lacking_privilege;

I'm not sure offhand all of the grant's sakai needs minimally.

On Tue, Mar 10, 2009 at 12:29 AM, Karen Tsao <ktsao at stanford.edu> wrote:
> Hi,
>
> Can someone please help me with my tomcat startup error? This is a trunk
> instance. I run it against a blank Oracle db (with aauto.ddl=true in
> sakai.properties). Following is the error:
>
> Caused by: java.sql.SQLException: ORA-01031: insufficient privileges
>        at oracle.jdbc.driver.
> DatabaseError.throwSqlException(DatabaseError.java:112)
>        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
>        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
>        at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
>        at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)
>        at
> oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:957)
>        at
> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1170)
>        at
> oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1623)
>        at
> oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1588)
>        at
> oracle.jdbc.OracleDatabaseMetaData.getIndexInfo(OracleDatabaseMetaData.java:3486)
>        at
> org.hibernate.tool.hbm2ddl.TableMetadata.initIndexes(TableMetadata.java:130)
>        at
> org.hibernate.tool.hbm2ddl.TableMetadata.<init>(TableMetadata.java:35)
>        at
> org.hibernate.tool.hbm2ddl.DatabaseMetadata.getTableMetadata(DatabaseMetadata.java:90)
>        ... 58 more
>
> Does anyone know what privileges the error refers to? I have done some DDL
> and DML statements directly to that schema and they work fine though.
>
> I'd appreciate any suggestions. Thanks.
> Karen
>
>
>
> _______________________________________________
> sakai-dev mailing list
> sakai-dev at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>
> TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe at collab.sakaiproject.org
> with a subject of "unsubscribe"
>