Allowing flux cp to connect to VPS

[_jx]

Good evening to all, does anybody here have an idea why flux is displaying this error?

Message: [i]SQLSTATE[28000] [1045] Access denied for user 'root'@'xxx.xxx.x.x' (using password: YES)[/i]

From what can I see, VPS is blocking flux. Any workaround to let the Fluxcp touch the vps? I'm finding solution for about 14 hours ++ now. The webhost is not replying at all, so I guess asking here won't hurt.

Anyone? Thanks in advance!

Edited April 14, 2012 by hao

[ManokStreZ]

On 6/21/2012 at 11:24 AM, Ainna said:

Having the same problem but cannot fix it Q_Q

After hours now I simply give up.

 

Critical Error
An error was encountered during the lifetime of the application.
This could be due to a variety of problems, such as a bug in the application.
However, normally it is caused by misconfiguration.
Exception Details
Error: PDOException
Message: SQLSTATE[28000] [1045] Access denied for user 'root'@'localhost' (using password: YES)
File: /var/www/control/lib/Flux/Connection.php:81
File  Line  Function/Method
/var/www/control/lib/Flux/Connection.php  81  PDO::__construct()
/var/www/control/lib/Flux/Connection.php  94  Flux_Connection::connect()
/var/www/control/lib/Flux/Connection.php  159  Flux_Connection::getConnection()
/var/www/control/modules/install/index.php  17  Flux_Connection::getStatement()
/var/www/control/lib/Flux/Template.php  337  include()
/var/www/control/lib/Flux/Dispatcher.php  168  Flux_Template::render()
/var/www/control/index.php  177  Flux_Dispatcher::dispatch()
Exception Trace As String
#0 /var/www/control/lib/Flux/Connection.php(81): PDO->__construct(*hidden*)
#1 /var/www/control/lib/Flux/Connection.php(94): Flux_Connection->connect(Object(Flux_Config))
#2 /var/www/control/lib/Flux/Connection.php(159): Flux_Connection->getConnection()
#3 /var/www/control/modules/install/index.php(17): Flux_Connection->getStatement('SELECT VERSION(...')
#4 /var/www/control/lib/Flux/Template.php(337): include('/var/www/contro...')
#5 /var/www/control/lib/Flux/Dispatcher.php(168): Flux_Template->render()
#6 /var/www/control/index.php(177): Flux_Dispatcher->dispatch(Array)
#7 {main}

 

 

Is what i get all the time.

The funny part is: I am not using 'root'@'localhost'... I am still at the beginning of the installation process. I use the secret password, put in my mysql user + pw click on the update button and nothing works (get this error all the time).

I am on a VPS. I have a mysql user with ALL PRIVILEGES and @myvpshostip. But it wont work because the cp uses the [email protected]

>_____>

Is this a bug? Does it really use [email protected]? Or is it just showing it for no real reason?

My PHP works and PDO is enabled. SQL connection works too. ( rAthena Server is running and i can connect without any problems ).

Any help would be really appreciated!

Edit: Also tried other versions of flux but nothing seems to help.

Update:

I´ve set the root password to none wich lead the cp to use my other sql user but still no success.

I dont get it...

Update2: Finally it works.... I dont know how i did it but i did it...

Update3: Nope it does not! >_>

can you tell me how you fix it ? almost 2 days my problem not solved

[Brian]

On your VPS, you have to create a MySQL user/password that is allowed to connect from the IP of your webhost.

Then in your FluxCP config, set the MySQL user/pass that you just created.

[_jx]

On your VPS, you have to create a MySQL user/password that is allowed to connect from the IP of your webhost.

I know how to allow a [email protected], but IP? Could you please explain further?

Can I bump this please?

EDIT:

Fixed!!

The solution is, you need to grant [email protected]

[Ainna]

Having the same problem but cannot fix it Q_Q

After hours now I simply give up.

Critical Error
An error was encountered during the lifetime of the application.
This could be due to a variety of problems, such as a bug in the application.
However, normally it is caused by misconfiguration.
Exception Details
Error: PDOException
Message: SQLSTATE[28000] [1045] Access denied for user 'root'@'localhost' (using password: YES)
File: /var/www/control/lib/Flux/Connection.php:81
File  Line  Function/Method
/var/www/control/lib/Flux/Connection.php  81  PDO::__construct()
/var/www/control/lib/Flux/Connection.php  94  Flux_Connection::connect()
/var/www/control/lib/Flux/Connection.php  159  Flux_Connection::getConnection()
/var/www/control/modules/install/index.php  17  Flux_Connection::getStatement()
/var/www/control/lib/Flux/Template.php  337  include()
/var/www/control/lib/Flux/Dispatcher.php  168  Flux_Template::render()
/var/www/control/index.php  177  Flux_Dispatcher::dispatch()
Exception Trace As String
#0 /var/www/control/lib/Flux/Connection.php(81): PDO->__construct(*hidden*)
#1 /var/www/control/lib/Flux/Connection.php(94): Flux_Connection->connect(Object(Flux_Config))
#2 /var/www/control/lib/Flux/Connection.php(159): Flux_Connection->getConnection()
#3 /var/www/control/modules/install/index.php(17): Flux_Connection->getStatement('SELECT VERSION(...')
#4 /var/www/control/lib/Flux/Template.php(337): include('/var/www/contro...')
#5 /var/www/control/lib/Flux/Dispatcher.php(168): Flux_Template->render()
#6 /var/www/control/index.php(177): Flux_Dispatcher->dispatch(Array)
#7 {main}

Is what i get all the time.

The funny part is: I am not using 'root'@'localhost'... I am still at the beginning of the installation process. I use the secret password, put in my mysql user + pw click on the update button and nothing works (get this error all the time).

I am on a VPS. I have a mysql user with ALL PRIVILEGES and @myvpshostip. But it wont work because the cp uses the [email protected]

>_____>

Is this a bug? Does it really use [email protected]? Or is it just showing it for no real reason?

My PHP works and PDO is enabled. SQL connection works too. ( rAthena Server is running and i can connect without any problems ).

Any help would be really appreciated!

Edit: Also tried other versions of flux but nothing seems to help.

Update:

I´ve set the root password to none wich lead the cp to use my other sql user but still no success.

I dont get it...

Update2: Finally it works.... I dont know how i did it but i did it...

Update3: Nope it does not! >_>

Edited June 21, 2012 by Ainna

[Asura]

Hi Ainna,

I would recommend deleting all your FluxCP files, and re-inserting a fresh copy. Then go into your SQL database, make sure all the 'cp_*' tables are dropped and do not exist in your RO database.

After that, edit the '/config/error.php' to true for error reporting.

Edit the '/config/application.php' to have the correct location and server name.

Edit the '/config/servers.php' to have the correct MySQL information, also whether you're using MD5 or not.

Then visit your FluxCP via browser, set all necessary permissions if it states it; and then proceed to install. It should work.

[Ainna]

Thank you Asura for your reply!

Sorry I didn´t update my post but I already solved it.

I still don´t really know what caused the error. But simply deleting my sql users and recreating + updating the servers.php resolved the problem. It made no sense but worked.

Detail description of how I did it:

setting servers.php with sql user ragnarok + pw

getting the damn error

setting servers.php with sql user root + pw

getting the damn error

setting sql root to no pw

getting the damn error

deleting root sql user

getting the damn error but logs in with ragnarok even tho I didnt change root to ragnarok

setting servers.php with sql user ragnarok + pw

getting the damn error

creating mysql user root with pw wihout changing the servers.php

WIN

... I don´t get it but it worked.....

Well thanks anyway!