No Database Connection Definitions

[IV/JG7_4Shades]

See http://seowhq.net/seowforum/viewtopic.php?t=921

If you have used the updater after that thread was last posted to, then you have a development MP that is inconsistent with SEDB60.

Cheers,
4S

[II/JG77Hawk_5]

Looks like your in a bit of trouble there Emil.

As you can longer auto update due to SEOW 7 development you can't bring the MP up to current specification that way.

You could try manually editing your Default-green.php and MP-connection.php but that is messy and I'm not sure if that is enough to get you up and running. What version default database do you have to go with the MP? Does it also have all the map updates required to function with the MP?

I have probably left out some key points but that is a start if your really keen to get up and running with something before SEOW 7.

Another idea would be if we got a current version of the MP zipped up for you and posted it on a file sharing site for you to download and then for you to grab a copy of a reference DB to suit.

[II/JG54_Emil]

O.K.


What a pitty
Gross was putting a fair effort into making this work.
And by the looks of it, I managed to fix it.

Do you recommed to redownload all stuff from http://sourceforge.net/projects/seow/files/ and reinstall to be fine?

Or do you think I can leave it as it is and go with the latest DCS?

[22GCT_Gross]

Hi Emil.
That worked if I linked your MP to the itaseow reference database.

Your 'SEOW' mysql user has been set to have the privileges onto the 'SEDB60\_Reference' database, however you have the 'SEDB60_Reference' database which your 'SEOW' user has no access on.

So you should:
1. create a new SEDB60\_Reference and copy there your SEDB60_Reference
OR
2. give all privileges to 'SEOW' user onto SEDB60_Reference

I'm going to remove the connection to itaseow database

[II/JG54_Emil]

But the only SEOW database that is there is SEDB60_Reference.
There really is no SEDB60\_Reference
...

[IV/JG7_4Shades]

The other option is to get a copy of the SEOW7 development DB (SEDB70_Reference) from me, which has the necessary map information to work with the development MP.

Cheers,
4S

[22GCT_Gross]

Now Emil has got my sedb60_reference.
Anyway the Jg54.org MP is working if connected to an external database, while it is not working when trying to connect to the mysql installed on the JG54 server machine (either as localhost, or 127.0.0.1 or jg54.org).
So it's something about the Mysql installation or Mysql settings.

[II/JG54_Emil]

Yes I am very interested in the Beta SEOW7.


But first of all we need to check why my mysql server is running, accessable with Navicat and phpMyAdmin.
The user has all rights including grant.
I also rebootet the mysql server after making all changes, but no success.


The onyl user that really runs the missionplaner correct is root.
I really have no clew whats wrong.

[II/JG54_Emil]

Does anyone use a Linux Server for his his MySQL database?

[II/JG54_Emil]

Unsolved mystery!

Only as root MP can access. (Even more interesting since Navicat cannot acces as root)
Any other user with the root rights can´t make the MP access the DB.

[IV/JG7_4Shades]

Then it looks like a MySQL user account problem.

[gec100]

Oy Emil.

not sure but i think this discussion has gone in wrong direction.

in this post u said that u have this error:

Code: Select all

Notice: Undefined index: Borneo in /var/www/SEOW/MP4public/Scripts/default-green.php on line 24 
Unknown database provider "".

and if understand it correctly for some other maps to. This is cause there are still missing maps for some sectors, and their references are missing in the database.

till those maps are done, you can use my dirty fix from here:

http://seowhq.net/seowforum/viewtopic.php?p=6473#6473

this will clear Undefined index errors, but those maps will still not work.

[II/JG54_Emil]

Thanks Gec.
Your help is appreciated.

Will give it a try.