LiveCycle Database Schema

[Elaine_Schmitz]

Can I see the livecycle database schema? I have the server loaded locally (on JBoss) and mySql. What is the name of the database? Thanks

[aoatak]

If you have a jboss-turnkey installation then you are having MySQL as the database. You can use MySQL GUI Tools from MySQL website to view the database schema and the data. Database name is "adobe".



Oguz

http://www.kgc.com.tr

[Elaine_Schmitz]

I loaded the mysql Administrator software from mysql.com, but I cannot connect to the server (the server is started - jboss turnkey).



Can I connect locally? When the software prompts you to log in, it defaults to port 3306, what should the correct port be?

[Elaine_Schmitz]

The livecycle server is using port 8080, does the mysql database use the same port? what is the default id and password?

[Former Community Member]

3306 is the default port for mySql. The userid is root and the password is what you set it to when you did the install. If you do not remember try no password.

[aoatak]

If you are trying to make remote connection review this blog post:

http://blogs.adobe.com/livecycle/2008/10/livecycle_es_turnkey_enabling.html



Oguz

http://www.kgc.com.tr

[Elaine_Schmitz]

Hey Paul,



Is the schema documented somewhere? I really just want to examine and understand what's in there (I'm a nosey developer ;-)



For some reason I am still having problems accessing the db through mysql, so I'd be just as happy to read a document describing it.



Thanks!

[Elaine_Schmitz]

Regarding the issue I was having about not being able to connect to the adobe system tables using mySQL, I found out the following:



The id and password and port are stored in the adobe-ds.xml file within the c:\Adobe\LiveCycle8.2\jboss\server\all\deploy directory.



Using mySQL administrator, on the initial prompt click the elipses next to the "Stored Connection" field and create a new connection using the port, id, and password specified in the file above.



I then received the message "either the server service or the configuration file could not be found. startup variables and service section are therefore disabled", which is addressed in this post:



http://michael.omnicypher.com/2008/11/mysql-configuration-with-adobe.html

[Elaine_Schmitz]

(I clicked post reply too soon )

As a result I am now able to connect successfully to the database and view the system tables.