Page 2 of 2

Posted: Fri 13 Dec 2013 8:32 am
by 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

Posted: Fri 13 Dec 2013 10:50 am
by 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.

Posted: Fri 13 Dec 2013 12:56 pm
by 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. :D

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?

Posted: Fri 13 Dec 2013 1:09 pm
by 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

Posted: Fri 13 Dec 2013 1:29 pm
by II/JG54_Emil
But the only SEOW database that is there is SEDB60_Reference.
There really is no SEDB60\_Reference
...
:?

Posted: Fri 13 Dec 2013 8:56 pm
by 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

Posted: Sat 14 Dec 2013 9:55 am
by 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.

Posted: Sat 14 Dec 2013 2:37 pm
by II/JG54_Emil
Yes I am very interested in the Beta SEOW7.
:D

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.

Posted: Sun 15 Dec 2013 8:31 am
by II/JG54_Emil
Does anyone use a Linux Server for his his MySQL database?

Posted: Sun 15 Dec 2013 9:15 pm
by 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.

Posted: Sun 15 Dec 2013 10:03 pm
by IV/JG7_4Shades
Then it looks like a MySQL user account problem.

Posted: Fri 20 Dec 2013 4:40 am
by 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.

Posted: Fri 20 Dec 2013 5:15 am
by II/JG54_Emil
Thanks Gec.
Your help is appreciated.

Will give it a try. :D