[Opensim-users] OpenSim 0.5.1 Release won't start

[Fish Kungfu]

Joe...

I am NOT a MySQL expert by any means, (someone who is, please chime in)
but...
If you do a SHOW DATABASES in MySQL do you see at least the following
databases?
(by the way, I am running this in Ubuntu 7.10 using MySQL Ver 14.12
Distrib 5.0.45)

mysql> SHOW DATABASES;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| opensim            |
+--------------------+

And if you do the following, do you see the same thing?

mysql> USE information_schema;
Database changed
mysql> SHOW TABLES;
+---------------------------------------+
| Tables_in_information_schema          |
+---------------------------------------+
| CHARACTER_SETS                        |
| COLLATIONS                            |
| COLLATION_CHARACTER_SET_APPLICABILITY |
| COLUMNS                               |
| COLUMN_PRIVILEGES                     |
| KEY_COLUMN_USAGE                      |
| PROFILING                             |
| ROUTINES                              |
| SCHEMATA                              |
| SCHEMA_PRIVILEGES                     |
| STATISTICS                            |
| TABLES                                |
| TABLE_CONSTRAINTS                     |
| TABLE_PRIVILEGES                      |
| TRIGGERS                              |
| USER_PRIVILEGES                       |
| VIEWS                                 |
+---------------------------------------+
17 rows in set (0.00 sec)

Like I said, I'm NOT a MySQL expert, so if you don't see the above there
may be a way to repair or recover your information_schema.  It may be as
easy as re-installing MySQL, depending on how many other database you
have to backup, etc so you don't lose any existing data.


I hope this helps.....Fish
btw, if you're in Second Life, I'm in there too.  My avatar's name
is....Fish Kungfu.




Joe Greene wrote:
> Thanks That got rid of the sqlite complaints.. of course, now I've
> a new error.. which makes me think my MySQL DB may be damaged.
>
> Exception: MySql.Data.MySqlClient.MySqlException: Table
> 'INFORMATION_SCHEMA.TABLES' doesn't exist
>
> Has anyone seen that error?
>
> -- 
> Joe Greene
> UNIX Systems, Network and IT Specialist
> If you aren't having fun, you're doing the wrong thing!
> All opinions expressed are mine alone. You Can't Have them!
>
> Fish Kungfu <fish.kungfu at earthlink.net> wrote:
>
> > Below is my OpenSim.ini file for using MySQL running in standalone mode
> > for 0.5.0, with MySQL on the same box as opensim.  You will need to put
> > your password for MySQL root user, or whatever user you're using.  I had
> > to create the empty database, "opensim" before everything would work.
> > Then, remember to GRANT ALL privileges to your userName for the opensim
> > database, and then FLUSH PRIVILEGES.
> >
> > I had to add these lines to the example file that came with the
> > installer to make it work.  This tripped me up, and caused the SQLite
> > activity in the log at startup.  They are included in my OpenSim.ini
> below
> >    asset_database = "mysql"
> >    asset_plugin = "OpenSim.Framework.Data.MySQL.dll"
> >
> > I hope this helps.....Fish
> [snip]
> >
> >
> > Joe Greene wrote:
> >>
> >> Problem Desc: Opensim [ASSET SERVER] appear to be attempting to open
> >> and SQLitew database althoguh no such reference appears (even in
> >> comments) in my OpenSim.ini file. As I'm using MySQL (both the
> >> OpenSim.ini and the mysql_connection.ini) I have no SQLite installed.
> >> Any suggestions on what I'm doing wrong, or shall I submit my
> OpenSim.ini
> >>
> >> Version Info:
> >> SuSe Enterprise 9.3 ( with updates )
> >> Mono: Mono JIT compiler version 1.2.6 (Installed via YAST from Mono
> Site)
> >> MySQL: 4.1.10a
> >>
> >> libode 0.9-25
> >>
> >> Console Log:
> >>
> >> opensim at opensim1:~/bin> mono OpenSim.exe
> >> OpenSim 0.5, SVN build
> >
>
>
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> Opensim-users mailing list
> Opensim-users at lists.berlios.de
> https://lists.berlios.de/mailman/listinfo/opensim-users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://opensimulator.org/pipermail/opensim-users/attachments/20080310/12b3fdcb/attachment.html>