Jump to content
The Web Section is Now Read-Only
  • 0

Allowing flux cp to connect to VPS

_jx

Asked by _jx,

 Share

Question

_jx Poring

_jx

Posted
  • Group:  Members
  • Topic Count:  3
  • Topics Per Day:  0.00
  • Content Count:  22
  • Reputation:   1
  • Joined:  01/17/12
  • Last Seen:  
Posted (edited)

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 by hao
Link to comment
Share on other sites

6 answers to this question

Recommended Posts

  • 0
ManokStreZ Metaling

ManokStreZ

Posted
  • Group:  Members
  • Topic Count:  21
  • Topics Per Day:  0.02
  • Content Count:  119
  • Reputation:   0
  • Joined:  09/02/20
  • Last Seen:  
Posted
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 root@localhost.

>_____>

Is this a bug? Does it really use root@localhost? 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

Link to comment
Share on other sites
Brian Poring

Brian

Posted
  • Group:  Members
  • Topic Count:  75
  • Topics Per Day:  0.02
  • Content Count:  2223
  • Reputation:   593
  • Joined:  10/26/11
  • Last Seen:  
Posted

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.

Link to comment
Share on other sites
_jx Poring

_jx

Posted
  • Group:  Members
  • Topic Count:  3
  • Topics Per Day:  0.00
  • Content Count:  22
  • Reputation:   1
  • Joined:  01/17/12
  • Last Seen:  
  • Author
Posted

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 user@ip, but IP? Could you please explain further?

Can I bump this please?

EDIT:

Fixed!!

The solution is, you need to grant useronyourVPS@yourwebhostip.

Link to comment
Share on other sites
Wafflebutt Poring

Wafflebutt

Posted
  • Group:  Members
  • Topic Count:  7
  • Topics Per Day:  0.00
  • Content Count:  234
  • Reputation:   19
  • Joined:  06/15/12
  • Last Seen:  
Posted (edited)

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 root@localhost.

>_____>

Is this a bug? Does it really use root@localhost? 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 by Ainna
Link to comment
Share on other sites
Asura Poring

Asura

Posted
  • Group:  Members
  • Topic Count:  3
  • Topics Per Day:  0.00
  • Content Count:  707
  • Reputation:   168
  • Joined:  01/26/12
  • Last Seen:  
Posted

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.

Link to comment
Share on other sites
Wafflebutt Poring

Wafflebutt

Posted
  • Group:  Members
  • Topic Count:  7
  • Topics Per Day:  0.00
  • Content Count:  234
  • Reputation:   19
  • Joined:  06/15/12
  • Last Seen:  
Posted

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!

Link to comment
Share on other sites
 Share
Go to question listing
×
×
  • Create New...