Supporting each other

Community forums

Welcome, Guest
Username: Password: Remember me
Questions on getting Xerte Toolkits installed on your server and questions about authentication and user logins.
  • Page:
  • 1

TOPIC: can't create DB ***SOLVED***

can't create DB ***SOLVED*** 3 years 5 months ago #5155

  • dino.grendene
  • dino.grendene's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 8
  • Thank you received: 0
Hi, I am trying to do a clean install of Xerte 3.6 and I am receiving an error while creating DB on server.
I tried creating MySql user and empty DB before installing but with no result.
The error I receive is:
SQLSTATE[HY000] [2003] Can't connect to MySQL server on '127.0.0.1' (111)
if I set "localhost" as Database host and:
SQLSTATE[28000] [1045] Access denied for user 'XXXXX'@'YYYYY' (using password: YES)
if I set the IP of the server as Database Host; XXXXX is the user that EXISTS in Mysql and YYYYY is the FQD name of the server (in private VPN).
All ports are open through firewall, server is Ubuntu 12.04 and client is Ubuntu 16.04 using Firefox.
I had previously installed XERTE 2.1 some years ago with no problem on same server, and new installation is on a different directory and a different DB.
Thanks in advance for answers
Dino

Please Log in or Create an account to join the conversation.

Last edit: by dino.grendene.

can't create DB 3 years 5 months ago #5156

  • tsalyers
  • tsalyers's Avatar
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 16
  • Thank you received: 0
Hi, Dino.

Just a thought...has your user XXXXX been granted privileges on the database you're trying to connect to? I usually get that "Access denied for user" error if I've forgotten to grant privileges.

Please Log in or Create an account to join the conversation.

Last edit: by tsalyers.

can't create DB 3 years 5 months ago #5160

  • dino.grendene
  • dino.grendene's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 8
  • Thank you received: 0
Hi Tom,
thank you for answering.
Yes, user XXXXX has full privileges on database.
Anyway I get same errors even if I try to perform installation using Mysql root credentials.
I suspect there must be some configuration issue, but I can't figure out which one.
Dino

Please Log in or Create an account to join the conversation.

can't create DB ***SOLVED*** 3 years 5 months ago #5161

  • dino.grendene
  • dino.grendene's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 8
  • Thank you received: 0
Hi,
I tried installing on a different server equipped with Ubuntu 16.04, and it installed with no hassle.
I suppose there was some issue with the old Ubuntu 12.04 (different web root directory or so on), even if the installing procedure found no problem.
Any way, problem solved for me (I edited the original post with the tag "Solved").
bye
Dino

Please Log in or Create an account to join the conversation.

  • Page:
  • 1
Time to create page: 0.046 seconds
Copyright © 2021 The Xerte Project.
Xerte logo Apereo logo OSI Logo

Search