"Failed to load users/passwords/role files"
affeee
I have tried to install Duroty on a system running:
Debian Sarge
Postgresql 8.1
JDK 1.6.0
Jboss 4.0.4 AS
But when i try to login, following error appears:
[UsersRoleLoginModule] Failed to load users/passwords/role files
java.io.IOException: No properties file: users.properties or defaults:
defaultUsers.properties found
Any suggestions?
affeee
Hadnt added the Security domain for DUROTY.
I also added all the additional Java libs. But how can i loging as
admin? What are the credentials?
Documentation on your site says:
"When deployment of application is completed (duroty.ear) in the
application server ($JBOSS_HOME/server/default/deploy) a duroty user
and a duroty password will be created with an admin profile in order to
manage the site."
affeee
affeee skrev:
When i try to register a new user i get:
"???SecurityException; nested exception is: n
java.lang.SecurityException: Insufficient method permissions,
principal=null, ejbName=Open, method=create, interface=HOME,
requiredRoles=[guest], principalRoles=[]???"
aidanbon
Make sure you create new users via the duroty interface after logging
in as user "duroty" (with password also is "duroty"). After logged in,
you
should find an "Admin" link on the upper right corner.
Good luck!
affeee
Thank you for your answer.
I cannot login in with "duroty/duroty", i get "login failed".
When i look into the sqldb, there are no data in user table.
I also get a lot of "WARN [FromElementType] Using non-qualified column
reference" when i start up jboss.
aidanbon skrev:
Jordi Marquès
affeee
Jordi Marquès
The message "WARN [FromElementType] Using non-qualified column reference" is normal, it is not an error message.
I have just checked Duroty in 4.0.3, 4.0.4, 4.0.5 versions and I cannot find this error.
If you follow the default installation it would work correctly.
Follow the steps below:
Generate a duroty-ds.xml file in $JBOSS_HOME/server/default/deploy/ in order to have a connection datasource for the duroty database previously created.
See duroty-ds.xml file
Modify log4j.xml file in $JBOSS_HOME/server/default/conf/ adding the data of the example. This will activate a specific log file for the application and also avoids that hibernate enters in DEBUG mode.
See log4j.xml file
Modify login-config.xml file in $JBOSS_HOME/server/default/conf/ to include JAAS security domain.
Asegurate de situar la application-policy antes de la entrada <application-policy name = "other">
See login-config.xml file
Download java libraries and copy the jars in $JBOSS_HOME/server/default/lib
Download duroty.ear.1.1 and copy duroty.ear directory in $JBOSS_HOME/server/default/
Start $JBOSS_HOME/bin/run.sh
I use jboss 4.0.4.GA
Jordi Marqu s skrev:
affeee
I have tried all this, but it looks like the database wont be populated
when Duroty is deployed.
I dont get any SQLerrors, but i still cant login.
My log:
19:19:41,594 INFO [Server] Release ID: JBoss [Zion] 4.0.4.GA (build:
CVSTag=JBoss_4_0_4_GA date=200605151000)
19:19:41,599 INFO [Server] Home Dir: /tmp/jboss-4.0.4.GA
19:19:41,599 INFO [Server] Home URL: file:/tmp/jboss-4.0.4.GA/
19:19:41,602 INFO [Server] Patch URL: null
19:19:41,603 INFO [Server] Server Name: default
19:19:41,603 INFO [Server] Server Home Dir:
/tmp/jboss-4.0.4.GA/server/default
19:19:41,604 INFO [Server] Server Home URL:
file:/tmp/jboss-4.0.4.GA/server/default/
19:19:41,605 INFO [Server] Server Log Dir:
/tmp/jboss-4.0.4.GA/server/default/log
19:19:41,606 INFO [Server] Server Temp Dir:
/tmp/jboss-4.0.4.GA/server/default/tmp
19:19:41,607 INFO [Server] Root Deployment Filename: jboss-service.xml
19:19:43,239 INFO [ServerInfo] Java version: 1.6.0,Sun Microsystems
Inc.
19:19:43,240 INFO [ServerInfo] Java VM: Java HotSpot(TM) Server VM
1.6.0-b105,Sun Microsystems Inc.
19:19:43,241 INFO [ServerInfo] OS-System: Linux 2.6.8-2-386,i386
19:19:44,990 INFO [Server] Core system initialized
19:19:52,691 INFO [WebService] Using RMI server codebase:
http://deb-burns:8083/
19:19:52,748 INFO [Log4jService$URLWatchTimerTask] Configuring from
URL: resource:log4j.xml
19:19:54,015 INFO [NamingService] JNDI bootstrap JNP=/0.0.0.0:1099,
RMI=/0.0.0.0:1098, backlog=50, no client SocketFactory, Server
SocketFactory=class org.jboss.net.sockets.DefaultSocketFactory
19:20:04,344 INFO [Embedded] Catalina naming disabled
19:20:04,470 INFO [ClusterRuleSetFactory] Unable to find a cluster
rule set in the classpath. Will load the default rule set.
19:20:04,474 INFO [ClusterRuleSetFactory] Unable to find a cluster
rule set in the classpath. Will load the default rule set.
19:20:05,409 INFO [Http11BaseProtocol] Initializing Coyote HTTP/1.1 on
http-0.0.0.0-8080
19:20:05,413 INFO [Catalina] Initialization processed in 938 ms
19:20:05,414 INFO [StandardService] Starting service jboss.web
19:20:05,423 INFO [StandardEngine] Starting Servlet Engine: Apache
Tomcat/5.5.17
19:20:05,856 INFO [StandardHost] XML validation disabled
19:20:05,906 INFO [Catalina] Server startup in 493 ms
19:20:06,260 INFO [TomcatDeployer] deploy, ctxPath=/invoker,
warUrl=.../deploy/http-invoker.sar/invoker.war/
19:20:07,272 INFO [WebappLoader] Dual registration of jndi stream
handler: factory already defined
19:20:09,026 INFO [TomcatDeployer] deploy, ctxPath=/,
warUrl=.../deploy/jbossweb-tomcat55.sar/ROOT.war/
19:20:10,719 INFO [TomcatDeployer] deploy, ctxPath=/jbossws,
warUrl=.../tmp/deploy/tmp3506jbossws-exp.war/
19:20:11,234 INFO [SubscriptionManager] Bound event dispatcher to
java:/EventDispatcher
19:20:11,802 INFO [TomcatDeployer] deploy, ctxPath=/jbossmq-httpil,
warUrl=.../deploy/jms/jbossmq-httpil.sar/jbossmq-httpil.war/
19:20:17,940 INFO [TomcatDeployer] deploy, ctxPath=/web-console,
warUrl=.../deploy/management/console-mgr.sar/web-console.war/
19:20:21,090 INFO [MailService] Mail Service bound to java:/Mail
19:20:22,809 INFO [RARDeployment] Required license terms exist, view
META-INF/ra.xml in .../deploy/jboss-ha-local-jdbc.rar
19:20:22,902 INFO [RARDeployment] Required license terms exist, view
META-INF/ra.xml in .../deploy/jboss-ha-xa-jdbc.rar
19:20:22,974 INFO [RARDeployment] Required license terms exist, view
META-INF/ra.xml in .../deploy/jboss-local-jdbc.rar
19:20:23,125 INFO [RARDeployment] Required license terms exist, view
META-INF/ra.xml in .../deploy/jboss-xa-jdbc.rar
19:20:23,256 INFO [RARDeployment] Required license terms exist, view
META-INF/ra.xml in .../deploy/jms/jms-ra.rar
19:20:23,329 INFO [RARDeployment] Required license terms exist, view
META-INF/ra.xml in .../deploy/mail-ra.rar
19:20:23,868 INFO [ConnectionFactoryBindingService] Bound
ConnectionManager
'jboss.jca:service=DataSourceBinding,name=/duroty/jdbc/DataSource' to
JNDI name 'java:/duroty/jdbc/DataSource'
19:20:25,584 INFO [ConnectionFactoryBindingService] Bound
ConnectionManager 'jboss.jca:service=DataSourceBinding,name=DefaultDS'
to JNDI name 'java:DefaultDS'
19:20:26,193 INFO [A] Bound to JNDI name: queue/A
19:20:26,199 INFO [B] Bound to JNDI name: queue/B
19:20:26,204 INFO [C] Bound to JNDI name: queue/C
19:20:26,208 INFO [D] Bound to JNDI name: queue/D
19:20:26,213 INFO [ex] Bound to JNDI name: queue/ex
19:20:26,261 INFO [testTopic] Bound to JNDI name: topic/testTopic
19:20:26,266 INFO [securedTopic] Bound to JNDI name:
topic/securedTopic
19:20:26,271 INFO [testDurableTopic] Bound to JNDI name:
topic/testDurableTopic
19:20:26,280 INFO [testQueue] Bound to JNDI name: queue/testQueue
19:20:26,386 INFO [UILServerILService] JBossMQ UIL service available
at : /0.0.0.0:8093
19:20:26,502 INFO [DLQ] Bound to JNDI name: queue/DLQ
19:20:26,819 INFO [ConnectionFactoryBindingService] Bound
ConnectionManager
'jboss.jca:service=ConnectionFactoryBinding,name=JmsXA' to JNDI name
'java:JmsXA'
19:20:26,932 INFO [TomcatDeployer] deploy, ctxPath=/jmx-console,
warUrl=.../deploy/jmx-console.war/
19:20:27,562 INFO [EARDeployer] Init J2EE application:
file:/tmp/jboss-4.0.4.GA/server/default/deploy/duroty.ear/
19:20:33,270 INFO [EjbModule] Deploying Open
19:20:33,489 INFO [EjbModule] Deploying Chat
19:20:33,509 INFO [EjbModule] Deploying Home
19:20:33,529 INFO [EjbModule] Deploying Store
19:20:33,548 INFO [EjbModule] Deploying Preferences
19:20:33,570 INFO [EjbModule] Deploying FilesSearch
19:20:33,592 INFO [EjbModule] Deploying Admin
19:20:33,614 INFO [EjbModule] Deploying Files
19:20:33,634 INFO [EjbModule] Deploying Bookmark
19:20:33,659 INFO [EjbModule] Deploying Send
19:20:33,712 INFO [EjbModule] Deploying Mail
19:20:33,733 INFO [EjbModule] Deploying Search
19:20:34,785 INFO [DurotyMailFactory] DurotyMailFactory Service bound
to java:/duroty/mail/durotyMailFactoryProperties
19:20:34,810 INFO [DurotyMailFactory] DurotyMailFactory Service bound
to java:/duroty/mail/durotyMailFactory
19:20:34,837 INFO [ParseFactoryConfig] ParseFactoryConfig Service
bound to java:/duroty/constants/ParseFactoryConfig
19:20:35,049 INFO [ExtensionConfig] ExtensionConfig Service bound to
java:/duroty/constants/ExtensionConfig
19:20:35,060 INFO [MailConfig] MailConfig Service bound to
java:/duroty/constants/MailConfig
19:20:35,067 INFO [BookmarkConfig] BookmarkConfig Service bound to
java:/duroty/constants/BookmarkConfig
19:20:35,072 INFO [ChatConfig] ChatConfig Service bound to
java:/duroty/constants/ChatConfig
19:20:36,124 INFO [Environment] Hibernate 3.2 cr2
19:20:36,142 INFO [Environment] hibernate.properties not found
19:20:36,147 INFO [Environment] Bytecode provider name : javassist
19:20:36,164 INFO [Environment] using JDK 1.4 java.sql.Timestamp
handling
19:20:36,388 INFO [Configuration] Reading mappings from file:
/tmp/jboss-4.0.4.GA/server/default/deploy/duroty.ear/durotyHAR.har/com/duroty/hibernate/AttachmentWithDate.hbm.xml
19:20:36,635 INFO [HbmBinder] Mapping class:
com.duroty.hibernate.AttachmentWithDate -> AttachmentWithDate
19:20:37,376 INFO [Configuration] Reading mappings from file:
/tmp/jboss-4.0.4.GA/server/default/deploy/duroty.ear/durotyHAR.har/com/duroty/hibernate/Label.hbm.xml
19:20:37,525 INFO [HbmBinder] Mapping class:
com.duroty.hibernate.Label -> label
19:20:37,541 INFO [Configuration] Reading mappings from file:
/tmp/jboss-4.0.4.GA/server/default/deploy/duroty.ear/durotyHAR.har/com/duroty/hibernate/Attachment.hbm.xml
19:20:37,691 INFO [HbmBinder] Mapping class:
com.duroty.hibernate.Attachment -> attachment
19:20:37,694 INFO [Configuration] Reading mappings from file:
/tmp/jboss-4.0.4.GA/server/default/deploy/duroty.ear/durotyHAR.har/com/duroty/hibernate/Bookmark.hbm.xml
19:20:39,858 INFO [HbmBinder] Mapping class:
com.duroty.hibernate.Bookmark -> bookmark
19:20:39,862 INFO [Configuration] Reading mappings from file:
/tmp/jboss-4.0.4.GA/server/default/deploy/duroty.ear/durotyHAR.har/com/duroty/hibernate/Roles.hbm.xml
19:20:40,108 INFO [HbmBinder] Mapping class:
com.duroty.hibernate.Roles -> roles
19:20:40,111 INFO [Configuration] Reading mappings from file:
/tmp/jboss-4.0.4.GA/server/default/deploy/duroty.ear/durotyHAR.har/com/duroty/hibernate/Message.hbm.xml
19:20:40,229 INFO [HbmBinder] Mapping class:
com.duroty.hibernate.Message -> message
19:20:40,280 INFO [Configuration] Reading mappings from file:
/tmp/jboss-4.0.4.GA/server/default/deploy/duroty.ear/durotyHAR.har/com/duroty/hibernate/BayesianSpam.hbm.xml
19:20:40,503 INFO [HbmBinder] Mapping class:
com.duroty.hibernate.BayesianSpam -> bayesian_spam
19:20:40,505 INFO [Configuration] Reading mappings from file:
/tmp/jboss-4.0.4.GA/server/default/deploy/duroty.ear/durotyHAR.har/com/duroty/hibernate/FeedData.hbm.xml
19:20:41,226 INFO [HbmBinder] Mapping class:
com.duroty.hibernate.FeedData -> feed_data
19:20:41,229 INFO [Configuration] Reading mappings from file:
/tmp/jboss-4.0.4.GA/server/default/deploy/duroty.ear/durotyHAR.har/com/duroty/hibernate/Users.hbm.xml
19:20:41,324 INFO [HbmBinder] Mapping class:
com.duroty.hibernate.Users -> users
19:20:41,381 INFO [Configuration] Reading mappings from file:
/tmp/jboss-4.0.4.GA/server/default/deploy/duroty.ear/durotyHAR.har/com/duroty/hibernate/Filter.hbm.xml
19:20:41,429 INFO [HbmBinder] Mapping class:
com.duroty.hibernate.Filter -> filter
19:20:41,436 INFO [Configuration] Reading mappings from file:
/tmp/jboss-4.0.4.GA/server/default/deploy/duroty.ear/durotyHAR.har/com/duroty/hibernate/Conversations.hbm.xml
19:20:41,486 INFO [HbmBinder] Mapping class:
com.duroty.hibernate.Conversations -> conversations
19:20:41,489 INFO [Configuration] Reading mappings from file:
/tmp/jboss-4.0.4.GA/server/default/deploy/duroty.ear/durotyHAR.har/com/duroty/hibernate/Alias.hbm.xml
19:20:41,530 INFO [HbmBinder] Mapping class:
com.duroty.hibernate.Alias -> alias
19:20:41,532 INFO [Configuration] Reading mappings from file:
/tmp/jboss-4.0.4.GA/server/default/deploy/duroty.ear/durotyHAR.har/com/duroty/hibernate/BayesianHam.hbm.xml
19:20:42,299 INFO [HbmBinder] Mapping class:
com.duroty.hibernate.BayesianHam -> bayesian_ham
19:20:42,301 INFO [Configuration] Reading mappings from file:
/tmp/jboss-4.0.4.GA/server/default/deploy/duroty.ear/durotyHAR.har/com/duroty/hibernate/UserRole.hbm.xml
19:20:42,395 INFO [HbmBinder] Mapping class:
com.duroty.hibernate.UserRole -> user_role
19:20:42,399 INFO [Configuration] Reading mappings from file:
/tmp/jboss-4.0.4.GA/server/default/deploy/duroty.ear/durotyHAR.har/com/duroty/hibernate/LabMes.hbm.xml
19:20:42,436 INFO [HbmBinder] Mapping class:
com.duroty.hibernate.LabMes -> lab_mes
19:20:42,438 INFO [Configuration] Reading mappings from file:
/tmp/jboss-4.0.4.GA/server/default/deploy/duroty.ear/durotyHAR.har/com/duroty/hibernate/MailPreferences.hbm.xml
19:20:43,364 INFO [HbmBinder] Mapping class:
com.duroty.hibernate.MailPreferences -> mail_preferences
19:20:43,369 INFO [Configuration] Reading mappings from file:
/tmp/jboss-4.0.4.GA/server/default/deploy/duroty.ear/durotyHAR.har/com/duroty/hibernate/BayesianMessagecounts.hbm.xml
19:20:43,406 INFO [HbmBinder] Mapping class:
com.duroty.hibernate.BayesianMessagecounts -> bayesian_messagecounts
19:20:43,409 INFO [Configuration] Reading mappings from file:
/tmp/jboss-4.0.4.GA/server/default/deploy/duroty.ear/durotyHAR.har/com/duroty/hibernate/FeedChannel.hbm.xml
19:20:43,452 INFO [HbmBinder] Mapping class:
com.duroty.hibernate.FeedChannel -> feed_channel
19:20:43,455 INFO [Configuration] Reading mappings from file:
/tmp/jboss-4.0.4.GA/server/default/deploy/duroty.ear/durotyHAR.har/com/duroty/hibernate/ContactList.hbm.xml
19:20:44,420 INFO [HbmBinder] Mapping class:
com.duroty.hibernate.ContactList -> contact_list
19:20:44,423 INFO [Configuration] Reading mappings from file:
/tmp/jboss-4.0.4.GA/server/default/deploy/duroty.ear/durotyHAR.har/com/duroty/hibernate/BuddyList.hbm.xml
19:20:44,451 INFO [HbmBinder] Mapping class:
com.duroty.hibernate.BuddyList -> buddy_list
19:20:44,454 INFO [Configuration] Reading mappings from file:
/tmp/jboss-4.0.4.GA/server/default/deploy/duroty.ear/durotyHAR.har/com/duroty/hibernate/ConColi.hbm.xml
19:20:44,479 INFO [HbmBinder] Mapping class:
com.duroty.hibernate.ConColi -> con_coli
19:20:44,481 INFO [Configuration] Reading mappings from file:
/tmp/jboss-4.0.4.GA/server/default/deploy/duroty.ear/durotyHAR.har/com/duroty/hibernate/Identity.hbm.xml
19:20:44,510 INFO [HbmBinder] Mapping class:
com.duroty.hibernate.Identity -> identity
19:20:44,514 INFO [Configuration] Reading mappings from file:
/tmp/jboss-4.0.4.GA/server/default/deploy/duroty.ear/durotyHAR.har/com/duroty/hibernate/Contact.hbm.xml
19:20:44,545 INFO [HbmBinder] Mapping class:
com.duroty.hibernate.Contact -> contact
19:20:44,551 INFO [HbmBinder] Mapping collection:
com.duroty.hibernate.Label.labMeses -> lab_mes
19:20:44,553 INFO [HbmBinder] Mapping collection:
com.duroty.hibernate.Label.filters -> filter
19:20:44,554 INFO [HbmBinder] Mapping collection:
com.duroty.hibernate.Roles.userRoles -> user_role
19:20:44,555 INFO [HbmBinder] Mapping collection:
com.duroty.hibernate.Message.attachments -> attachment
19:20:44,556 INFO [HbmBinder] Mapping collection:
com.duroty.hibernate.Message.labMeses -> lab_mes
19:20:44,557 INFO [HbmBinder] Mapping collection:
com.duroty.hibernate.Users.identities -> identity
19:20:44,558 INFO [HbmBinder] Mapping collection:
com.duroty.hibernate.Users.messages -> message
19:20:44,560 INFO [HbmBinder] Mapping collection:
com.duroty.hibernate.Users.conversationsesForConvSenderIdint ->
conversations
19:20:44,561 INFO [HbmBinder] Mapping collection:
com.duroty.hibernate.Users.buddyListsForBuliOwnerIdint -> buddy_list
19:20:44,562 INFO [HbmBinder] Mapping collection:
com.duroty.hibernate.Users.conversationsesForConvRecipientIdint ->
conversations
19:20:44,563 INFO [HbmBinder] Mapping collection:
com.duroty.hibernate.Users.feedChannels -> feed_channel
19:20:44,564 INFO [HbmBinder] Mapping collection:
com.duroty.hibernate.Users.bookmarks -> bookmark
19:20:44,565 INFO [HbmBinder] Mapping collection:
com.duroty.hibernate.Users.labels -> label
19:20:44,566 INFO [HbmBinder] Mapping collection:
com.duroty.hibernate.Users.mailPreferenceses -> mail_preferences
19:20:44,568 INFO [HbmBinder] Mapping collection:
com.duroty.hibernate.Users.contacts -> contact
19:20:44,569 INFO [HbmBinder] Mapping collection:
com.duroty.hibernate.Users.buddyListsForBuliBuddyIdint -> buddy_list
19:20:44,570 INFO [HbmBinder] Mapping collection:
com.duroty.hibernate.Users.userRoles -> user_role
19:20:44,571 INFO [HbmBinder] Mapping collection:
com.duroty.hibernate.Users.contactLists -> contact_list
19:20:44,572 INFO [HbmBinder] Mapping collection:
com.duroty.hibernate.FeedChannel.feedDatas -> feed_data
19:20:44,573 INFO [HbmBinder] Mapping collection:
com.duroty.hibernate.ContactList.conColis -> con_coli
19:20:44,574 INFO [HbmBinder] Mapping collection:
com.duroty.hibernate.Contact.conColis -> con_coli
19:20:44,837 INFO [NamingHelper] JNDI InitialContext properties:{}
19:20:44,838 INFO [DatasourceConnectionProvider] Using datasource:
java:/duroty/jdbc/DataSource
19:20:45,552 INFO [SettingsFactory] RDBMS: PostgreSQL, version: 8.1.5
19:20:45,555 INFO [SettingsFactory] JDBC driver: PostgreSQL Native
Driver, version: PostgreSQL 8.0 JDBC3 with SSL (build 310)
19:20:45,617 INFO [Dialect] Using dialect:
org.hibernate.dialect.PostgreSQLDialect
19:20:45,637 INFO [TransactionFactoryFactory] Transaction strategy:
org.hibernate.transaction.JTATransactionFactory
19:20:45,638 INFO [NamingHelper] JNDI InitialContext properties:{}
19:20:45,642 INFO [TransactionManagerLookupFactory] instantiating
TransactionManagerLookup:
org.hibernate.transaction.JBossTransactionManagerLookup
19:20:45,643 INFO [TransactionManagerLookupFactory] instantiated
TransactionManagerLookup
19:20:45,644 INFO [TransactionManagerLookupFactory] instantiating
TransactionManagerLookup:
org.hibernate.transaction.JBossTransactionManagerLookup
19:20:45,644 INFO [TransactionManagerLookupFactory] instantiated
TransactionManagerLookup
19:20:45,645 INFO [SettingsFactory] Automatic flush during
beforeCompletion(): enabled
19:20:45,646 INFO [SettingsFactory] Automatic session close at end of
transaction: enabled
19:20:45,646 INFO [SettingsFactory] JDBC batch size: 15
19:20:45,647 INFO [SettingsFactory] JDBC batch updates for versioned
data: disabled
19:20:45,650 INFO [SettingsFactory] Scrollable result sets: enabled
19:20:45,651 INFO [SettingsFactory] JDBC3 getGeneratedKeys(): disabled
19:20:45,651 INFO [SettingsFactory] Connection release mode:
after_statement
19:20:45,655 INFO [SettingsFactory] Default batch fetch size: 1
19:20:45,655 INFO [SettingsFactory] Generate SQL with comments:
disabled
19:20:45,656 INFO [SettingsFactory] Order SQL updates by primary key:
disabled
19:20:45,657 INFO [SettingsFactory] Query translator:
org.hibernate.hql.ast.ASTQueryTranslatorFactory
19:20:45,667 INFO [ASTQueryTranslatorFactory] Using
ASTQueryTranslatorFactory
19:20:45,668 INFO [SettingsFactory] Query language substitutions: {}
19:20:45,668 INFO [SettingsFactory] Second-level cache: enabled
19:20:45,669 INFO [SettingsFactory] Query cache: disabled
19:20:45,669 INFO [SettingsFactory] Cache provider:
org.hibernate.cache.HashtableCacheProvider
19:20:45,675 INFO [SettingsFactory] Optimize cache for minimal puts:
disabled
19:20:45,675 INFO [SettingsFactory] Structured second-level cache
entries: disabled
19:20:45,697 INFO [SettingsFactory] Statistics: disabled
19:20:45,697 INFO [SettingsFactory] Deleted entity synthetic
identifier rollback: disabled
19:20:45,698 INFO [SettingsFactory] Default entity-mode: pojo
19:20:45,953 INFO [SessionFactoryImpl] building session factory
19:20:47,249 INFO [SessionFactoryObjectFactory] Not binding factory to
JNDI, no JNDI name configured
19:20:47,250 INFO [NamingHelper] JNDI InitialContext properties:{}
19:20:47,681 WARN [FromElementType] Using non-qualified column
reference [mesBox -> ([mes_box])]
19:20:47,701 WARN [FromElementType] Using non-qualified column
reference [mesName -> ([mes_name])]
19:20:47,703 WARN [FromElementType] Using non-qualified column
reference [users -> ([mes_use_idint])]
19:20:47,884 WARN [FromElementType] Using non-qualified column
reference [usersByConvRecipientIdint -> ([conv_recipient_idint])]
19:20:47,906 WARN [FromElementType] Using non-qualified column
reference [mesBox -> ([mes_box])]
19:20:47,907 WARN [FromElementType] Using non-qualified column
reference [mesBox -> ([mes_box])]
19:20:47,909 WARN [FromElementType] Using non-qualified column
reference [users -> ([mes_use_idint])]
19:20:47,935 WARN [FromElementType] Using non-qualified column
reference [mesFlagged -> ([mes_flagged])]
19:20:47,939 WARN [FromElementType] Using non-qualified column
reference [mesFlagged -> ([mes_flagged])]
19:20:47,943 WARN [FromElementType] Using non-qualified column
reference [mesFlagged -> ([mes_flagged])]
19:20:47,945 WARN [FromElementType] Using non-qualified column
reference [mesName -> ([mes_name])]
19:20:47,947 WARN [FromElementType] Using non-qualified column
reference [users -> ([mes_use_idint])]
19:20:47,970 WARN [FromElementType] Using non-qualified column
reference [mesBox -> ([mes_box])]
19:20:47,971 WARN [FromElementType] Using non-qualified column
reference [mesName -> ([mes_name])]
19:20:47,973 WARN [FromElementType] Using non-qualified column
reference [users -> ([mes_use_idint])]
19:20:48,021 WARN [FromElementType] Using non-qualified column
reference [mesRecent -> ([mes_recent])]
19:20:48,023 WARN [FromElementType] Using non-qualified column
reference [mesRecent -> ([mes_recent])]
19:20:48,024 WARN [FromElementType] Using non-qualified column
reference [mesRecent -> ([mes_recent])]
19:20:48,026 WARN [FromElementType] Using non-qualified column
reference [mesName -> ([mes_name])]
19:20:48,028 WARN [FromElementType] Using non-qualified column
reference [users -> ([mes_use_idint])]
19:20:48,084 WARN [FromElementType] Using non-qualified column
reference [id.message -> ([mes_idint])]
19:20:48,085 WARN [FromElementType] Using non-qualified column
reference [id.message -> ([mes_idint])]
19:20:48,136 WARN [FromElementType] Using non-qualified column
reference [id.label -> ([lab_idint])]
19:20:48,137 WARN [FromElementType] Using non-qualified column
reference [id.label -> ([lab_idint])]
19:20:48,165 WARN [FromElementType] Using non-qualified column
reference [mesBox -> ([mes_box])]
19:20:48,176 WARN [FromElementType] Using non-qualified column
reference [users -> ([mes_use_idint])]
19:20:48,200 WARN [FromElementType] Using non-qualified column
reference [filIdint -> ([fil_idint])]
19:20:48,201 WARN [FromElementType] Using non-qualified column
reference [label -> ([fil_lab_idint])]
19:20:48,380 INFO [Hibernate] SessionFactory successfully built and
bound into JNDI [java:/duroty/hibernate/SessionFactory]
19:20:49,079 INFO [ProxyFactory] Bound EJB Home 'Open' to jndi
'duroty/ejb/Open'
19:20:49,180 INFO [ProxyFactory] Bound EJB Home 'Chat' to jndi
'duroty/ejb/Chat'
19:20:49,233 INFO [ProxyFactory] Bound EJB Home 'Home' to jndi
'duroty/ejb/Home'
19:20:49,263 INFO [ProxyFactory] Bound EJB Home 'Store' to jndi
'duroty/ejb/Store'
19:20:49,768 INFO [ProxyFactory] Bound EJB Home 'Preferences' to jndi
'duroty/ejb/Preferences'
19:20:50,668 INFO [ProxyFactory] Bound EJB Home 'FilesSearch' to jndi
'duroty/ejb/FilesSearch'
19:20:50,701 INFO [ProxyFactory] Bound EJB Home 'Admin' to jndi
'duroty/ejb/Admin'
19:20:50,735 INFO [ProxyFactory] Bound EJB Home 'Files' to jndi
'duroty/ejb/Files'
19:20:51,855 INFO [ProxyFactory] Bound EJB Home 'Bookmark' to jndi
'duroty/ejb/Bookmark'
19:20:51,889 INFO [ProxyFactory] Bound EJB Home 'Send' to jndi
'duroty/ejb/Send'
19:20:52,480 INFO [ProxyFactory] Bound EJB Home 'Mail' to jndi
'duroty/ejb/Mail'
19:20:52,513 INFO [ProxyFactory] Bound EJB Home 'Search' to jndi
'duroty/ejb/Search'
19:20:52,518 INFO [EJBDeployer] Deployed:
file:/tmp/jboss-4.0.4.GA/server/default/deploy/duroty.ear/durotyEJB.jar/
19:20:54,521 INFO [TomcatDeployer] deploy, ctxPath=/duroty,
warUrl=.../deploy/duroty.ear/durotyWeb.war/
19:20:59,361 INFO [ValidatorPlugIn] Loading validation rules file from
'/WEB-INF/validator-rules.xml'
19:20:59,367 INFO [ValidatorPlugIn] Loading validation rules file from
'/WEB-INF/configuration/validation.xml'
19:21:00,143 INFO [EARDeployer] Started J2EE application:
file:/tmp/jboss-4.0.4.GA/server/default/deploy/duroty.ear/
19:21:00,483 INFO [Http11BaseProtocol] Starting Coyote HTTP/1.1 on
http-0.0.0.0-8080
19:21:01,964 INFO [ChannelSocket] JK: ajp13 listening on /0.0.0.0:8009
19:21:02,119 INFO [JkMain] Jk running ID=0 time=0/539 config=null
19:21:03,486 INFO [Server] JBoss (MX MicroKernel) [4.0.4.GA (build:
CVSTag=JBoss_4_0_4_GA date=200605151000)] Started in 1m:21s:871ms
On 29 Dec, 20:13, "Jordi Marquès" <jordi.marq...@gmail.com> wrote:
> Hello,
>
> The message "WARN [FromElementType] Using non-qualified column reference" is
> normal, it is not an error message.
>
> I have just checked Duroty in 4.0.3, 4.0.4, 4.0.5 versions and I cannot find
> this error.
> If you follow the default installation it would work correctly.
>
> Follow the steps below:
>
> Generate a duroty-ds.xml file in $JBOSS_HOME/server/default/deploy/ in order
> to have a connection datasource for the duroty database previously created.
> See duroty-ds.xml file <http://www.duroty.com/duroty-ds.xml>
>
> Modify log4j.xml file in $JBOSS_HOME/server/default/conf/ adding the data of
> the example. This will activate a specific log file for the application and
> also avoids that hibernate enters in DEBUG mode.
> See log4j.xml file <http://www.duroty.com/log4j.xml>
>
> Modify login-config.xml file in $JBOSS_HOME/server/default/conf/ to include
> JAAS security domain.
> Asegurate de situar la application-policy antes de la entrada
> <application-policy name = "other">
> See login-config.xml file <http://www.duroty.com/login-config.xml>
>
> Download java libraries
> <http://www.duroty.com/en/download-libraries.jsp>and copy the jars in
> $JBOSS_HOME/server/default/lib
>
> Download duroty.ear.1.1 <http://www.duroty.com/en/download-duroty.jsp> and
> copy duroty.ear directory in $JBOSS_HOME/server/default/
>
> Start $JBOSS_HOME/bin/run.sh
>
> On 12/29/06, affeee <jimmy.arons...@gmail.com> wrote:
>
>
>
>
>
> > I use jboss 4.0.4.GA
>
> > Jordi Marqu s skrev:
>
> > > That version of jboss you use?
>
> > >http://www.duroty.com--
> Jordi Marqu?shttp://www.duroty.com
Jordi Marquès
My log is identical (in JBoss 4.0.4), although I use postgresql 8.1.4
- That version of java you use? - Duroty is compiled for jdk 1.5
- Is empty the "ROLES" table?
affeee
1. I use jdk 1.6.0, i can try with 1.5 instead.
2. "ROLES" has following rows:
1 guest
2 member
3 mail
4 bookmark
5 chat
6 admin
//Jimmy
Jordi Marquès skrev:
> Hi,
>
> My log is identical (in JBoss 4.0.4), although I use postgresql 8.1.4
>
> 1. That version of java you use? - Duroty is compiled for jdk 1.5
> 2. Is empty the "ROLES" table?
> Jordi Marqu?s
> http://www.duroty.com
Jordi Marquès
You try to execute following sql commands manually:
insert into users values (7, 'duroty', 'duroty', 'Duroty System', 'duroty@localhost', 'en', true, '2006-12-30 21:00:00', 0, null, 0, null);
insert into users values (10, 'guest', 'guest', 'Guest System', 'guest@localhost', 'en', true, '2006-12-30 21:00:00', 0, null, 0, null);
insert into user_role values('7','2');
insert into user_role values('7','4');
insert into user_role values('7','5');
insert into user_role values('7','6');
insert into user_role values('10','1');
insert into mail_preferences values (9, 7, 20, null, true, false, null, null, 1048576, 0);
insert into mail_preferences values (11, 10, 20, null, true, false, null, null, 1048576, 0);
insert into identity values (8, 7, 'Duroty System', 'duroty@localhost', 'duroty@localhost', 'AAAA', true, true);
You try enter to Duroty System as duroty/duroty
Hi
1. I use jdk 1.6.0, i can try with 1.5 instead.
2. "ROLES" has following rows:
1 guest
2 member
3 mail
4 bookmark
5 chat
6 admin
//Jimmy
Jordi Marqu s skrev:
affeee
But i have run into another problem. Will start a new thread about it.
//jimmy
On 30 Dec 2006, 22:09, "Jordi Marquès" <jordi.marq...@gmail.com>
wrote:
> Hi Jimmy,
>
> You try to execute following sql commands manually:
>
> insert into users values (7, 'duroty', 'duroty', 'Duroty System', '
> duroty@localhost', 'en', true, '2006-12-30 21:00:00', 0, null, 0, null);
> insert into users values (10, 'guest', 'guest', 'Guest System', '
> guest@localhost', 'en', true, '2006-12-30 21:00:00', 0, null, 0, null);
>
> insert into user_role values('7','2');
> insert into user_role values('7','4');
> insert into user_role values('7','5');
> insert into user_role values('7','6');
> insert into user_role values('10','1');
>
> insert into mail_preferences values (9, 7, 20, null, true, false, null,
> null, 1048576, 0);
> insert into mail_preferences values (11, 10, 20, null, true, false, null,
> null, 1048576, 0);
>
> insert into identity values (8, 7, 'Duroty System', 'duroty@localhost', '
> duroty@localhost', 'AAAA', true, true);
>
> You try enter to Duroty System as duroty/duroty
>
> On 12/30/06, affeee <jimmy.arons...@gmail.com> wrote:
>
>
>
> > Hi
>
> > 1. I use jdk 1.6.0, i can try with 1.5 instead.
> > 2. "ROLES" has following rows:
> > 1 guest
> > 2 member
> > 3 mail
> > 4 bookmark
> > 5 chat
> > 6 admin
>
> > //Jimmy
>
> > Jordi Marqu s skrev:
>
> > > Hi,
>
> > > My log is identical (in JBoss 4.0.4), although I use postgresql 8.1.4
>
> > > 1. That version of java you use? - Duroty is compiled for jdk 1.5
> > > 2. Is empty the "ROLES" table?
>
> > > Bye
>
> > > > com.duroty.hibernate.Attachment ->...
>
> läs mer »