[jboss-user] [JBoss Portal] - Re: PortletPreferences in MySql

2008-02-28 Thread PeterJ 
I dumped my mysql variables and these are the differences that I noted:

1) I am using utf8 for my character sets:

| character_set_client| utf8
| character_set_connection| utf8
| character_set_database  | utf8
| character_set_filesystem| binary
| character_set_results   | utf8
| character_set_server| utf8
| character_set_system| utf8
| collation_connection| utf8_general_ci
| collation_database  | utf8_general_ci
| collation_server| utf8_general_ci

This might have an effect on the sorting algorithm, and could be the cause of 
the problem you are seeing.

2) Various buffer sizes are different, but this probably just reflects 
differences in memory sizes.

3) You changed the port to 3307

4) Your sql-mode is set to nothing, while mine is:

| sql_mode| 
STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

Not sure if this could cause the problem.


View the original post : 
http://www.jboss.com/index.html?module=bbop=viewtopicp=4132948#4132948

Reply to the post : 
http://www.jboss.com/index.html?module=bbop=postingmode=replyp=4132948
___
jboss-user mailing list
jboss-user@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-user

[jboss-user] [JBoss Portal] - Re: PortletPreferences in MySql

2008-02-28 Thread cassitos 
Hi. I finaly 'resolved' the problem installing the server again, removed all 
files and installing from zero.
Now it's working fine. May be a made some modification in some file (what I 
don't remember when).
Tks

View the original post : 
http://www.jboss.com/index.html?module=bbop=viewtopicp=4133050#4133050

Reply to the post : 
http://www.jboss.com/index.html?module=bbop=postingmode=replyp=4133050
___
jboss-user mailing list
jboss-user@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-user

[jboss-user] [JBoss Portal] - Re: PortletPreferences in MySql

2008-02-27 Thread PeterJ 
Our portal uses MySQL and the preferences are stored and retrieved without any 
problems. I suspect a database configuration issue. Please run the myssql 
utility, enter the following command, and post the results:

show variables;

(you will want to widen your console window to prevent line wrapping, 110 
characters should be sufficient) 


View the original post : 
http://www.jboss.com/index.html?module=bbop=viewtopicp=4132557#4132557

Reply to the post : 
http://www.jboss.com/index.html?module=bbop=postingmode=replyp=4132557
___
jboss-user mailing list
jboss-user@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-user

[jboss-user] [JBoss Portal] - Re: PortletPreferences in MySql

2008-02-27 Thread cassitos 
Hi,
here is the result:
auto_increment_increment: 1
  | auto_increment_offset: 1
  | automatic_sp_privileges: ON
  | back_log: 50
  | basedir: C :\Arquivos de programas\MySQL\MySQL Server 5.0\
  | binlog_cache_size: 32768
  | bulk_insert_buffer_size: 8388608
  | character_set_client: latin1
  | character_set_connection: latin1
  | character_set_database: latin1
  | character_set_filesystem: binary
  | character_set_results: latin1
  | character_set_server: latin1
  | character_set_system: utf8
  | character_sets_dir: C :\Arquivos de programas\MySQL\MySQL Server 
5.0\share\charsets\
  | collation_connection: latin1_swedish_ci
  | collation_database: latin1_swedish_ci
  | collation_server: latin1_swedish_ci
  | completion_type: 0
  | concurrent_insert: 1
  | connect_timeout: 5
  | datadir: C :\Arquivos de programas\MySQL\MySQL Server 5.0\Data\
  | date_format: %Y-%m-%d
  | datetime_format: %Y-%m-%d %H :%i :%s
  | default_week_format: 0
  | delay_key_write: ON
  | delayed_insert_limit: 100
  | delayed_insert_timeout: 300
  | delayed_queue_size: 1000
  | div_precision_increment: 4
  | engine_condition_pushdown: OFF
  | expire_logs_days: 0
  | flush: OFF
  | flush_time: 1800
  | ft_boolean_syntax: + -()~* :|
  | ft_max_word_len: 84
  | ft_min_word_len: 4
  | ft_query_expansion_limit: 20
  | ft_stopword_file: (built-in)
  | group_concat_max_len: 1024
  | have_archive: YES
  | have_bdb: NO
  | have_blackhole_engine: YES
  | have_compress: YES
  | have_crypt: NO
  | have_csv: NO
  | have_dynamic_loading: YES
  | have_example_engine: NO
  | have_federated_engine: YES
  | have_geometry: YES
  | have_innodb: YES
  | have_isam: NO
  | have_merge_engine: YES
  | have_ndbcluster: NO
  | have_openssl: DISABLED
  | have_ssl: DISABLED
  | have_query_cache: YES
  | have_raid: NO
  | have_rtree_keys: YES
  | have_symlink: YES
  | hostname: hsawork
  | init_connect: 
  | init_file: 
  | init_slave: 
  | innodb_additional_mem_pool_size: 2097152
  | innodb_autoextend_increment: 8
  | innodb_buffer_pool_awe_mem_mb: 0
  | innodb_buffer_pool_size: 33554432
  | innodb_checksums: ON
  | innodb_commit_concurrency: 0
  | innodb_concurrency_tickets: 500
  | innodb_data_file_path: ibdata1 :10M :autoextend
  | innodb_data_home_dir: 
  | innodb_doublewrite: ON
  | innodb_fast_shutdown: 1
  | innodb_file_io_threads: 4
  | innodb_file_per_table: OFF
  | innodb_flush_log_at_trx_commit: 1
  | innodb_flush_method: 
  | innodb_force_recovery: 0
  | innodb_lock_wait_timeout: 50
  | innodb_locks_unsafe_for_binlog: OFF
  | innodb_log_arch_dir: 
  | innodb_log_archive: OFF
  | innodb_log_buffer_size: 1048576
  | innodb_log_file_size: 10485760
  | innodb_log_files_in_group: 2
  | innodb_log_group_home_dir: .\
  | innodb_max_dirty_pages_pct: 90
  | innodb_max_purge_lag: 0
  | innodb_mirrored_log_groups: 1
  | innodb_open_files: 300
  | innodb_rollback_on_timeout: OFF
  | innodb_support_xa: ON
  | innodb_sync_spin_loops: 20
  | innodb_table_locks: ON
  | innodb_thread_concurrency: 8
  | innodb_thread_sleep_delay: 1
  | interactive_timeout: 28800
  | join_buffer_size: 131072
  | key_buffer_size: 18874368
  | key_cache_age_threshold: 300
  | key_cache_block_size: 1024
  | key_cache_division_limit: 100
  | language: C :\Arquivos de programas\MySQL\MySQL Server 5.0\share\english\
  | large_files_support: ON
  | large_page_size: 0
  | large_pages: OFF
  | lc_time_names: en_US
  | license: GPL
  | local_infile: ON
  | log: OFF
  | log_bin: OFF
  | log_bin_trust_function_creators: OFF
  | log_error: C :\Arquivos de programas\MySQL\MySQL Server 5.0\Data\hsawork.err
  | log_queries_not_using_indexes: OFF
  | log_slave_updates: OFF
  | log_slow_queries: OFF
  | log_warnings: 1
  | long_query_time: 10
  | low_priority_updates: OFF
  | lower_case_file_system: ON
  | lower_case_table_names: 1
  | max_allowed_packet: 1048576
  | max_binlog_cache_size: 4294967295
  | max_binlog_size: 1073741824
  | max_connect_errors: 10
  | max_connections: 100
  | max_delayed_threads: 20
  | max_error_count: 64
  | max_heap_table_size: 16777216
  | max_insert_delayed_threads: 20
  | max_join_size: 4294967295
  | max_length_for_sort_data: 1024
  | max_prepared_stmt_count: 16382
  | max_relay_log_size: 0
  | max_seeks_for_key: 4294967295
  | max_sort_length: 1024
  | max_sp_recursion_depth: 0
  | max_tmp_tables: 32
  | max_user_connections: 0
  | max_write_lock_count: 4294967295
  | multi_range_count: 256
  | myisam_data_pointer_size: 6
  | myisam_max_sort_file_size: 107374182400
  | myisam_recover_options: OFF
  | myisam_repair_threads: 1
  | myisam_sort_buffer_size: 27262976
  | myisam_stats_method: nulls_unequal
  | named_pipe: OFF
  | net_buffer_length: 16384
  | net_read_timeout: 30
  | net_retry_count: 10
  | net_write_timeout: 60
  | new: OFF
  | old_passwords: OFF
  | open_files_limit: 622
  | optimizer_prune_level: 1
  | optimizer_search_depth: 62
  | pid_file: C :\Arquivos de programas\MySQL\MySQL Server 5.0\Data\hsawork.pid
  | port: 3307
  | preload_buffer_size:

[jboss-user] [JBoss Portal] - Re: PortletPreferences in MySql

2008-02-26 Thread cassitos 
Ok. I will post only the error when try to save the preferences. before this 
there are no errors.
2008-02-26 16:26:37,359 ERROR [STDERR] 
org.jboss.portal.portlet.InvalidPortletIdException: Cannot configure producer 
offered portlets
  | 2008-02-26 16:26:37,359 ERROR [STDERR]  at 
org.jboss.portal.portlet.state.producer.ProducerPortletInvoker.setProperties(ProducerPortletInvoker.java:538)
  | 2008-02-26 16:26:37,359 ERROR [STDERR]  at 
org.jboss.portal.portlet.federation.impl.FederatedPortletInvokerService.setProperties(FederatedPortletInvokerService.java:212)
  | 2008-02-26 16:26:37,359 ERROR [STDERR]  at 
org.jboss.portal.portlet.federation.impl.FederatingPortletInvokerService.setProperties(FederatingPortletInvokerService.java:205)
  | 2008-02-26 16:26:37,359 ERROR [STDERR]  at 
org.jboss.portal.core.impl.model.instance.AbstractInstance.setProperties(AbstractInstance.java:185)
  | 2008-02-26 16:26:37,359 ERROR [STDERR]  at 
org.jboss.portal.core.admin.ui.InstanceManagerBean.updatePrefs(InstanceManagerBean.java:410)
  | 2008-02-26 16:26:37,359 ERROR [STDERR]  at 
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  | 2008-02-26 16:26:37,359 ERROR [STDERR]  at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
  | 2008-02-26 16:26:37,359 ERROR [STDERR]  at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  | 2008-02-26 16:26:37,359 ERROR [STDERR]  at 
java.lang.reflect.Method.invoke(Method.java:585)
  | 2008-02-26 16:26:37,359 ERROR [STDERR]  at 
com.sun.el.parser.AstValue.invoke(AstValue.java:130)
  | 2008-02-26 16:26:37,359 ERROR [STDERR]  at 
com.sun.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:274)
  | 2008-02-26 16:26:37,359 ERROR [STDERR]  at 
com.sun.facelets.el.TagMethodExpression.invoke(TagMethodExpression.java:68)
  | 2008-02-26 16:26:37,359 ERROR [STDERR]  at 
com.sun.facelets.el.LegacyMethodBinding.invoke(LegacyMethodBinding.java:69)
  | 2008-02-26 16:26:37,359 ERROR [STDERR]  at 
org.apache.myfaces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:61)
  | 2008-02-26 16:26:37,359 ERROR [STDERR]  at 
javax.faces.component.UICommand.broadcast(UICommand.java:109)
  | 2008-02-26 16:26:37,359 ERROR [STDERR]  at 
javax.faces.component.UIViewRoot._broadcastForPhase(UIViewRoot.java:97)
  | 2008-02-26 16:26:37,359 ERROR [STDERR]  at 
javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:171)
  | 2008-02-26 16:26:37,359 ERROR [STDERR]  at 
org.apache.myfaces.lifecycle.InvokeApplicationExecutor.execute(InvokeApplicationExecutor.java:32)
  | 2008-02-26 16:26:37,359 ERROR [STDERR]  at 
org.apache.myfaces.lifecycle.LifecycleImpl.executePhase(LifecycleImpl.java:95)
  | 2008-02-26 16:26:37,359 ERROR [STDERR]  at 
org.apache.myfaces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:70)
  | 2008-02-26 16:26:37,359 ERROR [STDERR]  at 
org.apache.myfaces.portlet.MyFacesGenericPortlet.processAction(MyFacesGenericPortlet.java:246)
  | 2008-02-26 16:26:37,359 ERROR [STDERR]  at 
org.jboss.portal.faces.loader.FacesPortlet.processAction(FacesPortlet.java:83)
  | 2008-02-26 16:26:37,359 ERROR [STDERR]  at 
org.jboss.portal.portlet.impl.jsr168.PortletContainerImpl.invokeAction(PortletContainerImpl.java:458)
  | 2008-02-26 16:26:37,359 ERROR [STDERR]  at 
org.jboss.portal.portlet.impl.jsr168.PortletContainerImpl.dispatch(PortletContainerImpl.java:401)
  | 2008-02-26 16:26:37,359 ERROR [STDERR]  at 
org.jboss.portal.portlet.container.PortletContainerInvoker$1.invoke(PortletContainerInvoker.java:86)
  | 2008-02-26 16:26:37,359 ERROR [STDERR]  at 
org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:131)
  | 2008-02-26 16:26:37,359 ERROR [STDERR]  at 
org.jboss.portal.core.aspects.portlet.TransactionInterceptor.org$jboss$portal$core$aspects$portlet$TransactionInterceptor$invokeRequired$aop(TransactionInterceptor.java:106)
  | 2008-02-26 16:26:37,359 ERROR [STDERR]  at 
org.jboss.portal.core.aspects.portlet.TransactionInterceptor$invokeRequired_9103964459766407072.invokeNext(TransactionInterceptor$invokeRequired_9103964459766407072.java)
  | 2008-02-26 16:26:37,359 ERROR [STDERR]  at 
org.jboss.aspects.tx.TxPolicy.invokeInCallerTx(TxPolicy.java:126)
  | 2008-02-26 16:26:37,359 ERROR [STDERR]  at 
org.jboss.aspects.tx.TxInterceptor$Required.invoke(TxInterceptor.java:195)
  | 2008-02-26 16:26:37,359 ERROR [STDERR]  at 
org.jboss.portal.core.aspects.portlet.TransactionInterceptor$invokeRequired_9103964459766407072.invokeNext(TransactionInterceptor$invokeRequired_9103964459766407072.java)
  | 2008-02-26 16:26:37,359 ERROR [STDERR]  at 
org.jboss.aspects.tx.TxPolicy.invokeInCallerTx(TxPolicy.java:126)
  | 2008-02-26 16:26:37,359 ERROR [STDERR]  at 
org.jboss.aspects.tx.TxInterceptor$Required.invoke(TxInterceptor.java:195)
  | 2008-02-26 16:26:37,359 ERROR

[jboss-user] [JBoss Portal] - Re: PortletPreferences in MySql

2008-02-26 Thread [EMAIL PROTECTED] 
Can you post the complete stack track from server.log? This is weird because I 
have not had this problem before.

View the original post : 
http://www.jboss.com/index.html?module=bbop=viewtopicp=4132300#4132300

Reply to the post : 
http://www.jboss.com/index.html?module=bbop=postingmode=replyp=4132300
___
jboss-user mailing list
jboss-user@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-user

[jboss-user] [JBoss Portal] - Re: PortletPreferences in MySql

2008-02-26 Thread [EMAIL PROTECTED] 
Before you and I dig any further, can you see if you can personalize some other 
portlets without any problem? This could be something with RSS portlet itself.

View the original post : 
http://www.jboss.com/index.html?module=bbop=viewtopicp=4132337#4132337

Reply to the post : 
http://www.jboss.com/index.html?module=bbop=postingmode=replyp=4132337
___
jboss-user mailing list
jboss-user@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-user

[jboss-user] [JBoss Portal] - Re: PortletPreferences in MySql

2008-02-26 Thread cassitos 
I had the same question.
So I tried other portlets (RSS from PortletSwap) (and created one, only to test 
preference), the problem is the same.
I filled the fields, like RssXml atribute, and click on Save. When back to 
verify the preference value, was not modified.
So, if I back the database to HSQLDB, this functionality works fine. But I NEED 
to use MySql here... :(
Tks

View the original post : 
http://www.jboss.com/index.html?module=bbop=viewtopicp=4132356#4132356

Reply to the post : 
http://www.jboss.com/index.html?module=bbop=postingmode=replyp=4132356
___
jboss-user mailing list
jboss-user@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-user