Sponsor:

Server and Web Integrator
Link:
Kloxo-MR logo
6.5.0 or 7.0.0
Click for "How to install"
Donation/Sponsorship:
Kloxo-MR is open-source.
Donate and or Sponsorship always welcome.
Click to:
Click Here
Please login or register. 2024-03-28, 11:02:36

Author Topic: Unable to login to database containing "-" or "."  (Read 2906 times)

0 Members and 1 Guest are viewing this topic.

Offline Spacedust

  • Super Grand Master
  • ****
  • Posts: 4,050
  • Karma: +1/-0
    • View Profile
Unable to login to database containing "-" or "."
« on: 2014-02-14, 18:17:07 »
How to reproduce:

Create database like this:

user-mydatabase

or

user-mydatabase.test

then try to login to phpMyAdmin by clicking the black dot near database name.

You will get message unable to login to MySQL server.

That's why we need to block - and . inside database names !

Offline chrisf

  • Senior Master
  • **
  • Posts: 883
  • Karma: +11/-1
  • Gender: Male
  • Be the change that you wish to see in the world.
    • View Profile
    • Conviction's Hosting
Re: Unable to login to database containing "-" or "."
« Reply #1 on: 2014-02-14, 20:48:49 »
+1.  A simple regex alphanumeric check would work, allowing a-z, 0-9 but no other characters.
Christopher

Knowledge in: PHP, Perl, MySQL, Javascript, Actionscript, FLASH, HTML, CSS
Server Administrator / Developer: https://convictionshosting.com

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: Unable to login to database containing "-" or "."
« Reply #2 on: 2014-02-15, 03:50:14 »
As I know, mysql database name only with alphanumeric plus _ (underline) and . (dot).
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline Spacedust

  • Super Grand Master
  • ****
  • Posts: 4,050
  • Karma: +1/-0
    • View Profile
Re: Unable to login to database containing "-" or "."
« Reply #3 on: 2014-02-17, 14:26:55 »
Yes, but customers are able to create such databases inside Kloxo and then they are reporting they cannot login. People are dumb you know ;)

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: Unable to login to database containing "-" or "."
« Reply #4 on: 2014-02-17, 14:47:55 »
Next release of 6.5.1.a will include validate for client name, database and password entry.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

 


MRatWork Affiliates:    BIGRAF(R) Inc.    House of LMAR    EFARgrafix
Click Here

Page created in 0.041 seconds with 19 queries.

web stats analysis