Hello everyone,
I've got a machine running Fedora 5. When I tried to install TimeTrex, in the Step 2 I got only error is: Database Engine: Invalid
Following is what timetrex.ini.php contains on this machine:
;
;
; TimeTrex Configuration File
; *Linux* Example
;
;
;
; System paths. NO TRAILING SLASHES!
;
[path]
;URL to TimeTrex web root directory. ie: http://your.domain.com/<*BASE_URL*>
;DO NOT INCLUDE http://your.domain.com, just the directory AFTER your domain
base_url = /timetrex/interface
;
;log directory
;
;Linux
log = /var/log/timetrex
;
;Misc storage, for attachments/images
;
;Linux
storage = /var/timetrex/storage
;
;Full path and name to the PHP CLI Binary
;
;Linux
php_cli = /usr/bin/php
;
; Database connection settings. These can be set from the installer.
;
[database]
type = mysql
;type = postgres8
host = localhost
database_name = timetrex
user = timetrex
password = timetrex
;
; Cache settings
;
[cache]
enable = TRUE
;Linux
dir = /tmp/timetrex
[debug]
;Set to false if you're debugging
production = TRUE
enable = FALSE
enable_display = FALSE
buffer_output = TRUE
enable_log = TRUE
verbosity = 10
[other]
; Force all clients to use SSL.
force_ssl = FALSE
installer_enabled = TRUE
primary_company_id = 0
;WARNING: DO NOT CHANGE THIS AFTER YOU HAVE INSTALLED TIMETREX.
;If you do it will cause all your passwords to become invalid,
;and you may lose access to some encrypted data.
salt = 0
I believe that, there is some issue with innoDB support for MySQL. Any suggestions?
Thanks in advance
Step 2, Database Engine: Invalid (Linux FC5)
Most likely InnoDB isn't enabled on your MySQL database server.
This may help:
http://www.experts-exchange.com/Databas ... 21250.html
This may help:
http://www.experts-exchange.com/Databas ... 21250.html
Thanks Shaun,
I tried to enable innoDB support for MySQL. Here is content of my.cnf file:
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
[mysql.server]
user=mysql
basedir=/var/lib
innodb_data_home_dir=/var/lib/mysql
innodb_data_file_path=ibdata9:100M:autoextend
set_variable=innodb_buffer_pool_size=100M
set-variable=innodb_additional_mem_pool_size=10M
innodb_flush_log_at_trx_commit=1
[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
Still no luck. Any suggestions?
Thanks.
I tried to enable innoDB support for MySQL. Here is content of my.cnf file:
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
[mysql.server]
user=mysql
basedir=/var/lib
innodb_data_home_dir=/var/lib/mysql
innodb_data_file_path=ibdata9:100M:autoextend
set_variable=innodb_buffer_pool_size=100M
set-variable=innodb_additional_mem_pool_size=10M
innodb_flush_log_at_trx_commit=1
[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
Still no luck. Any suggestions?
Thanks.
Ranveer.
It could be disabled at the command line or in some other configuration file specific to Fedora. You're best bet is to probably find a Fedora support forum somewhere and ask there.
Our MySQL test server here doesn't have any of those InnoDB lines in our my.cnf yet InnoDB still works fine.
You could always try PostgreSQL as well if you continue to have problems.
Our MySQL test server here doesn't have any of those InnoDB lines in our my.cnf yet InnoDB still works fine.
You could always try PostgreSQL as well if you continue to have problems.
Hey Shaun,
Thanks for reply
You're absolutely correct. I did this modification just after your first reply. Prior to that there were no specific lines for InnoDB, but I was able to create tables with innoDB support on MySQL prompt. After adding those InnoDB lines I can still create InnoDB Tables.
Thats the reason I'm wondering why TimeTrex throwing Invalid Database engine though I could create Table with InnoDB engine.
One other thing is making me wonder is, when I edited timetrex.ini.php and commented out the line specific to MySQL and uncommented Postgres one so I could use Postgres rather than MySQL. After that I restarted httpd process, but still it was spitting the same error to me....
Please please please...help me with this.......!!!
Thanks
Thanks for reply
You're absolutely correct. I did this modification just after your first reply. Prior to that there were no specific lines for InnoDB, but I was able to create tables with innoDB support on MySQL prompt. After adding those InnoDB lines I can still create InnoDB Tables.
Thats the reason I'm wondering why TimeTrex throwing Invalid Database engine though I could create Table with InnoDB engine.
One other thing is making me wonder is, when I edited timetrex.ini.php and commented out the line specific to MySQL and uncommented Postgres one so I could use Postgres rather than MySQL. After that I restarted httpd process, but still it was spitting the same error to me....
Please please please...help me with this.......!!!
Thanks
Ranveer.
That is your MySQL version.
Which PHP extensions do you have installed, ie:
php-mysql
php-pgsql
php-mysqli
php-pdo-pgsql
php-pdo-mysql
Of the above five extensions, the first two work the best, and only the first three work at all. But the error message you are receiving seems to tell us that you don't have any of the first three installed.
Which PHP extensions do you have installed, ie:
php-mysql
php-pgsql
php-mysqli
php-pdo-pgsql
php-pdo-mysql
Of the above five extensions, the first two work the best, and only the first three work at all. But the error message you are receiving seems to tell us that you don't have any of the first three installed.