I’'m having some trouble working out the proper configuration to authenticate the username and password to my existing userdatabase. I am currently working on a scratch copy on my local machine. I downloaded the latest version today. I ran through the installation and made sure that everything worked, before setting about the task of trying to configure the XML file.
This is what I came up with, after looking at other configurations.
This is the beginning of the errors I received after trying it out.
ERROR 11756 (): Error reading XML properties
org.dom4j.DocumentException: Error on line 89 of document : The entity “dbpass” was referenced, but not declared. Nested exception: The entity “dbpass” was referenced, but not declared.
at org.dom4j.io.SAXReader.read(SAXReader.java:482)
at org.dom4j.io.SAXReader.read(SAXReader.java:365)
at org.jivesoftware.util.XMLProperties.buildDoc(XMLProperties.java:464)
at org.jivesoftware.util.XMLProperties.(XMLProperties.java:112)
I’‘m not really good at this, so forgive me if I’'ve totally screwed things up.
User information resides in the
phpizabi_users Table
username is the username field within the phpizabi_users table
password is the password field inside the phpizabi_users table
email is the email field inside the phpizabi_users table
Let me know if there’'s any other information I can provide.
Hello, i am not sure but i think your Problem ist this line:
<connectionString>jdbc:mysql://localhost/database?user=dbuser&dbpass;=pass word</connectionString>
Replace the “&” between “dbuser” and “dbpass” with “& a m p;”. (Without the spaces between the charakters, it seems that you cant post html code in this forum)
Also delete the “;” after “dbpass”.
try this:
<connectionString>jdbc:mysql://localhost/database?user=dbuser& a m p;dbpass=password</connectionString>
Let me know if it solves your Problem.
Message was edited by: nachtspion
I tried this line after your suggestion
This was the error that I received
ERROR 11756 (): Error reading XML properties
org.dom4j.DocumentException: Error on line 89 of document : The entity name must immediately follow the ‘’&’’ in the entity reference. Nested exception: The entity name must immediately follow the ‘’&’’ in the entity reference.
at org.dom4j.io.SAXReader.read(SAXReader.java:482)
at org.dom4j.io.SAXReader.read(SAXReader.java:365)
at org.jivesoftware.util.XMLProperties.buildDoc(XMLProperties.java:464)
at org.jivesoftware.util.XMLProperties.
your wrote “…dbpass&=password”
Dont use the “&” together with “=”
Be sure you use “& a m p ;” an not “&”
I wish I could post without the forum changing the stuff we put into post.
I did place the “amp” where you suggested to place it. The forum changed it to a “&” when I posted here.
perhaps if you emailed me.
will.watson@earthlink.net
it would be easier to pass the proper information back and forth.