v10.05.27 install error
tipsimagi
12-12-2010 02:47:21
Total noob here attempting to install for the first time.
On Fedora 12
* apache 2.2-15-1
* php 5.3-1
* adodb installed
* odbc installed
* mbstring installed
Prerequisite checks
PHP version > 4.1: Yes
Has GMP support: Yes
Has mbstring support: Yes
/var/www/html/ona/www/local/config dir writable by '': Yes
Connected to 'localhost' as 'root'.
Dropped existing instance of 'ona_default'.
Created new database 'ona_default'.
Selected existing DB: 'ona_default'.
There was an error processing tables.
Specified key was too long; max key length is 1000 bytes
There was a fatal error. Install may be incomplete. Fix the issue and try again
Any help would be greatly appreciated.
Best wishes,
TipsiMagi
On Fedora 12
* apache 2.2-15-1
* php 5.3-1
* adodb installed
* odbc installed
* mbstring installed
Prerequisite checks
PHP version > 4.1: Yes
Has GMP support: Yes
Has mbstring support: Yes
/var/www/html/ona/www/local/config dir writable by '': Yes
Connected to 'localhost' as 'root'.
Dropped existing instance of 'ona_default'.
Created new database 'ona_default'.
Selected existing DB: 'ona_default'.
There was an error processing tables.
Specified key was too long; max key length is 1000 bytes
There was a fatal error. Install may be incomplete. Fix the issue and try again
Any help would be greatly appreciated.
Best wishes,
TipsiMagi
tipsimagi
12-12-2010 19:11:47
# diff -u ona-table_schema.xml.org ona-table_schema.xml
--- ona-table_schema.xml.org 2010-12-12 16:53:57.034103002 -0600
+++ ona-table_schema.xml 2010-12-12 16:53:30.867124252 -0600
@@ -162,8 +162,8 @@
<field name="primary_host_id" type="I" size="10">
<NOTNULL/>
</field>
- <field name="asset_tag" type="C" size="255"/>
- <field name="serial_number" type="C" size="255"/>
+ <field name="asset_tag" type="C" size="166"/>
+ <field name="serial_number" type="C" size="166"/>
<index name="asset_tag">
<UNIQUE/>
<col>asset_tag</col>
ok so the following diff fixed the install but now i can't login as anything other than admin.
tipsimagi
12-12-2010 19:14:46
sry change the above value from 166 to 165 and it finally works, but still cannot login as anything but guest.
Matt
04-01-2011 16:09:59
Just curious if you got things working on this. You were on to the right thing by adjusting the install schema stuff.. I have however done a slightly different change by removing the indexes that were created on that table. they were not actually supposed to be there.
Anyway, the fix is in subversion now and should be available in the next release.
Let me know if there are still issues on this.
Thanks for the report!
Anyway, the fix is in subversion now and should be available in the next release.
Let me know if there are still issues on this.
Thanks for the report!