OBEROn - Bug Trace - Oberon Platform
Viewing Issue Advanced Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
9 Database minor always 2010-02-04 17:03 2010-02-04 21:05
Reporter: mboffelli Platform:  
Assigned To: administrator OS:  
Priority: normal OS Version:  
Status: resolved Product Version:  
Product Build: Resolution: fixed  
Projection: none      
ETA: none Fixed in Version:  
Summary: 0000009: Error instaling on mysql
Description: When trying to install using "startdesign.bat" an error is displayed at the moment of database creation. Seems to be trying to create db schema in mysql but using oracle scripts. Attached see screen capture.
Steps To Reproduce:
Additional Information:
Relationships
Attached Files: jpg file icon error.JPG (attachment missing)
Issue History
Date Modified Username Field Change
2010-02-04 17:03 mboffelli New Issue
2010-02-04 17:03 mboffelli File Added: error.JPG
2010-02-04 17:17 administrator Status new => assigned
2010-02-04 17:17 administrator Assigned To => administrator
2010-02-04 17:23 administrator Note Added: 0000005
2010-02-04 17:28 administrator Note Added: 0000009
2010-02-04 17:37 mboffelli Note Added: 0000010
2010-02-04 17:41 administrator Note Added: 0000011
2010-02-04 17:44 administrator Note Edited: 0000011
2010-02-04 18:41 mboffelli Note Added: 0000012
2010-02-04 21:05 administrator Note Added: 0000013
2010-02-04 21:05 administrator Status assigned => resolved
2010-02-04 21:05 administrator Resolution open => fixed

Notes
(0000005)
administrator   
2010-02-04 17:23   
Which is your MySQL version?
Can the MySQL access to the file system root directory (/) and create files?
(0000009)
administrator   
2010-02-04 17:28   
Reminder sent to: mboffelli

Which is your MySQL version?
Can the MySQL access to the file system root directory (/) and create files?
(0000010)
mboffelli   
2010-02-04 17:37   
Mysql version 5.0.33
Second question, I asumme yes, is a production database server where other databases are currently running. Maybe it's missing some user creation or grant in the mysql db prior running creation scripts.
Although I insist, scripts are trying to run oracle commands, not mysql commands, as you can see in the capture, mysql hasn't got "tablespaces", it's oracle.
(0000011)
administrator   
2010-02-04 17:41   
(edited on: 2010-02-04 17:44)
Yes of course, MySQL hasn't the "tablespace" concept until the 5.1 version.
Minimum requirement for Oberon is MySQL 5.1.x; please read the installation guide:
http://www.imarche.net/oberon/install.php#mysql [^]

The MySQL 5.1 supports the InnoDB engine (with tablespaces) and transactions like Oracle
(0000012)
mboffelli   
2010-02-04 18:41   
Sorry, didn't notice about the difference between mysql versions.
Thanks & regards.
(0000013)
administrator   
2010-02-04 21:05   
Reminder sent to: mboffelli

Please open new issue if you need more help. We will replay you as soon as possible!