[Building Sakai] CLOG for 2.8
Omer Piperdi
omer at rice.edu
Thu Jul 21 10:15:05 PDT 2011
Yes.. I also have blogger installed for our legacy sites.. which is also
using post_pk as a constraint.. I am changing constraint to clog_post_pk
and see if that fix the problem...
Thanks
Omer
On 7/21/2011 10:50 AM, Omer Piperdi wrote:
> I am getting something like this in catalina.out..
>
> 2011-07-21 10:40:47,780 INFO main
> org.sakaiproject.clog.impl.ClogManagerImpl - Registering Clog functions ...
> 2011-07-21 10:40:47,780 INFO main
> org.sakaiproject.clog.impl.ClogManagerImpl - Registered Clog functions ...
> 2011-07-21 10:40:48,544 ERROR main
> org.sakaiproject.clog.impl.PersistenceManager - Caught exception whilst
> setting up tables. Message: ORA-02264: name already used by an existing
> constraint
> . Rolling back ...
> 2011-07-21 10:40:48,545 ERROR main
> org.sakaiproject.clog.impl.PersistenceManager - Failed to setup the tables
>
>
> Thanks
> Omer
>
> On 7/21/2011 8:38 AM, Adrian Fish wrote:
>> Hi Omer,
>>
>> Could you send me your catalina.out? If you shut down tomcat, delete the
>> file then start tomcat, the full horror should be apparent in the log :)
>>
>> It may well be bad ORACLE syntax; I mainly test on MYSQL.
>>
>> Cheers,
>>
>> Adrian.
>>
>> On 21/07/2011 04:02, Steve Swinsburg wrote:
>>> Hi Omer,
>>>
>>> I mean on startup. When Sakai starts, if auto.ddl is activated it will attempt to create the tables and give you an error if it can't.
>>>
>>> The error below is because it couldn't. Perhaps the SQL is incorrect in which case it would be a bug.
>>>
>>> cheers,
>>> Steve
>>>
>>>
>>>
>>> On 21/07/2011, at 12:30 PM, Omer A Piperdi wrote:
>>>
>>>> Tool installed just fine.. When I 'Create new post'.. I get
>>>>
>>>> INFO: EntityEncodingManager: No entities to format (json) and output for ref (/clog-post)
>>>> 2011-07-20 11:44:59,461 ERROR http-8443-Processor14 org.sakaiproject.clog.tool.entityprovider.ClogPostEntityProvider - Caught exception whilst getting posts.java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
>>>>
>>>> at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)
>>>> at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
>>>> at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837)
>>>> at oracle.jdbc.driv
>>>>
>>>> I don't see any table starting with 'CLOG' in database.. I am on Oracle 10.2.4 by the way..
>>>>
>>>> Thanks
>>>> Omer
>>>>
>>>>
>>>>
>>>> On 7/20/2011 5:51 PM, Steve Swinsburg wrote:
>>>>> Hi Omer,
>>>>>
>>>>> What to the logs say?
>>>>>
>>>>> Cheers,
>>>>> Steve
>>>>>
>>>>>
>>>>> Sent from my iPad
>>>>>
>>>>> On 21/07/2011, at 3:10, Omer Piperdi<omer at rice.edu> wrote:
>>>>>
>>>>>> Hi,
>>>>>>
>>>>>> I have deployed the CLOG trunk
>>>>>> https://source.sakaiproject.org/contrib/clog/trunk/
>>>>>> with our 2.8 install..
>>>>>>
>>>>>> Even though I have auto.ddl=true in sakai.properties.. I don't see any CLOG tables created in the database.. Did I miss any setting or I need to run something sql manually?
>>>>>>
>>>>>>
>>>>>> Thanks
>>>>>> Omer
>>>>>>
>>>>>> On 7/18/2011 7:11 PM, Steve Swinsburg wrote:
>>>>>>> And if you want to manage your own binary deployer pom (like we do for additional tools), you can use a profile that is always active.
>>>>>>>
>>>>>>> Then you can just add and remove blocks for each tool you want to drop in:
>>>>>>> https://source.sakaiproject.org/svn//msub/anu.edu.au/alliance/2.8.x/extra-deploy/binary-overlays/pom.xml
>>>>>>>
>>>>>>> cheers,
>>>>>>> Steve
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> On 19/07/2011, at 12:48 AM, Anthony Whyte wrote:
>>>>>>>
>>>>>>>> Modify the core-deploy pom.xml as follows:
>>>>>>>>
>>>>>>>> 1. choose<profile> <id> = full
>>>>>>>>
>>>>>>>> 2. Add a clean.target
>>>>>>>>
>>>>>>>> <properties>
>>>>>>>> <clean.targets>
>>>>>>>> components/accountvalidator-pack;
>>>>>>>> . . .
>>>>>>>> components/clog-pack;
>>>>>>>> . . .
>>>>>>>> components/sitestats-component
>>>>>>>> </clean.targets>
>>>>>>>> <deploy.target>tomcat-overlay</deploy.target>
>>>>>>>> </properties>
>>>>>>>>
>>>>>>>> 3. Add to<dependencies>
>>>>>>>>
>>>>>>>> <dependency>
>>>>>>>> <groupId>org.sakaiproject.clog</groupId>
>>>>>>>> <artifactId>clog-assembly</artifactId>
>>>>>>>> <version>0.9.1-SNAPSHOT</version>
>>>>>>>> <classifier>tomcat-overlay</classifier>
>>>>>>>> <type>zip</type>
>>>>>>>> </dependency>
>>>>>>>>
>>>>>>>> Note: the above provides Clog trunk binaries, currently snapshot (e.g., unstable by definition) for your build. The Clog trunk version is itself dependent on snapshot artifacts, including kernel-1.3.0-SNAPSHOT.
>>>>>>>>
>>>>>>>> Cheers,
>>>>>>>>
>>>>>>>> Anth
>>>>>>>>
>>>>>>>>
>>>>>>>> On Jul 18, 2011, at 10:24 AM, Jez Cope wrote:
>>>>>>>>
>>>>>>>>> Aha, Clog binary sounds useful - I use quilt to maintain local
>>>>>>>>> modifications against the codebase and it would be great to fold in clog
>>>>>>>>> as just another patch to the pom.
>>>>>>>>>
>>>>>>>>> I'm not very familiar with Maven - what's the correct syntax to add clog
>>>>>>>>> to the core-deploy project?
>>>>>>>>>
>>>>>>>>> Thanks,
>>>>>>>>> Jez
>>>>>>>>>
>>>>>>>>> Steve Swinsburg wrote:
>>>>>>>>>> Hi Omer,
>>>>>>>>>>
>>>>>>>>>> Use trunk for now. We've recently committed a number of fixes to trunk because 0.9 was unusable for us. That said there should be another tag coming soon. Also, clog is available as a binary so you can just add a pom block to the core-deploy project.
>>>>>>>>>>
>>>>>>>>>> Cheers
>>>>>>>>>> Steve
>>>>>>>>>>
>>>>>>>>>> Sent from my iPhone
>>>>>>>>>>
>>>>>>>>>> On 15/07/2011, at 2:49, Omer Piperdi<omer at rice.edu> wrote:
>>>>>>>>>>
>>>>>>>>>>> I am wondering if I should use 0.9 tag or trunk for CLOG with our Sakai 2.8.
>>>>>>>>>>>
>>>>>>>>>>> Thanks for any suggestion.
>>>>>>>>>>>
>>>>>>>>>>> Omer
>>>>>>>>>>> _______________________________________________
>>>>>>>>>>> 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"
>>>>>>>>>> _______________________________________________
>>>>>>>>>> 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"
>>>>>>>>>>
>>>>>>>>> _______________________________________________
>>>>>>>>> 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"
>>>>>>>>>
>>>>>>>>>
>>>>>>>> _______________________________________________
>>>>>>>> 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"
>>>>>>> _______________________________________________
>>>>>>> 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"
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>
>>>>>
>>>>>
>>> _______________________________________________
>>> 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"
>>>
>>
> _______________________________________________
> 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"
>
> !DSPAM:2294,4e284ad2144542118328152!
>
>
More information about the sakai-dev
mailing list