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

[Joe Greene]

   Bingo.. I believe you've hit it. I'll check my other DBs (I'm no  
DBA myself) and with my DBA at work (benefits of being I.T.).

-- 
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:

> 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/f4419995/attachment.html>