Macromedia live cycle 7.2 매뉴얼

Installing and Configuring LiveCycle for JBoss

 Creating an Oracle database     43

The MySQL user account that you create requires these privileges to access the tables in the LiveCycle 
database:

●

SELECT

●

INSERT

●

UPDATE

●

DELETE

●

CREATE

●

DROP

●

REFERENCES

●

INDEX

●

ALTER

●

CREATE_TMP_TABLE

●

LOCK_TABLES

To prevent issues from occurring when uploading large files to MySQL, you must set the maximum 
allowed communication packet size to 25 MB. You can set this property in the MySQL my.ini file (Windows) 
or my.cnf file (Linux). For more information about the maximum allowed communication packet size 
property in MySQL, see 

If your MySQL installation does not include a my.ini or my.cnf file, you must create one. For information 
about the location of the file or how to create the file, see the MySQL documentation.

➤

1. Open the my.ini (Windows) or my.cnf (Linux) file in a text editor.

2. Add the following line to the 

[mysqld]

 section: 

max_allowed_packet=25M

3. Save and close the file.

If you prefer not to use the default database that was created when you installed Oracle 9i or 10g, create a 
new database using the Database Configuration Assistant tool. 

If any of the LDAP directories that the new database will synchronize with for authenticating LiveCycle 
users includes records with UTF-8 characters, you must create a database that uses the UTF-8 character set.

You must also create a new user on the database and assign it the DBA, CONNECT and RESOURCE roles, as 
well as the ACCESS_ANY_WORKSPACE, UNLIMITED TABLESPACE, and CREATE VIEW system privileges. For 
deployments on Linux, the user name must not exceed 8 characters and, on Windows, it must not exceed 
12 characters.