Jump to content
  • 0
Rivers

FluxCP Centos 7 Error: PDOException with full permissions

Asked by Rivers

Question

Rivers Poring

Rivers

Posted
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
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 Marin

Chaos92

Posted
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 Poring

Rivers

Posted
  • 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
Cookie-rae Poring

Cookie-rae

Posted
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
Royr Santa Poring

Royr

Posted
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 Poring

Rivers

Posted
  • 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
Poring King Poporing

Poring King

Posted
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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
Go to question listing
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use and Privacy Policy.

  I accept