[SOLVED] eXpansion mysql problem

[LongLife]

Hey, I just wanted to try eXpansion controler...I did everything as written in tutorial on how to install but when I try to start it I get this:

Code: Select all

[2016-03-18T23:07:36+01:00]          There seems be a problem while establishing a MySQL connection.
[2016-03-18T23:07:36+01:00] 
[2016-03-18T23:07:36+01:00] Advanced details
[2016-03-18T23:07:36+01:00] File: Connection.php
[2016-03-18T23:07:36+01:00] Line: 72
[2016-03-18T23:07:36+01:00] Message: 

Hi, can you check if mysql or mysqli is enabled on your servers PHP settings?

It can't connect to your database so either you didn't install wamp/xampp properly and the mysql server hasn't started. Or cou didn't configure eXpansion properly and therfore it can't connect.

Please wright on the sub forum for eXpansion with more information. Which version you tried to install (stable(0.9.8.7) / beta(1.0.0.0))
Which version if PHP you have. and post all the logs as at startup eXPansion should run some checks and display some information about your configuraiton.

I first want to say that I have XAMPP and I used to run Xaseco...everything worked fine...and also I'm newbie at this...I just follow the instructions.

If you are asking if mysql is enabled in XAMPP Control Panel ? Then yes, it is enabled there.

I tried instaling latest stable version (0.9.8.7) of eXpansion.
I think I have PHP 5.6.12, not sure though...I went to c:\xampp\php\ and I right clicked php.exe to get to properties and I saw that version in details tab.

By eXpansion logs are you asking for logs from Server\logs\manialive-mysrvlogin.console.log ?
If yes than this is literally everything in that log:

Code: Select all

[2016-03-18T23:04:15+01:00]                                 ____                  _  
[2016-03-18T23:04:15+01:00]                                / __ \                | |
[2016-03-18T23:04:15+01:00]                               | |  | | ___  _ __  ___| |
[2016-03-18T23:04:15+01:00]                               | |  | |/ _ \|  _ \/ __| |
[2016-03-18T23:04:15+01:00]                               | |__| | (_) | |_) \__ \_|
[2016-03-18T23:04:15+01:00]                                \____/ \___/| .__/|___(_)
[2016-03-18T23:04:15+01:00]                                            | | 
[2016-03-18T23:04:15+01:00]                                            |_| 
[2016-03-18T23:04:15+01:00] 
[2016-03-18T23:04:15+01:00]          There seems be a problem while establishing a MySQL connection.
[2016-03-18T23:04:15+01:00] 
[2016-03-18T23:04:15+01:00] Advanced details
[2016-03-18T23:04:15+01:00] File: Connection.php
[2016-03-18T23:04:15+01:00] Line: 72
[2016-03-18T23:04:15+01:00] Message: 
[2016-03-18T23:04:15+01:00] 

Note, maybe worth mentioning...when I was editing php.ini (was following instructions from here)

"extension=php_curl.dll" didn't even had semicolon
I don't even have "php_sqlite" anywhere in my php.ini file and "php_sqlite3" was there and I removed semicolon
And for the "extension=php_openssl.dll" I already had that In extensions so I didn't add that.

[oliverde8]

Hi,

so if you ran XAseco before at least we know that mysql works fine on your computer.

I removed the sqllite thingy from the tutorial it doesn't need it.

What I meant with more logs is what it displays when it starts at the beginning. It should look like this :

Code: Select all

 _|      _|                      _|            _|        _|
 _|_|  _|_|    _|_|_|  _|_|_|          _|_|_|  _|            _|    _|    _|_|
 _|  _|  _|  _|    _|  _|    _|  _|  _|    _|  _|        _|  _|    _|  _|_|_|_|
 _|      _|  _|    _|  _|    _|  _|  _|    _|  _|        _|  _|  _|    _|
 _|      _|    _|_|_|  _|    _|  _|    _|_|_|  _|_|_|_|  _|    _|        _|_|_|
-----------------------------------------------------
PHP Environment Compatibility Test
-----------------------------------------------------
PHP 5.3.1 or newer    -> required  -> [ Yes ] 5.5.12
Standard PHP Library  -> required  -> [ Yes ]
JSON                  -> required  -> [ Yes ]
cURL with SSL         -> required  -> [ Yes ] 7.36.0 (with OpenSSL/1.0.1g)
MySQL                 -> optional  -> [ Yes ]
SQLite3               -> optional  -> [ Yes ]
-----------------------------------------------------
Running ManiaLive 4.0.0...

As you can see that will show you the php version and other compatibility situations. In your case this should be ok because you have passed the step.

The issue is surely with your config.ini file. More specifically this part :

Code: Select all

; Connection configuration
database.host = '127.0.0.1'
database.port = 3306
database.username = 'exp_server1'
database.password = '123456'         ;bad exemple
database.database = 'exp_server1'

You need to connect to your phpmyadmin interface create a new DB for eXpansion :
https://github.com/eXpansionPluginPack/ ... dows#mysql

Then configure those options with the username database & password you have set up. host & port should't change normally.

Good luck

[LongLife]

Hi,

so if you ran XAseco before at least we know that mysql works fine on your computer.

I removed the sqllite thingy from the tutorial it doesn't need it.

What I meant with more logs is what it displays when it starts at the beginning. It should look like this :

Code: Select all

 _|      _|                      _|            _|        _|
 _|_|  _|_|    _|_|_|  _|_|_|          _|_|_|  _|            _|    _|    _|_|
 _|  _|  _|  _|    _|  _|    _|  _|  _|    _|  _|        _|  _|    _|  _|_|_|_|
 _|      _|  _|    _|  _|    _|  _|  _|    _|  _|        _|  _|  _|    _|
 _|      _|    _|_|_|  _|    _|  _|    _|_|_|  _|_|_|_|  _|    _|        _|_|_|
-----------------------------------------------------
PHP Environment Compatibility Test
-----------------------------------------------------
PHP 5.3.1 or newer    -> required  -> [ Yes ] 5.5.12
Standard PHP Library  -> required  -> [ Yes ]
JSON                  -> required  -> [ Yes ]
cURL with SSL         -> required  -> [ Yes ] 7.36.0 (with OpenSSL/1.0.1g)
MySQL                 -> optional  -> [ Yes ]
SQLite3               -> optional  -> [ Yes ]
-----------------------------------------------------
Running ManiaLive 4.0.0...

As you can see that will show you the php version and other compatibility situations. In your case this should be ok because you have passed the step.

The issue is surely with your config.ini file. More specifically this part :

Code: Select all

; Connection configuration
database.host = '127.0.0.1'
database.port = 3306
database.username = 'exp_server1'
database.password = '123456'         ;bad exemple
database.database = 'exp_server1'

You need to connect to your phpmyadmin interface create a new DB for eXpansion :
https://github.com/eXpansionPluginPack/ ... dows#mysql

Then configure those options with the username database & password you have set up. host & port should't change normally.

Good luck

Ok I fixed it...
Yeap, I did setup DB and config.ini but I made database with the same name as username but username had two capital letters but DB that was auto created didn't had capital letters and I forgot that I had capital letters in my username so in config.ini I put everything in lower case

Thanks for the help !

I have two more question...is it hard now to upgrade to 1.0.0 beta version from this stable version ?
And what is the plugin that compares my live cp times with 1st dedi time ?

[oliverde8]

Thanks for the help !

I have two more question...is it hard now to upgrade to 1.0.0 beta version from this stable version ?
And what is the plugin that compares my live cp times with 1st dedi time ?

Hey good news,

For the update I think you should wait the stable release. The current release is a beta is a bit complicated to install as we didn't pack everything in it. When it is ready it will be easy to update. Just download copy old configs in the new install and run.

You are probably looking for the "Widget: Checkpoint Times" plugin

[LongLife]

Thanks for the help !

I have two more question...is it hard now to upgrade to 1.0.0 beta version from this stable version ?
And what is the plugin that compares my live cp times with 1st dedi time ?

Hey good news,

For the update I think you should wait the stable release. The current release is a beta is a bit complicated to install as we didn't pack everything in it. When it is ready it will be easy to update. Just download copy old configs in the new install and run.

You are probably looking for the "Widget: Checkpoint Times" plugin

Oh, ok, I'll wait then.

I don't see that feature when I enable Checkpoint Times...
I'm talking about plugin that says (when you go through the checkpoint) how much you are in + or - compared to the 1st record (not your pb)

Does eXpansion allow 3rd party plugins ? If yes where can I download them ?

[LongLife]

Ok, I see it now...I shut the server completely and restarted it and everything is there now.

Thanks for the help.

[oliverde8]

Skipping the map or rejoining the server would probably been enought I think

or /admin manialive restart command to restart eXpansion.

Does eXpansion allow 3rd party plugins ? If yes where can I download them ?

yes it does but sadly there are only 4 of them. So we didn't built something to list them.

One is for rounds mode,
One is a demo plugin for people to learn how to code for eXpansion
and the 2 other are specificly built for some competitions.