Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

LiveCycle Database Schema

Avatar

Avatar
Validate 1
Level 4
Elaine_Schmitz
Level 4

Like

1 like

Total Posts

109 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 1
Affirm 1
View profile

Avatar
Validate 1
Level 4
Elaine_Schmitz
Level 4

Like

1 like

Total Posts

109 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 1
Affirm 1
View profile
Elaine_Schmitz
Level 4

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

Avatar

Avatar
Boost 1
Level 4
aoatak
Level 4

Like

1 like

Total Posts

105 posts

Correct Reply

0 solutions
Top badges earned
Boost 1
View profile

Avatar
Boost 1
Level 4
aoatak
Level 4

Like

1 like

Total Posts

105 posts

Correct Reply

0 solutions
Top badges earned
Boost 1
View profile
aoatak
Level 4

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

Avatar

Avatar
Validate 1
Level 4
Elaine_Schmitz
Level 4

Like

1 like

Total Posts

109 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 1
Affirm 1
View profile

Avatar
Validate 1
Level 4
Elaine_Schmitz
Level 4

Like

1 like

Total Posts

109 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 1
Affirm 1
View profile
Elaine_Schmitz
Level 4

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?

Avatar

Avatar
Validate 1
Level 4
Elaine_Schmitz
Level 4

Like

1 like

Total Posts

109 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 1
Affirm 1
View profile

Avatar
Validate 1
Level 4
Elaine_Schmitz
Level 4

Like

1 like

Total Posts

109 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 1
Affirm 1
View profile
Elaine_Schmitz
Level 4

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?

Avatar

Avatar
Boost 500
Level 10
pguerett
Level 10

Likes

612 likes

Total Posts

7,689 posts

Correct Reply

692 solutions
Top badges earned
Boost 500
Boost 50
Boost 5
Boost 3
Boost 250
View profile

Avatar
Boost 500
Level 10
pguerett
Level 10

Likes

612 likes

Total Posts

7,689 posts

Correct Reply

692 solutions
Top badges earned
Boost 500
Boost 50
Boost 5
Boost 3
Boost 250
View profile
pguerett
Level 10

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.

Avatar

Avatar
Boost 1
Level 4
aoatak
Level 4

Like

1 like

Total Posts

105 posts

Correct Reply

0 solutions
Top badges earned
Boost 1
View profile

Avatar
Boost 1
Level 4
aoatak
Level 4

Like

1 like

Total Posts

105 posts

Correct Reply

0 solutions
Top badges earned
Boost 1
View profile
aoatak
Level 4

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

Avatar

Avatar
Validate 1
Level 4
Elaine_Schmitz
Level 4

Like

1 like

Total Posts

109 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 1
Affirm 1
View profile

Avatar
Validate 1
Level 4
Elaine_Schmitz
Level 4

Like

1 like

Total Posts

109 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 1
Affirm 1
View profile
Elaine_Schmitz
Level 4

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!

Avatar

Avatar
Validate 1
Level 4
Elaine_Schmitz
Level 4

Like

1 like

Total Posts

109 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 1
Affirm 1
View profile

Avatar
Validate 1
Level 4
Elaine_Schmitz
Level 4

Like

1 like

Total Posts

109 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 1
Affirm 1
View profile
Elaine_Schmitz
Level 4

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

Avatar

Avatar
Validate 1
Level 4
Elaine_Schmitz
Level 4

Like

1 like

Total Posts

109 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 1
Affirm 1
View profile

Avatar
Validate 1
Level 4
Elaine_Schmitz
Level 4

Like

1 like

Total Posts

109 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 1
Affirm 1
View profile
Elaine_Schmitz
Level 4

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.