-
15. Re: Bad password for username=admin
peterj Aug 28, 2006 6:01 PM (in response to andrewboyd)The '&' vs '& a m p ;' is a non-issue. I have it spelled out just like you, it appears that either the code tag or the browser replaced '& a m p ;' with siimply &.
Regarding whether you should be using utf-8, did you read the link I provided?
My default character set is latin1. -
16. Re: Bad password for username=admin
andrewboyd Aug 28, 2006 6:40 PM (in response to andrewboyd)Peter,
I just finished the article that you provided a link to. It looks like I should switch to latin1 ( at least for keys). I'm planning to use utf-8 eventually but if I can't get the app up I won't be using anything. :-(
Do I need to drop the DB and re-create with latin1 or do you know how to change?
I would like to thank you again for all of you help.
Andrew -
17. Re: Bad password for username=admin
andrewboyd Aug 29, 2006 8:51 AM (in response to andrewboyd)Peter you are the BOMB! I switched from utf-8 to latin1 and everything went as it should.
I'm thinking that I should open up a bug on jboss portal. It was all because a key used in the jbp_instance_per_user table was over 1000 bytes.
Thanks again for all of your help!
Andrew -
18. Re: Bad password for username=admin
nhatnam Aug 30, 2006 1:40 AM (in response to andrewboyd)Hi Peter,
If Hibernate create database successfully and smoothly, will the users (admin,user,etc.) be created in the table JBP_USERS ?
When i first run Jboss, the database with tables were created but the recordset of some tables such as JBP_USER, JBP_ROLES were all empty. Why?
THankyou -
19. Re: Bad password for username=admin
peterj Aug 30, 2006 10:59 AM (in response to andrewboyd)Did you read all of the posts in this thread? The answer is in there. ;-)
-
20. Re: Bad password for username=admin
ewernli Sep 14, 2006 5:58 PM (in response to andrewboyd)The following worked for me:
1) change the datasource according to the previous post:<connection-url>jdbc:mysql://localhost:3306/jbossportal?useServerPrepStmts=false&jdbcCompliantTruncation=false</connection-url>
but use the html entity instead for the & symbol, otherwise you will get error in your log saying that the datasource could not be loaded.
2) turn mysql in strict mode according to the previous post
3) delete default/log, default/data, default/tmp
4) clean your database (remove all tables) from the the unsucessfull install
5) use the proper driver: com.mysql.jdbc.Driver and not org.gjt.mm.mysql.Driver