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

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

can't create DB ***SOLVED*** 10 months 3 weeks ago #5155

  • Dino Grendene
  • Dino Grendene's Avatar
  • Offline
  • Fresh Boarder
  • Posts: 8
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
Last Edit: 10 months 3 weeks ago by Dino Grendene.
The administrator has disabled public write access.

can't create DB 10 months 3 weeks ago #5156

  • Tom Salyers
  • Tom Salyers's Avatar
  • Offline
  • Fresh Boarder
  • Posts: 6
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.
Last Edit: 10 months 3 weeks ago by Tom Salyers.
The administrator has disabled public write access.

can't create DB 10 months 3 weeks ago #5160

  • Dino Grendene
  • Dino Grendene's Avatar
  • Offline
  • Fresh Boarder
  • Posts: 8
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
The administrator has disabled public write access.

can't create DB ***SOLVED*** 10 months 3 weeks ago #5161

  • Dino Grendene
  • Dino Grendene's Avatar
  • Offline
  • Fresh Boarder
  • Posts: 8
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
The administrator has disabled public write access.
Time to create page: 0.262 seconds
Powered by Kunena Forum

Donate

Sponsor us

The Xerte Community is a volunteer-based organization. Please help us to continue that!