<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>Joe...<br>
<br>
I am NOT a MySQL expert by any means, (someone who is, please chime in)
but...<br>
If you do a SHOW DATABASES in MySQL do you see at least the following
databases?</tt><br>
<tt>(by the way, I am running this in Ubuntu 7.10 using MySQL Ver 14.12
Distrib 5.0.45)<br>
<br>
mysql> SHOW DATABASES;</tt><br>
<tt>+--------------------+</tt><br>
<tt>| Database |</tt><br>
<tt>+--------------------+</tt><br>
<tt>| information_schema | </tt><br>
<tt>| mysql | </tt><br>
<tt>| opensim | </tt><br>
<tt>+--------------------+<br>
<br>
And if you do the following, do you see the same thing?<br>
<br>
mysql> USE information_schema;<br>
Database changed<br>
mysql> SHOW TABLES;<br>
+---------------------------------------+<br>
| Tables_in_information_schema |<br>
+---------------------------------------+<br>
| CHARACTER_SETS | <br>
| COLLATIONS | <br>
| COLLATION_CHARACTER_SET_APPLICABILITY | <br>
| COLUMNS | <br>
| COLUMN_PRIVILEGES | <br>
| KEY_COLUMN_USAGE | <br>
| PROFILING | <br>
| ROUTINES | <br>
| SCHEMATA | <br>
| SCHEMA_PRIVILEGES | <br>
| STATISTICS | <br>
| TABLES | <br>
| TABLE_CONSTRAINTS | <br>
| TABLE_PRIVILEGES | <br>
| TRIGGERS | <br>
| USER_PRIVILEGES | <br>
| VIEWS | <br>
+---------------------------------------+<br>
17 rows in set (0.00 sec)<br>
<br>
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 </tt><tt>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.<br>
<br>
<br>
I hope this helps.....Fish<br>
</tt><tt>btw, if you're in Second Life, I'm in there too. My avatar's
name is....Fish Kungfu.<br>
<br>
<br>
<br>
<br>
</tt><tt>Joe Greene wrote:</tt>
<blockquote
cite="mid:20080310174238.9sne3gt80so8og8w@www.greenemyst.com"
type="cite"><tt>
Thanks That got rid of the sqlite complaints.. of course, now I've<br>
a new error.. which makes me think my MySQL DB may be damaged.<br>
<br>
Exception: MySql.Data.MySqlClient.MySqlException: Table<br>
'INFORMATION_SCHEMA.TABLES' doesn't exist<br>
<br>
Has anyone seen that error?<br>
<br>
<span class="signature">-- <br>
Joe Greene<br>
UNIX Systems, Network and IT Specialist<br>
If you aren't having fun, you're doing the wrong thing!<br>
All opinions expressed are mine alone. You Can't Have them!<br>
</span></tt>
<br>
<tt>Fish Kungfu <a class="moz-txt-link-rfc2396E" href="mailto:fish.kungfu@earthlink.net"><fish.kungfu@earthlink.net></a> wrote:<br>
<br>
> Below is my OpenSim.ini file for using MySQL running in standalone
mode<br>
> for 0.5.0, with MySQL on the same box as opensim. You will need
to put<br>
> your password for MySQL root user, or whatever user you're using.
I had<br>
> to create the empty database, "opensim" before everything would
work.<br>
> Then, remember to GRANT ALL privileges to your userName for the
opensim<br>
> database, and then FLUSH PRIVILEGES.<br>
><br>
> I had to add these lines to the example file that came with the<br>
> installer to make it work. This tripped me up, and caused the
SQLite<br>
> activity in the log at startup. They are included in my
OpenSim.ini
below<br>
> asset_database = "mysql"<br>
> asset_plugin = "OpenSim.Framework.Data.MySQL.dll"<br>
><br>
> I hope this helps.....Fish<br>
[snip]<br>
><br>
><br>
> Joe Greene wrote:<br>
>><br>
>> Problem Desc: Opensim [ASSET SERVER] appear to be attempting
to open<br>
>> and SQLitew database althoguh no such reference appears (even
in<br>
>> comments) in my OpenSim.ini file. As I'm using MySQL (both the<br>
>> OpenSim.ini and the mysql_connection.ini) I have no SQLite
installed.<br>
>> Any suggestions on what I'm doing wrong, or shall I submit my
OpenSim.ini<br>
>><br>
>> Version Info:<br>
>> SuSe Enterprise 9.3 ( with updates )<br>
>> Mono: Mono JIT compiler version 1.2.6 (Installed via YAST from
Mono
Site)<br>
>> MySQL: 4.1.10a<br>
>><br>
>> libode 0.9-25<br>
>><br>
>> Console Log:<br>
>><br>
>> opensim@opensim1:~/bin> mono OpenSim.exe<br>
>> OpenSim 0.5, SVN build<br>
><br>
<br>
</tt>
<br>
<tt><br>
</tt>
<hr size="4" width="90%"><tt><br>
_______________________________________________<br>
Opensim-users mailing list<br>
<a class="moz-txt-link-abbreviated" href="mailto:Opensim-users@lists.berlios.de">Opensim-users@lists.berlios.de</a><br>
<a class="moz-txt-link-freetext" href="https://lists.berlios.de/mailman/listinfo/opensim-users">https://lists.berlios.de/mailman/listinfo/opensim-users</a><br>
</tt></blockquote>
<p></p>
</body>
</html>