uPortal IRC Logs-2011-06-09

[12:09:38 CDT(-0500)] <b-rock> Greetings uPortal devs: I"m testing an install of the uportal4RC1 against a mysql db. I'm running into an issue with importing layouts for the intial users http://pastebin.com/vNqj4DMC. Curious to know if maybe this has been identified and maybe fixed in the trunk already?
[12:10:07 CDT(-0500)] <b-rock> looks like there are 2 tables that are not being auto generated.
[12:10:54 CDT(-0500)] <b-rock> UP_PORTLET_COOKIES and UP_SS_USER_PREF_LAY_ATTR_VAL
[12:11:17 CDT(-0500)] <b-rock> has someone here possible run into this?
[12:21:49 CDT(-0500)] <athena> i think there are known problem on mysql still, yes
[12:24:24 CDT(-0500)] <b-rock> ok. thanks athena. I'm gonna try to create the tables manually to see if the import will work.
[12:24:48 CDT(-0500)] <athena> not sure if all the import/export has been finished or not
[12:25:03 CDT(-0500)] <athena> know EricDalquist has done work on that lately though
[12:27:37 CDT(-0500)] <b-rock> ok. good to know. I did make a bunch of table names upper case and in one java file for some of the imp0ort errors. It does say here https://wiki.jasig.org/display/UPM32/MySQL you can force table names to lower case, but thats not a configuration I'm able to make without bugging the dba.
[12:28:29 CDT(-0500)] <b-rock> do you think I should submit those changes as a patch?
[12:30:53 CDT(-0500)] <EricDalquist> so uPortal requires SQL compliance
[12:31:05 CDT(-0500)] <EricDalquist> which means case insensitive table names are required if that is the issue
[12:31:23 CDT(-0500)] <EricDalquist> but I believe there is another issue during db creation on mysql as well
[12:33:39 CDT(-0500)] <b-rock> Hi EricDalquist. Im testing on mysql 5.5 and there are two tables not being generated UP_PORTLET_COOKIES and UP_SS_USER_PREF_LAY_ATTR_VAL
[12:33:47 CDT(-0500)] <b-rock> during the initdb.
[12:33:54 CDT(-0500)] <EricDalquist> do you have the error messages from those tables?
[12:34:07 CDT(-0500)] <b-rock> http://pastebin.com/vNqj4DMC
[12:34:38 CDT(-0500)] <EricDalquist> that is in the import
[12:34:39 CDT(-0500)] <b-rock> it mostly just says that the operation could not complete because the table doesn't exist.
[12:34:52 CDT(-0500)] <EricDalquist> do you have the errors from the area of the log where it is creating the tables but fails?
[12:35:02 CDT(-0500)] <EricDalquist> should be higher up in the initdb log
[12:35:13 CDT(-0500)] <b-rock> no I don't get any errors during that part of the initdb running
[12:35:23 CDT(-0500)] <b-rock> I can double check though...
[12:35:26 CDT(-0500)] <EricDalquist> look at the file
[12:35:32 CDT(-0500)] <EricDalquist> I bet there are errors but the build isn't failing
[12:36:29 CDT(-0500)] <b-rock> ok. I'm re-running it piped to a file. I'll scann it when it completes.
[12:59:14 CDT(-0500)] <b-rock> ok. EricDalquist I found the error http://pastebin.com/gJvu50jA looks like it affects the create/alter scripts for 4 tables total
[12:59:54 CDT(-0500)] <b-rock> is that something I can specify in the java file?
[13:00:09 CDT(-0500)] <EricDalquist> hrm
[13:01:16 CDT(-0500)] <b-rock> I do see this @MapKeyColumn(name="NAME", nullable=false, length = 500) for the Name field in the UP_SS_USER_PREF_LAY_ATTR_VAL declaration of LayoutNodeAttributesImpl.java
[13:02:24 CDT(-0500)] <EricDalquist> I don't know why hibernate is creating those columns as longtext
[13:02:38 CDT(-0500)] <EricDalquist> I'd assume they would use varchar
[13:02:46 CDT(-0500)] <EricDalquist> since they length is easily within varchar range
[13:03:01 CDT(-0500)] <b-rock> yeah 500 is not that big
[13:05:41 CDT(-0500)] <EricDalquist> well for now can you create a jira issue with that 2nd pastebin in it?
[13:05:56 CDT(-0500)] <EricDalquist> I'll try to get back to the hibernate db issues as soon as I can
[13:57:41 CDT(-0500)] <b-rock> ok EricDalquist. I submitted this as an issue https://issues.jasig.org/browse/UP-3054. Should I just create these tables manually for now and just run "crn-import" to complete the db initialization?
[13:57:53 CDT(-0500)] <EricDalquist> you can give that a try