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

FluxCP Centos 7 Error: PDOException with full permissions

Rivers

Asked by Rivers,

 Share

Question

Rivers Metaling

Rivers

Posted
  • Group:  Members
  • Topic Count:  50
  • Topics Per Day:  0.01
  • Content Count:  236
  • Reputation:   47
  • Joined:  12/04/13
  • Last Seen:  
Posted (edited) 
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 '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 'name'@'127.0.0.1' (using password: YES)
le: /var/www/html/FluxCP/lib/Flux/Connection.php:81

File	Line	Function/Method
/var/www/html/FluxCP/lib/Flux/Connection.php	81	PDO::__construct()
/var/www/html/FluxCP/lib/Flux/Connection.php	94	Flux_Connection::connect()
/var/www/html/FluxCP/lib/Flux/Connection.php	159	Flux_Connection::getConnection()
/var/www/html/FluxCP/modules/install/index.php	17	Flux_Connection::getStatement()
/var/www/html/FluxCP/lib/Flux/Template.php	375	include()
/var/www/html/FluxCP/lib/Flux/Dispatcher.php	170	Flux_Template::render()
/var/www/html/FluxCP/index.php	176	Flux_Dispatcher::dispatch()
Exception Trace As String
#0 /var/www/html/FluxCP/lib/Flux/Connection.php(81): PDO->__construct(*hidden*)
#1 /var/www/html/FluxCP/lib/Flux/Connection.php(94): Flux_Connection->connect(Object(Flux_Config))
#2 /var/www/html/FluxCP/lib/Flux/Connection.php(159): Flux_Connection->getConnection()
#3 /var/www/html/FluxCP/modules/install/index.php(17): Flux_Connection->getStatement('SELECT VERSION(...')
#4 /var/www/html/FluxCP/lib/Flux/Template.php(375): include('/var/www/html/F...')
#5 /var/www/html/FluxCP/lib/Flux/Dispatcher.php(170): Flux_Template->render()
#6 /var/www/html/FluxCP/index.php(176): Flux_Dispatcher->dispatch(Array)
#7 {main} (using password: YES)

File: /var/www/html/FluxCP/lib/Flux/Connection.php:81

File	Line	Function/Method
/var/www/html/FluxCP/lib/Flux/Connection.php	81	PDO::__construct()
/var/www/html/FluxCP/lib/Flux/Connection.php	94	Flux_Connection::connect()
/var/www/html/FluxCP/lib/Flux/Connection.php	159	Flux_Connection::getConnection()
/var/www/html/FluxCP/modules/main/index.php	10	Flux_Connection::getStatement()
/var/www/html/FluxCP/lib/Flux/Template.php	375	include()
/var/www/html/FluxCP/lib/Flux/Dispatcher.php	170	Flux_Template::render()
/var/www/html/FluxCP/index.php	176	Flux_Dispatcher::dispatch()
Exception Trace As String
#0 /var/www/html/FluxCP/lib/Flux/Connection.php(81): PDO->__construct(*hidden*)
#1 /var/www/html/FluxCP/lib/Flux/Connection.php(94): Flux_Connection->connect(Object(Flux_Config))
#2 /var/www/html/FluxCP/lib/Flux/Connection.php(159): Flux_Connection->getConnection()
#3 /var/www/html/FluxCP/modules/main/index.php(10): Flux_Connection->getStatement('SELECT title, b...')
#4 /var/www/html/FluxCP/lib/Flux/Template.php(375): include('/var/www/html/F...')
#5 /var/www/html/FluxCP/lib/Flux/Dispatcher.php(170): Flux_Template->render()
#6 /var/www/html/FluxCP/index.php(176): Flux_Dispatcher->dispatch(Array)
#7 {main}

Good day,

I am unable to bypass this page. I've given all necessary files chmod 0600, 0707, 0777 permissions but nothing is changing. Does anyone have any idea what might be the issue? I also don't know where "Message: SQLSTATE[28000] [1045] Access denied for user '1129029560S'@'127.0.0.1' (using password: YES)" came from, I don't have a username by that.

Edited by Rivers
Link to comment
Share on other sites

12 answers to this question

Recommended Posts

  • 0
Royr Santa Poring

Royr

Posted
  • Group:  Members
  • Topic Count:  0
  • Topics Per Day:  0
  • Content Count:  90
  • Reputation:   34
  • Joined:  10/01/18
  • Last Seen:  
Posted
20 minutes ago, Rivers said:

Okay, so I removed and re-added permissions and updated the password. Now it all worked, however, I get this issue now.. One after another today, sorry.

I don't know what database to delete so it can re-write it.
  


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: Flux_Error

Message: Critical MySQL error in Installer/Updater: Duplicate column name 'use_existing'

File: /var/www/html/FluxCP/lib/Flux/Installer/Schema.php:131

File	Line	Function/Method
/var/www/html/FluxCP/lib/Flux/Installer/Schema.php	155	Flux_Installer_Schema::install()
/var/www/html/FluxCP/lib/Flux/Installer.php	75	Flux_Installer_Schema::update()
/var/www/html/FluxCP/modules/install/index.php	31	Flux_Installer::updateAll()
/var/www/html/FluxCP/lib/Flux/Template.php	375	include()
/var/www/html/FluxCP/lib/Flux/Dispatcher.php	170	Flux_Template::render()
/var/www/html/FluxCP/index.php	176	Flux_Dispatcher::dispatch()
Exception Trace As String
#0 /var/www/html/FluxCP/lib/Flux/Installer/Schema.php(155): Flux_Installer_Schema->install(20081109093448)
#1 /var/www/html/FluxCP/lib/Flux/Installer.php(75): Flux_Installer_Schema->update()
#2 /var/www/html/FluxCP/modules/install/index.php(31): Flux_Installer->updateAll()
#3 /var/www/html/FluxCP/lib/Flux/Template.php(375): include('/var/www/html/F...')
#4 /var/www/html/FluxCP/lib/Flux/Dispatcher.php(170): Flux_Template->render()
#5 /var/www/html/FluxCP/index.php(176): Flux_Dispatcher->dispatch(Array)
#6 {main}

 

Delete your data/schemas/ AND old cp tables under your Database and reinstall your FluxCP again.
PS: never happen this issue before when I installed both Debian and CentOS distros probably you messed up the configurations. ?

  • Upvote 1
Link to comment
Share on other sites
  • 0
Chaos92 Pouring

Chaos92

Posted
  • Group:  Members
  • Topic Count:  49
  • Topics Per Day:  0.01
  • Content Count:  1529
  • Reputation:   234
  • Joined:  08/03/12
  • Last Seen:  
Posted (edited)
12 hours ago, Rivers said: 

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 'username'@'127.0.0.1' (using password: YES)

File: /var/www/html/FluxCP/lib/Flux/Connection.php:81

File	Line	Function/Method
/var/www/html/FluxCP/lib/Flux/Connection.php	81	PDO::__construct()
/var/www/html/FluxCP/lib/Flux/Connection.php	94	Flux_Connection::connect()
/var/www/html/FluxCP/lib/Flux/Connection.php	159	Flux_Connection::getConnection()
/var/www/html/FluxCP/modules/main/index.php	10	Flux_Connection::getStatement()
/var/www/html/FluxCP/lib/Flux/Template.php	375	include()
/var/www/html/FluxCP/lib/Flux/Dispatcher.php	170	Flux_Template::render()
/var/www/html/FluxCP/index.php	176	Flux_Dispatcher::dispatch()
Exception Trace As String
#0 /var/www/html/FluxCP/lib/Flux/Connection.php(81): PDO->__construct(*hidden*)
#1 /var/www/html/FluxCP/lib/Flux/Connection.php(94): Flux_Connection->connect(Object(Flux_Config))
#2 /var/www/html/FluxCP/lib/Flux/Connection.php(159): Flux_Connection->getConnection()
#3 /var/www/html/FluxCP/modules/main/index.php(10): Flux_Connection->getStatement('SELECT title, b...')
#4 /var/www/html/FluxCP/lib/Flux/Template.php(375): include('/var/www/html/F...')
#5 /var/www/html/FluxCP/lib/Flux/Dispatcher.php(170): Flux_Template->render()
#6 /var/www/html/FluxCP/index.php(176): Flux_Dispatcher->dispatch(Array)
#7 {main}

Good day,

I am unable to bypass this page. I've given all necessary files chmod 0600, 0707, 0777 permissions but nothing is changing. Does anyone have any idea what might be the issue? I also don't know where "Message: SQLSTATE[28000] [1045] Access denied for user 'username'@'127.0.0.1' (using password: YES)" came from, I don't have a username by that. 

Message: SQLSTATE[28000] [1045] Access denied for user 'username'@'127.0.0.1' (using password: YES)

So, check your servers.php in FluxCP.

And make sure your database have the privilege for the user account.

Edited by Haruka Mayumi
Hiding ip and username
  • Upvote 1
Link to comment
Share on other sites
  • 0
Rivers Metaling

Rivers

Posted
  • Group:  Members
  • Topic Count:  50
  • Topics Per Day:  0.01
  • Content Count:  236
  • Reputation:   47
  • Joined:  12/04/13
  • Last Seen:  
  • Author
Posted (edited)

Thanks, I modified and it allowed me to get to the Login and Update page. When I click Update, this happens though.
  

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 'name'@'127.0.0.1' (using password: YES)

File: /var/www/html/FluxCP/lib/Flux/Connection.php:81

File	Line	Function/Method
/var/www/html/FluxCP/lib/Flux/Connection.php	81	PDO::__construct()
/var/www/html/FluxCP/lib/Flux/Connection.php	94	Flux_Connection::connect()
/var/www/html/FluxCP/lib/Flux/Connection.php	159	Flux_Connection::getConnection()
/var/www/html/FluxCP/modules/install/index.php	17	Flux_Connection::getStatement()
/var/www/html/FluxCP/lib/Flux/Template.php	375	include()
/var/www/html/FluxCP/lib/Flux/Dispatcher.php	170	Flux_Template::render()
/var/www/html/FluxCP/index.php	176	Flux_Dispatcher::dispatch()
Exception Trace As String
#0 /var/www/html/FluxCP/lib/Flux/Connection.php(81): PDO->__construct(*hidden*)
#1 /var/www/html/FluxCP/lib/Flux/Connection.php(94): Flux_Connection->connect(Object(Flux_Config))
#2 /var/www/html/FluxCP/lib/Flux/Connection.php(159): Flux_Connection->getConnection()
#3 /var/www/html/FluxCP/modules/install/index.php(17): Flux_Connection->getStatement('SELECT VERSION(...')
#4 /var/www/html/FluxCP/lib/Flux/Template.php(375): include('/var/www/html/F...')
#5 /var/www/html/FluxCP/lib/Flux/Dispatcher.php(170): Flux_Template->render()
#6 /var/www/html/FluxCP/index.php(176): Flux_Dispatcher->dispatch(Array)
#7 {main}

 

Edited by Rivers
Link to comment
Share on other sites
  • 0
hikashin-rae Poring

hikashin-rae

Posted
  • Group:  Members
  • Topic Count:  18
  • Topics Per Day:  0.00
  • Content Count:  208
  • Reputation:   22
  • Joined:  01/14/13
  • Last Seen:  
Posted (edited)
10 hours ago, Rivers said:

Message: SQLSTATE[28000] [1045] Access denied for user '' (using password: YES)

Make sure you enable remote connection from your sql in server side.

Edited by Haruka Mayumi
Removed user and ip
  • Upvote 1
Link to comment
Share on other sites
  • 0
Rivers Metaling

Rivers

Posted
  • Group:  Members
  • Topic Count:  50
  • Topics Per Day:  0.01
  • Content Count:  236
  • Reputation:   47
  • Joined:  12/04/13
  • Last Seen:  
  • Author
Posted

I gave them all permissions. Executed the update again and same error. 

Link to comment
Share on other sites
  • 0
Royr Santa Poring

Royr

Posted
  • Group:  Members
  • Topic Count:  0
  • Topics Per Day:  0
  • Content Count:  90
  • Reputation:   34
  • Joined:  10/01/18
  • Last Seen:  
Posted (edited)
9 hours ago, Rivers said:

I gave them all permissions. Executed the update again and same error. 

The issue looks like 'username' not giving permission.
Is your username user pointing to host '%'?

Note: Also make sure the username (user) giving ALL PRIVILEGES from the database.

11.PNG.c9239094069c866818c7ab99f52206fd.PNG

Edited by Haruka Mayumi
Removed username
  • Upvote 1
Link to comment
Share on other sites
  • 0
Rivers Metaling

Rivers

Posted
  • Group:  Members
  • Topic Count:  50
  • Topics Per Day:  0.01
  • Content Count:  236
  • Reputation:   47
  • Joined:  12/04/13
  • Last Seen:  
  • Author
Posted (edited)

Yes I did that as well. 

 

 

 

Edited by Rivers
Link to comment
Share on other sites
  • 0
Chaos92 Pouring

Chaos92

Posted
  • Group:  Members
  • Topic Count:  49
  • Topics Per Day:  0.01
  • Content Count:  1529
  • Reputation:   234
  • Joined:  08/03/12
  • Last Seen:  
Posted
1 hour ago, Rivers said:

Yes I did that as well. 

 

Screenshot_20201213-143420.png

use the username and password in servers.php.

Link to comment
Share on other sites
  • 0
Rivers Metaling

Rivers

Posted
  • Group:  Members
  • Topic Count:  50
  • Topics Per Day:  0.01
  • Content Count:  236
  • Reputation:   47
  • Joined:  12/04/13
  • Last Seen:  
  • Author
Posted (edited)

Okay, so I removed and re-added permissions and updated the password. Now it all worked, however, I get this issue now.. One after another today, sorry.

I don't know what database to delete so it can re-write it.
  

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: Flux_Error

Message: Critical MySQL error in Installer/Updater: Duplicate column name 'use_existing'

File: /var/www/html/FluxCP/lib/Flux/Installer/Schema.php:131

File	Line	Function/Method
/var/www/html/FluxCP/lib/Flux/Installer/Schema.php	155	Flux_Installer_Schema::install()
/var/www/html/FluxCP/lib/Flux/Installer.php	75	Flux_Installer_Schema::update()
/var/www/html/FluxCP/modules/install/index.php	31	Flux_Installer::updateAll()
/var/www/html/FluxCP/lib/Flux/Template.php	375	include()
/var/www/html/FluxCP/lib/Flux/Dispatcher.php	170	Flux_Template::render()
/var/www/html/FluxCP/index.php	176	Flux_Dispatcher::dispatch()
Exception Trace As String
#0 /var/www/html/FluxCP/lib/Flux/Installer/Schema.php(155): Flux_Installer_Schema->install(20081109093448)
#1 /var/www/html/FluxCP/lib/Flux/Installer.php(75): Flux_Installer_Schema->update()
#2 /var/www/html/FluxCP/modules/install/index.php(31): Flux_Installer->updateAll()
#3 /var/www/html/FluxCP/lib/Flux/Template.php(375): include('/var/www/html/F...')
#4 /var/www/html/FluxCP/lib/Flux/Dispatcher.php(170): Flux_Template->render()
#5 /var/www/html/FluxCP/index.php(176): Flux_Dispatcher->dispatch(Array)
#6 {main}

 

Edited by Rivers
Link to comment
Share on other sites
  • 0
Rivers Metaling

Rivers

Posted
  • Group:  Members
  • Topic Count:  50
  • Topics Per Day:  0.01
  • Content Count:  236
  • Reputation:   47
  • Joined:  12/04/13
  • Last Seen:  
  • Author
Posted

Thanks for you reply,
When I deleted the CP logs it now says they don't exist. How do I make the exist again? I can't remember is there was a console command for it or not.

Link to comment
Share on other sites
  • 0
Poring King Magmaring

Poring King

Posted
  • Group:  Members
  • Topic Count:  61
  • Topics Per Day:  0.02
  • Content Count:  911
  • Reputation:   166
  • Joined:  11/27/14
  • Last Seen:  
Posted

If you are going online or offline . Always use or base all your configuration to your database. If the database using root & admin as user and pass then put on your anyfile as a connection is root and admin only . So you will not mess up . Do the custom configuration when you know already what you are doing..

  • Upvote 1
Link to comment
Share on other sites
  • 0
Rivers Metaling

Rivers

Posted
  • Group:  Members
  • Topic Count:  50
  • Topics Per Day:  0.01
  • Content Count:  236
  • Reputation:   47
  • Joined:  12/04/13
  • Last Seen:  
  • Author
Posted

Sorry, I forgot to mention that the issue has been resolved. Thanks everyone for your help!

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