[csw-users] Problems with RT installation

[Willie Bollinger]

I copied the default file and I am still getting the same error.

Here is the output of show engines

| InnoDB     | DEFAULT | Supports transactions, row-level locking, and 
foreign keys |
| INNOBASE   | YES     | Alias for INNODB 



Here is the output for the variables

| innodb_additional_mem_pool_size | 2097152 
                     |
| innodb_autoextend_increment     | 8 
                     |
| innodb_buffer_pool_awe_mem_mb   | 0 
                     |
| innodb_buffer_pool_size         | 16777216 
                     |
| innodb_data_file_path           | ibdata1:10M:autoextend 
                     |
| innodb_data_home_dir            | /opt/csw/mysql4/var/ 
                     |
| innodb_fast_shutdown            | ON 
                     |
| innodb_file_io_threads          | 4 
                     |
| innodb_file_per_table           | OFF 
                     |
| innodb_flush_log_at_trx_commit  | 1 
                     |
| innodb_flush_method             | 
                     |
| innodb_force_recovery           | 0 
                     |
| innodb_lock_wait_timeout        | 50 
                     |
| innodb_locks_unsafe_for_binlog  | OFF 
                     |
| innodb_log_arch_dir             | /opt/csw/mysql4/var/ 
                     |
| innodb_log_archive              | OFF 
                     |
| innodb_log_buffer_size          | 8388608 
                     |
| innodb_log_file_size            | 5242880 
                     |
| innodb_log_files_in_group       | 2 
                     |
| innodb_log_group_home_dir       | /opt/csw/mysql4/var/ 
                     |
| innodb_max_dirty_pages_pct      | 90 
                     |
| innodb_max_purge_lag            | 0 
                     |
| innodb_mirrored_log_groups      | 1 
                     |
| innodb_open_files               | 300 
                     |
| innodb_table_locks              | ON 
                     |
| innodb_thread_concurrency       | 8 



And here are the entries in our my.cnf file


# Uncomment the following if you are using InnoDB tables
innodb_data_home_dir = /opt/csw/mysql4/var/
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = /opt/csw/mysql4/var/
innodb_log_arch_dir = /opt/csw/mysql4/var/
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
innodb_buffer_pool_size = 16M
innodb_additional_mem_pool_size = 2M
# Set .._log_file_size to 25 % of buffer pool size
innodb_log_file_size = 5M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50








Alex Moore wrote:
> On Wed, 30 Aug 2006 11:03:44 -0400
> Willie Bollinger <willie at qis.net> wrote:
> 
>> Transactions not supported by database
>> at /opt/csw/lib/perl/csw/DBI.pm line 1657.
>>
>>
>> I have looked at the mysql configuration and it should be set up for 
>> innodb tables. Any idea what the problem is here?
> 
> Log into mysql.  'show engines;' should show INNOBASE with support =
> yes.
> 
> Also, from a shell; `mysqladmin variables` should show a lot of innodb
> variables and values, such as:
> | innodb_data_file_path | ibdata1:3500M:autoextend
> |
> | innodb_data_home_dir  | /opt/csw/mysql4/var/ 
> 
> Is this what you see?  If not,
> copy /opt/csw/mysql4/share/mysql/my-medium.cnf to
> /opt/csw/mysql4/var/my.cnf and uncomment the variables in the innodb
> section and restart mysql.
> 
> Alex
> 

-- 
-------------------------------------------------------------------------
     Willie Bollinger      | 2975B Manchester Rd. | E-Mail: willie at qis.net
Quantum Internet Services | Manchester, MD 21102 |  Voice: 410-239-6920 

-------------------------------------------------------------------------