Install wizard/MySQL: Error in database synchronization: java.lang.NullPointerException

[Michel van der Kleij]

Dear All,

I'm trying to link Portofino 4 to an existing MySQL 5.5 database (created with MySQL Workbench 6.3) but I'm hitting the error in $subject ... Perhapsl I need to install the MySQL JDBC driver, or Portofino comes with its own? I'm new to Portofino and Java so help would be much appreciated. Thanks!!!

catalina.out contains:

2015-06-23 22:48:46,474 INFO  c.m.portofino.sync.DatabaseSyncer        Processing schema: XXXX
2015-06-23 22:48:46,616 INFO  c.m.portofino.sync.DatabaseSyncer        Synchronizing schema: XXXX
2015-06-23 22:48:46,616 INFO  c.m.portofino.sync.DatabaseSyncer        Synchronizing tables
2015-06-23 22:48:46,618 ERROR c.m.p.a.a.appwizard.ApplicationWizard    null
java.lang.NullPointerException: null
    at com.manydesigns.portofino.sync.DatabaseSyncer.syncColumns(DatabaseSyncer.java:522) ~[portofino-database-4.1.3.jar:4.1.3]
    at com.manydesigns.portofino.sync.DatabaseSyncer.syncTables(DatabaseSyncer.java:429) ~[portofino-database-4.1.3.jar:4.1.3]
    at com.manydesigns.portofino.sync.DatabaseSyncer.syncSchema(DatabaseSyncer.java:139) ~[portofino-database-4.1.3.jar:4.1.3]
    at com.manydesigns.portofino.sync.DatabaseSyncer.syncDatabase(DatabaseSyncer.java:125) ~[portofino-database-4.1.3.jar:4.1.3]
    at com.manydesigns.portofino.actions.admin.appwizard.ApplicationWizard.configureModelSchemas(ApplicationWizard.java:437) [portofino-admin-4.1.3.jar:4.1.3]
    at com.manydesigns.portofino.actions.admin.appwizard.ApplicationWizard.selectSchemas(ApplicationWizard.java:374) [portofino-admin-4.1.3.jar:4.1.3]
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.7.0_79]
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) ~[na:1.7.0_79]
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.7.0_79]
    at java.lang.reflect.Method.invoke(Method.java:606) ~[na:1.7.0_79]
    at net.sourceforge.stripes.controller.DispatcherHelper$6.intercept(DispatcherHelper.java:456) [stripes-1.5.8.jar:1.5.8]
    at net.sourceforge.stripes.controller.ExecutionContext.proceed(ExecutionContext.java:158) [stripes-1.5.8.jar:1.5.8]
    at com.manydesigns.portofino.interceptors.GuardsInterceptor.intercept(GuardsInterceptor.java:61) [portofino-base-4.1.3.jar:4.1.3]
    at net.sourceforge.stripes.controller.ExecutionContext.proceed(ExecutionContext.java:155) [stripes-1.5.8.jar:1.5.8]
    at net.sourceforge.stripes.controller.BeforeAfterMethodInterceptor.intercept(BeforeAfterMethodInterceptor.java:113) [stripes-1.5.8.jar:1.5.8]
    at net.sourceforge.stripes.controller.ExecutionContext.proceed(ExecutionContext.java:155) [stripes-1.5.8.jar:1.5.8]
    at net.sourceforge.stripes.controller.ExecutionContext.wrap(ExecutionContext.java:74) [stripes-1.5.8.jar:1.5.8]
    at net.sourceforge.stripes.controller.DispatcherHelper.invokeEventHandler(DispatcherHelper.java:454) [stripes-1.5.8.jar:1.5.8]
    at net.sourceforge.stripes.controller.DispatcherServlet.invokeEventHandler(DispatcherServlet.java:278) [stripes-1.5.8.jar:1.5.8]
    at net.sourceforge.stripes.controller.DispatcherServlet.service(DispatcherServlet.java:160) [stripes-1.5.8.jar:1.5.8]
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:731) [servlet-api.jar:na]
    at net.sourceforge.stripes.controller.DynamicMappingFilter$2.doFilter(DynamicMappingFilter.java:453) [stripes-1.5.8.jar:1.5.8]
    at net.sourceforge.stripes.controller.StripesFilter.doFilter(StripesFilter.java:260) [stripes-1.5.8.jar:1.5.8]
    at net.sourceforge.stripes.controller.DynamicMappingFilter.doFilter(DynamicMappingFilter.java:440) [stripes-1.5.8.jar:1.5.8]
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) [catalina.jar:7.0.62]
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) [catalina.jar:7.0.62]
    at com.manydesigns.portofino.servlets.I18nFilter.doFilter(I18nFilter.java:60) [portofino-base-4.1.3.jar:4.1.3]
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) [catalina.jar:7.0.62]
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) [catalina.jar:7.0.62]
    at net.sourceforge.stripes.controller.StripesFilter.doFilter(StripesFilter.java:260) [stripes-1.5.8.jar:1.5.8]
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) [catalina.jar:7.0.62]
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) [catalina.jar:7.0.62]
    at com.manydesigns.portofino.servlets.CleanupFilter.doFilter(CleanupFilter.java:47) [portofino-database-4.1.3.jar:4.1.3]
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) [catalina.jar:7.0.62]
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) [catalina.jar:7.0.62]
    at com.manydesigns.portofino.servlets.DispatcherFilter.doFilter(DispatcherFilter.java:61) [portofino-pageactions-4.1.3.jar:4.1.3]
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) [catalina.jar:7.0.62]
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) [catalina.jar:7.0.62]
    at org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:449) [shiro-web-1.2.3.jar:1.2.3]
    at org.apache.shiro.web.servlet.AbstractShiroFilter$1.call(AbstractShiroFilter.java:365) [shiro-web-1.2.3.jar:1.2.3]
    at org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90) [shiro-core-1.2.3.jar:1.2.3]
    at org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83) [shiro-core-1.2.3.jar:1.2.3]
    at org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:383) [shiro-core-1.2.3.jar:1.2.3]
    at org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362) [shiro-web-1.2.3.jar:1.2.3]
    at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125) [shiro-web-1.2.3.jar:1.2.3]
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) [catalina.jar:7.0.62]
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) [catalina.jar:7.0.62]
    at com.manydesigns.elements.servlet.ElementsFilter.doHttpFilter(ElementsFilter.java:132) [elements-4.1.3.jar:4.1.3]
    at com.manydesigns.elements.servlet.ElementsFilter.doFilter(ElementsFilter.java:83) [elements-4.1.3.jar:4.1.3]
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) [catalina.jar:7.0.62]
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) [catalina.jar:7.0.62]
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220) [catalina.jar:7.0.62]
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122) [catalina.jar:7.0.62]
    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505) [catalina.jar:7.0.62]
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170) [catalina.jar:7.0.62]
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) [catalina.jar:7.0.62]
    at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:957) [catalina.jar:7.0.62]
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) [catalina.jar:7.0.62]
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:423) [catalina.jar:7.0.62]
    at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1079) [tomcat-coyote.jar:7.0.62]
    at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:620) [tomcat-coyote.jar:7.0.62]
    at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:318) [tomcat-coyote.jar:7.0.62]
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [na:1.7.0_79]
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [na:1.7.0_79]
    at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-coyote.jar:7.0.62]
    at java.lang.Thread.run(Thread.java:745) [na:1.7.0_79]

[Angelo Lupo]

Hi Micheal,

copy  MySQL JDBC driver in to tomcat\lib, restart Tomcat and try again.

Best regards

Angelo

--
You received this message because you are subscribed to the Google Groups "manydesigns-portofino" group.
To unsubscribe from this group and stop receiving emails from it, send an email to manydesigns-port...@googlegroups.com.
To post to this group, send email to manydesign...@googlegroups.com.
Visit this group at http://groups.google.com/group/manydesigns-portofino.
For more options, visit https://groups.google.com/d/optout.

[Michel van der Kleij]

Thanks Angelo, but in that lib directory, there seems to be a MySQL Java connector already ...

I should add maybe that it connects to the database OK, it finds the right schemas etc. but the error occurs when I want to import it. I'm running the startup.sh script in the bin directory from sudo.

portofino-4.1.3/apache-tomcat-7.0.62/lib$ ls
annotations-api.jar  ecj-4.4.2.jar  jtds-1.2.8.jar                   tomcat-api.jar      tomcat-i18n-ja.jar
catalina-ant.jar     el-api.jar     mysql-connector-java-5.1.32.jar  tomcat-coyote.jar   tomcat-jdbc.jar
catalina-ha.jar      jasper-el.jar  postgresql-9.3-1102-jdbc4.jar    tomcat-dbcp.jar     tomcat-util.jar
catalina.jar         jasper.jar     servlet-api.jar                  tomcat-i18n-es.jar  websocket-api.jar
catalina-tribes.jar  jsp-api.jar    tomcat7-websocket.jar            tomcat-i18n-fr.jar


Op woensdag 24 juni 2015 08:47:46 UTC+2 schreef Angelo:

To unsubscribe from this group and stop receiving emails from it, send an email to manydesigns-portofino+unsub...@googlegroups.com.

[Alessio Stalla]

Do you have columns of type ENUM or SET? Liquibase doesn't detect the JDBC type for those on MySQL.

To unsubscribe from this group and stop receiving emails from it, send an email to manydesigns-port...@googlegroups.com.

To post to this group, send email to manydesign...@googlegroups.com.
Visit this group at http://groups.google.com/group/manydesigns-portofino.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "manydesigns-portofino" group.

To unsubscribe from this group and stop receiving emails from it, send an email to manydesigns-port...@googlegroups.com.

[Michel van der Kleij]

Yes we do! I'm going to check that tonight and report back. Mille grazie!

Op donderdag 25 juni 2015 11:21:43 UTC+2 schreef Alessio Stalla:

To unsubscribe from this group and stop receiving emails from it, send an email to manydesigns-portofino+unsub...@googlegroups.com.

To post to this group, send email to manydesign...@googlegroups.com.
Visit this group at http://groups.google.com/group/manydesigns-portofino.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "manydesigns-portofino" group.

To unsubscribe from this group and stop receiving emails from it, send an email to manydesigns-portofino+unsub...@googlegroups.com.

[Alessio Stalla]

Filed: https://tt.manydesigns.com/projects/PRT/tickets/PRT/1703

You can also try Portofino 4.1.1 which had an older version of Liquibase.

To unsubscribe from this group and stop receiving emails from it, send an email to manydesigns-port...@googlegroups.com.

To post to this group, send email to manydesign...@googlegroups.com.
Visit this group at http://groups.google.com/group/manydesigns-portofino.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "manydesigns-portofino" group.

To unsubscribe from this group and stop receiving emails from it, send an email to manydesigns-port...@googlegroups.com.

To post to this group, send email to manydesign...@googlegroups.com.
Visit this group at http://groups.google.com/group/manydesigns-portofino.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "manydesigns-portofino" group.

To unsubscribe from this group and stop receiving emails from it, send an email to manydesigns-port...@googlegroups.com.

[Michel van der Kleij]

Almost there! We can live without the ENUMs, it's early enough in the project to choose another method as there was only 1 table that used it.

However, in step 5 of the wizard I'm now getting:

Could not save model: MappingException: Duplicate property mapping of _positioning_id found in positioning

The table "positioning", like many of the other tables, has a column simply called "id" for primary key. None of the other tables use the name "positioning" anywhere, so I'm a bit puzzled where this duplication might come from.


Op donderdag 25 juni 2015 17:41:40 UTC+2 schreef Alessio Stalla:

To unsubscribe from this group and stop receiving emails from it, send an email to manydesigns-portofino+unsub...@googlegroups.com.

To post to this group, send email to manydesign...@googlegroups.com.
Visit this group at http://groups.google.com/group/manydesigns-portofino.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "manydesigns-portofino" group.

To unsubscribe from this group and stop receiving emails from it, send an email to manydesigns-portofino+unsub...@googlegroups.com.

To post to this group, send email to manydesign...@googlegroups.com.
Visit this group at http://groups.google.com/group/manydesigns-portofino.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "manydesigns-portofino" group.

To unsubscribe from this group and stop receiving emails from it, send an email to manydesigns-portofino+unsub...@googlegroups.com.

[Alessio Stalla]

Hmm, this sounds like a bug. Even in rare cases where you would get properties with the same name (say, columns "foo" and "FOO" on the same table) Portofino renames them to avoid clashes. Perhaps the id is also a foreign key, or part of a composite key? Or is there any "strange" configuration? Could you send us a possibly anonymized subset of your db schema that has the problem?

To unsubscribe from this group and stop receiving emails from it, send an email to manydesigns-port...@googlegroups.com.

To post to this group, send email to manydesign...@googlegroups.com.
Visit this group at http://groups.google.com/group/manydesigns-portofino.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "manydesigns-portofino" group.

To unsubscribe from this group and stop receiving emails from it, send an email to manydesigns-port...@googlegroups.com.

To post to this group, send email to manydesign...@googlegroups.com.
Visit this group at http://groups.google.com/group/manydesigns-portofino.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "manydesigns-portofino" group.

To unsubscribe from this group and stop receiving emails from it, send an email to manydesigns-port...@googlegroups.com.

To post to this group, send email to manydesign...@googlegroups.com.
Visit this group at http://groups.google.com/group/manydesigns-portofino.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "manydesigns-portofino" group.

To unsubscribe from this group and stop receiving emails from it, send an email to manydesigns-port...@googlegroups.com.

[Michel van der Kleij]

Hi Alessio,

OK, the first id clash solved: there were two references to the positioning table's id from another table. Logically that made sense since that object can be described by two different positions. After fixing that I ran the wizard again, only to run into the same hurdle. This time the table's id ("address") is referenced by a number of columns in other tables ("contact" and "company"). Again, logically that is the idea because both individuals and companies have an address. So it would appear that the wizard gets confused if a certain indexed column is referenced multiple time. If you give me your email address I can send you the (slightly altered) schema that MySQL Workbench generates. Mine is tuk...@gmail.com ...

Oh, if you prefer we can move this to another topic if you like since we're digressing from the original.

Best regards,

Mich.

Op vrijdag 26 juni 2015 09:28:52 UTC+2 schreef Alessio Stalla:

To unsubscribe from this group and stop receiving emails from it, send an email to manydesigns-portofino+unsub...@googlegroups.com.

To post to this group, send email to manydesign...@googlegroups.com.
Visit this group at http://groups.google.com/group/manydesigns-portofino.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "manydesigns-portofino" group.

To unsubscribe from this group and stop receiving emails from it, send an email to manydesigns-portofino+unsub...@googlegroups.com.

To post to this group, send email to manydesign...@googlegroups.com.
Visit this group at http://groups.google.com/group/manydesigns-portofino.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "manydesigns-portofino" group.

To unsubscribe from this group and stop receiving emails from it, send an email to manydesigns-portofino+unsub...@googlegroups.com.

To post to this group, send email to manydesign...@googlegroups.com.
Visit this group at http://groups.google.com/group/manydesigns-portofino.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "manydesigns-portofino" group.

To unsubscribe from this group and stop receiving emails from it, send an email to manydesigns-portofino+unsub...@googlegroups.com.

[Alessio Stalla]

Multiple references to the same id shouldn't pose a problem. Even if two properties have the same name, Portofino should rename one of them and warn about it. This isn't happening, so again I think you've hit a buggy corner case.

You can send your schema to alessio...@manydesigns.com

To unsubscribe from this group and stop receiving emails from it, send an email to manydesigns-port...@googlegroups.com.

To post to this group, send email to manydesign...@googlegroups.com.
Visit this group at http://groups.google.com/group/manydesigns-portofino.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "manydesigns-portofino" group.

To unsubscribe from this group and stop receiving emails from it, send an email to manydesigns-port...@googlegroups.com.

To post to this group, send email to manydesign...@googlegroups.com.
Visit this group at http://groups.google.com/group/manydesigns-portofino.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "manydesigns-portofino" group.

To unsubscribe from this group and stop receiving emails from it, send an email to manydesigns-port...@googlegroups.com.

To post to this group, send email to manydesign...@googlegroups.com.
Visit this group at http://groups.google.com/group/manydesigns-portofino.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "manydesigns-portofino" group.

To unsubscribe from this group and stop receiving emails from it, send an email to manydesigns-port...@googlegroups.com.

To post to this group, send email to manydesign...@googlegroups.com.
Visit this group at http://groups.google.com/group/manydesigns-portofino.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "manydesigns-portofino" group.

To unsubscribe from this group and stop receiving emails from it, send an email to manydesigns-port...@googlegroups.com.

[Michel van der Kleij]

OK Alessio, will do that tonight. Haven't got my laptop here ... Thx!

Op dinsdag 30 juni 2015 15:11:32 UTC+2 schreef Alessio Stalla:

To unsubscribe from this group and stop receiving emails from it, send an email to manydesigns-portofino+unsub...@googlegroups.com.

To post to this group, send email to manydesign...@googlegroups.com.
Visit this group at http://groups.google.com/group/manydesigns-portofino.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "manydesigns-portofino" group.

To unsubscribe from this group and stop receiving emails from it, send an email to manydesigns-portofino+unsub...@googlegroups.com.

To post to this group, send email to manydesign...@googlegroups.com.
Visit this group at http://groups.google.com/group/manydesigns-portofino.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "manydesigns-portofino" group.

To unsubscribe from this group and stop receiving emails from it, send an email to manydesigns-portofino+unsub...@googlegroups.com.

To post to this group, send email to manydesign...@googlegroups.com.
Visit this group at http://groups.google.com/group/manydesigns-portofino.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "manydesigns-portofino" group.

To unsubscribe from this group and stop receiving emails from it, send an email to manydesigns-portofino+unsub...@googlegroups.com.

To post to this group, send email to manydesign...@googlegroups.com.
Visit this group at http://groups.google.com/group/manydesigns-portofino.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "manydesigns-portofino" group.

To unsubscribe from this group and stop receiving emails from it, send an email to manydesigns-portofino+unsub...@googlegroups.com.

[Michel van der Kleij]

Should be in your mailbox Alessio. I had to guess your exact address because the link below didn't work. However, I didn't get any errors so hopefully it was OK.

Op dinsdag 30 juni 2015 15:13:44 UTC+2 schreef Michel van der Kleij:

[Alessio Stalla]

Thanks. The problem with your schema is that some foreign keys do not refer to the primary key; for example, company has a composite primary key of 3 columns but e.g. article only refers to the id column.

With Portofino 4.1.2 and the update of Hibernate to version 4, support for such a configuration was sketched, since Hibernate supports it; however, since it's a rare corner case, it wasn't tested much and it has thus a number of problems (e.g. it doesn't handle duplicate property names, as you saw).

You can expect it to work in the forthcoming Portofino 4.2. Issue reference is https://tt.manydesigns.com/projects/PRT/tickets/PRT/1706

In the meantime, unfortunately, your schema is not supported.

Thanks for the report!

Peace

Alessio

To unsubscribe from this group and stop receiving emails from it, send an email to manydesigns-port...@googlegroups.com.

To post to this group, send email to manydesign...@googlegroups.com.
Visit this group at http://groups.google.com/group/manydesigns-portofino.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "manydesigns-portofino" group.

To unsubscribe from this group and stop receiving emails from it, send an email to manydesigns-port...@googlegroups.com.

To post to this group, send email to manydesign...@googlegroups.com.
Visit this group at http://groups.google.com/group/manydesigns-portofino.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "manydesigns-portofino" group.

To unsubscribe from this group and stop receiving emails from it, send an email to manydesigns-port...@googlegroups.com.

To post to this group, send email to manydesign...@googlegroups.com.
Visit this group at http://groups.google.com/group/manydesigns-portofino.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "manydesigns-portofino" group.

To unsubscribe from this group and stop receiving emails from it, send an email to manydesigns-port...@googlegroups.com.

To post to this group, send email to manydesign...@googlegroups.com.
Visit this group at http://groups.google.com/group/manydesigns-portofino.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "manydesigns-portofino" group.

To unsubscribe from this group and stop receiving emails from it, send an email to manydesigns-port...@googlegroups.com.

To post to this group, send email to manydesign...@googlegroups.com.
Visit this group at http://groups.google.com/group/manydesigns-portofino.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "manydesigns-portofino" group.

To unsubscribe from this group and stop receiving emails from it, send an email to manydesigns-port...@googlegroups.com.

[Michel van der Kleij]

Hi Alessio!

Thx for your analysis. I think i will adjust the schema in a test copy and simplify things a bit so i can still take Portofino for a test drive. I'll let you know. Keep up the good work.

Mich.

-- 

Met vriendelijke groet / Kind regards,

M.J.L. van der Kleij, BSc. (Hons.), CISSP, CISA, CEH
Aklan Animal Rescue & Rehabilitation Center (AARRC) Inc.
Stichting Albert, Albert Foundation
Founder/director
http://albert.tukcedo.nl

Sponsor een Filippijns zwerfdier, ziehttp://adoption.tukcedo.nl
Sponsor a Philippine stray animal

Help Filippijnse zwerfdieren, ziehttp://albert.tukcedo.nl
The Albert Foundation

Help stray pets in the Philippines, seehttp://aarrc.tukcedo.nl
Aklan Animal Rescue and Rehabilitation Center

Twitter: @AklanRescue

Op 2 jul. 2015 11:20 schreef "Alessio Stalla" <alessi...@gmail.com>:

[Michel van der Kleij]

Hi Alessio,

I got in after removing all the combined PKs. The next problem is that I can't get into the system. I don't remember setting a password for "admin" anywhere. I tried removing and unzipping the distribution from scratch, but I still end up at the login screen when I select the wizard. How can I get around that?

Thanks!

Mich.

Op donderdag 2 juli 2015 12:36:46 UTC+2 schreef Michel van der Kleij:

To unsubscribe from this group and stop receiving emails from it, send an email to manydesigns-portofino+unsub...@googlegroups.com.

To post to this group, send email to manydesign...@googlegroups.com.
Visit this group at http://groups.google.com/group/manydesigns-portofino.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "manydesigns-portofino" group.

To unsubscribe from this group and stop receiving emails from it, send an email to manydesigns-portofino+unsub...@googlegroups.com.

To post to this group, send email to manydesign...@googlegroups.com.
Visit this group at http://groups.google.com/group/manydesigns-portofino.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "manydesigns-portofino" group.

To unsubscribe from this group and stop receiving emails from it, send an email to manydesigns-portofino+unsub...@googlegroups.com.

To post to this group, send email to manydesign...@googlegroups.com.
Visit this group at http://groups.google.com/group/manydesigns-portofino.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "manydesigns-portofino" group.

To unsubscribe from this group and stop receiving emails from it, send an email to manydesigns-portofino+unsub...@googlegroups.com.

To post to this group, send email to manydesign...@googlegroups.com.
Visit this group at http://groups.google.com/group/manydesigns-portofino.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "manydesigns-portofino" group.

To unsubscribe from this group and stop receiving emails from it, send an email to manydesigns-portofino+unsub...@googlegroups.com.

To post to this group, send email to manydesign...@googlegroups.com.
Visit this group at http://groups.google.com/group/manydesigns-portofino.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "manydesigns-portofino" group.

To unsubscribe from this group and stop receiving emails from it, send an email to manydesigns-portofino+unsub...@googlegroups.com.
To post to this group, send email to manydesigns-portofino@googlegroups.com.

Visit this group at http://groups.google.com/group/manydesigns-portofino.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "manydesigns-portofino" group.

To unsubscribe from this group and stop receiving emails from it, send an email to manydesigns-portofino+unsub...@googlegroups.com.
To post to this group, send email to manydesigns-portofino@googlegroups.com.

[Michel van der Kleij]

Forgot to mention that it's NOT admin/admin as it says in the documentation here http://portofino.manydesigns.com/en/download

Op zondag 5 juli 2015 00:14:02 UTC+2 schreef Michel van der Kleij:

[Michel van der Kleij]

OK, I figured out how it works. This isn't entirely obvious from the documentation, so I'll describe it here for anyone that's wondering the same:

- The INITIAL user/password when you first start up is admin/admin as described under "Installation" and this is regenerated as expected when you unzip the application from scratch
- AFTER the wizard finishes and has built the application, the user/password is as you have defined in your database and as specified in the wizard, so that's NOT necessarily "admin" as the wizard suggests. In fact the original admin/admin no longer works unless you specifically put it in your database

Ready for that test-drive now! ;-)

Mich.

Op zondag 5 juli 2015 22:21:51 UTC+2 schreef Michel van der Kleij:

[Michel van der Kleij]

But there's still something not quite right. Here's a short list of things that aren's as described in http://portofino.manydesigns.com/en/docs/reference/working-with-pages/structure-of-a-page
- I've added a user called "admin" to the group "Administrators". Yet, I don't see the "wrench" icon or any other way to update the page when I'm logged in as "admin".
- The sidebar doesn't show all the tables in the database and there's no way I can scroll them.
- The application name doesn't show in the header
- The user name ("admin", or any user in the Administrators group) does not show at the top of the side bar
What am I still doing wrong?

Op zondag 5 juli 2015 23:19:20 UTC+2 schreef Michel van der Kleij:

[Alessio Stalla]

On Mon, Jul 6, 2015 at 12:00 AM, Michel van der Kleij <aklanani...@gmail.com> wrote:

But there's still something not quite right. Here's a short list of things that aren's as described in http://portofino.manydesigns.com/en/docs/reference/working-with-pages/structure-of-a-page
- I've added a user called "admin" to the group "Administrators". Yet, I don't see the "wrench" icon or any other way to update the page when I'm logged in as "admin".

By default, the group is called "administrators" with a lowercase "a".

 

- The sidebar doesn't show all the tables in the database and there's no way I can scroll them.

The sidebar won't show all tables in the database unless you manually select them all at the end of the wizard. Otherwise, the wizard only generates pages for tables that are understood to be "top-level", i.e., that don't have foreign keys. Other tables are "children" of the top-level ones.

 

- The application name doesn't show in the header

The application name is Portofino 4, unless you change it in the admin section.

 

- The user name ("admin", or any user in the Administrators group) does not show at the top of the side bar

That means you didn't log in.

 

To unsubscribe from this group and stop receiving emails from it, send an email to manydesigns-port...@googlegroups.com.

To post to this group, send email to manydesign...@googlegroups.com.
Visit this group at http://groups.google.com/group/manydesigns-portofino.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "manydesigns-portofino" group.

To unsubscribe from this group and stop receiving emails from it, send an email to manydesigns-port...@googlegroups.com.

To post to this group, send email to manydesign...@googlegroups.com.
Visit this group at http://groups.google.com/group/manydesigns-portofino.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "manydesigns-portofino" group.

To unsubscribe from this group and stop receiving emails from it, send an email to manydesigns-port...@googlegroups.com.

To post to this group, send email to manydesign...@googlegroups.com.
Visit this group at http://groups.google.com/group/manydesigns-portofino.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "manydesigns-portofino" group.

To unsubscribe from this group and stop receiving emails from it, send an email to manydesigns-port...@googlegroups.com.

To post to this group, send email to manydesign...@googlegroups.com.
Visit this group at http://groups.google.com/group/manydesigns-portofino.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "manydesigns-portofino" group.

To unsubscribe from this group and stop receiving emails from it, send an email to manydesigns-port...@googlegroups.com.

To post to this group, send email to manydesign...@googlegroups.com.
Visit this group at http://groups.google.com/group/manydesigns-portofino.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "manydesigns-portofino" group.

To unsubscribe from this group and stop receiving emails from it, send an email to manydesigns-port...@googlegroups.com.

To post to this group, send email to manydesign...@googlegroups.com.
Visit this group at http://groups.google.com/group/manydesigns-portofino.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "manydesigns-portofino" group.

To unsubscribe from this group and stop receiving emails from it, send an email to manydesigns-port...@googlegroups.com.

To post to this group, send email to manydesign...@googlegroups.com.
Visit this group at http://groups.google.com/group/manydesigns-portofino.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "manydesigns-portofino" group.

To unsubscribe from this group and stop receiving emails from it, send an email to manydesigns-port...@googlegroups.com.