Jump to content
The forums will be going offline for an extended maintenance period at 1400hrs GMT on 19th June 2025. The number of hours for this downtime is intentionally not advertised due to the nature of these upgrades. ×
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:  245
  • Reputation:   58
  • 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 Ghostring

Chaos92

Posted
  • Group:  Members
  • Topic Count:  50
  • Topics Per Day:  0.01
  • Content Count:  1859
  • Reputation:   298
  • 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:  245
  • Reputation:   58
  • 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 Drops

hikashin-rae

Posted
  • Group:  Members
  • Topic Count:  18
  • Topics Per Day:  0.00
  • Content Count:  213
  • Reputation:   24
  • 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:  245
  • Reputation:   58
  • 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:  245
  • Reputation:   58
  • 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 Ghostring

Chaos92

Posted
  • Group:  Members
  • Topic Count:  50
  • Topics Per Day:  0.01
  • Content Count:  1859
  • Reputation:   298
  • 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:  245
  • Reputation:   58
  • 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:  245
  • Reputation:   58
  • 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 Eggring

Poring King

Posted
  • Group:  Members
  • Topic Count:  63
  • Topics Per Day:  0.02
  • Content Count:  1016
  • Reputation:   191
  • 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:  245
  • Reputation:   58
  • 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...