The database in Eucalyptus

The database used in Eucalyptus is hsqldb.

The hsqldb-1.8.0.10 version is used in eucalyptus-2.0.2.

HSQLDB Home: http://hsqldb.org/

HSQLDB is an open source Java database with standard SQL syntax and Java interfaces that are free to use and distribute, very concise and fast. has three kinds of server mode, in-process mode (in-process) and memory mode (MEMORY-ONLY). Running HSQLDB requires a Hsqldb.jar package that contains a number of components and programs.

The Eucalyptus database is in/var/lib/eucalyptus/db, and the experimental methods are as follows:

Copy the files from the/var/lib/eucalyptus/db and replace them in the *.script file

CREATE USER SA PASSWORD "83jfi86fsdkj3987jf99374hhf7kj38f83lf8elj8f4lj ..." The string after the password is "", that is, the password is cleared. Because the Eucalyptus default sa password is too long, if used directly will cause validation to fail, you can clear the password first.

Copy Eucalyptus source Eucalyptus-2.0.2/clc/lib/hsqldb-1.8.0.10.jar file to just copy out of the database file directory.

Enter the following command to run (Java 1.6)

$ JAVA-CP Hsqldb-1.8.0.10.jar Org.hsqldb.util.DatabaseManager

Pop-up connection interface, select Standalone Type,url to fill in the database name, such as Jdbc:hsqldb:file:eucalyptus_auth. After the connection is successful, you can enter the SQL statement execution in the input box.

You can also see the tables and their fields in the database.