Highlighted

LiveCycle Database Schema

Avatar

Avatar

Elaine_Schmitz

Avatar

Elaine_Schmitz

Elaine_Schmitz

04-12-2008

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

Replies

Highlighted

Avatar

Avatar

aoatak

Avatar

aoatak

aoatak

05-12-2008

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
Highlighted

Avatar

Avatar

Elaine_Schmitz

Avatar

Elaine_Schmitz

Elaine_Schmitz

08-12-2008

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?
Highlighted

Avatar

Avatar

Elaine_Schmitz

Avatar

Elaine_Schmitz

Elaine_Schmitz

08-12-2008

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

Avatar

Avatar

pguerett

Total Posts

7.7K

Likes

611

Correct Answer

692

Avatar

pguerett

Total Posts

7.7K

Likes

611

Correct Answer

692
pguerett

08-12-2008

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.
Highlighted

Avatar

Avatar

aoatak

Avatar

aoatak

aoatak

08-12-2008

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
Highlighted

Avatar

Avatar

Elaine_Schmitz

Avatar

Elaine_Schmitz

Elaine_Schmitz

11-12-2008

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!
Highlighted

Avatar

Avatar

Elaine_Schmitz

Avatar

Elaine_Schmitz

Elaine_Schmitz

24-02-2009

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
Highlighted

Avatar

Avatar

Elaine_Schmitz

Avatar

Elaine_Schmitz

Elaine_Schmitz

24-02-2009

(I clicked post reply too soon )

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