It is currently Fri Jan 15, 2021 11:01 pm
All times are UTC + 8 hours

mySQL access issue

Web hosting, MySQL, PHP and all that good stuff.

mySQL access issue

Postby GHETTOCHiLD » Thu Jun 06, 2013 8:04 am

i can't seem to connect to the mySQL database. i am trying to login as root/admin but i get nothing. i installed phpmyadmin and try to login there to and it gives me an error:

An error occurred during a connection to 192.168.2.20:80.

SSL received a record that exceeded the maximum permissible length.

(Error code: ssl_error_rx_record_too_long)

anyone know how to correct this? i would love to be able to login and manage the db w/ mysql workbench.
GHETTOCHiLD
 
Posts: 9
Joined: Mon May 06, 2013 8:39 pm

Re: mySQL access issue

Postby ho66es » Thu Jun 06, 2013 4:29 pm

is it enabled under services, and have you tried resetting password , and if nothing in there re initialising the database?
608t
ho66es
 
Posts: 476
Joined: Wed Mar 13, 2013 5:38 am

Re: mySQL access issue

Postby GHETTOCHiLD » Thu Jun 06, 2013 7:51 pm

yes, yes, and yes. still can't connect to it.
GHETTOCHiLD
 
Posts: 9
Joined: Mon May 06, 2013 8:39 pm

Re: mySQL access issue

Postby ho66es » Thu Jun 06, 2013 10:49 pm

web server up and running and can you connect to it?
608t
ho66es
 
Posts: 476
Joined: Wed Mar 13, 2013 5:38 am

Re: mySQL access issue

Postby GHETTOCHiLD » Thu Jun 06, 2013 11:16 pm

yes. i can connect to the web server and to the phpmyadmin web page. i did do some googling and looking around and it looks like the config.inc.php is not there, just a sample one. i am not quite sure how to configure it for asustor. was hoping they might know since the phpmyadmin is an app by them.
GHETTOCHiLD
 
Posts: 9
Joined: Mon May 06, 2013 8:39 pm

Re: mySQL access issue

Postby aquarius » Fri Jun 07, 2013 12:44 am

Hello,

For this error: Error code: ssl_error_rx_record_too_long

This usually means the implementation of SSL on your server is not correct. The error is usually caused by a server side problem which the server administrator will need to investigate.

Below are some things we recommend trying.
1. Ensure that port 443 is open and enabled on your server. This is the standard port for https communications.
2. If SSL is using a non-standard port then FireFox 3 can sometimes give this error. Ensure SSL is running on port 443.
3. If using Apache2 check that you are using port 443 for SSL. This can be done by setting the ports.conf file as follows
Listen 80
Listen 443 https
4. Make sure you do not have more than one SSL certificate sharing the same IP. Please ensure that all SSL certificates utilise their own dedicated IP.
6. If using Apache2 check your vhost config. Some users have reported changing <VirtualHost> to _default_ resolved the error.
7. Make sure that your SSL certificate is not expire
8. Try to specify the Cipher:
SSLCipherSuite ALL:!aNULL:!ADH:!eNULL:!LOW:!EXP:RC4+RSA:+HIGH:+MEDIUM:+SSLv3

Maybe you can go to the System Information\DR. ASUSTOR to click on the export health record button.
It can generate the internal logs/configuration of NAS for ASUSTOR troubleshooting!

Best Regards,
aquarius
 
Posts: 14
Joined: Tue May 28, 2013 5:25 pm

Re: mySQL access issue

Postby GHETTOCHiLD » Fri Jun 07, 2013 8:07 pm

i got it working through mysql workbench. sqlbuddy also worked too. i don't know what the proper parameters are to use when setting up phpmyadmin so i gave up on that. i did figure out though that i needed to put a config folder in the phpmyadmin folder and navigate to x.x.x.x./phpmyadmin/setup to create a config.inc.php file. the issue is like i said, i don't know what parameters to set to get it to connect to the asustor db. outside of that i would recommend using sqlbuddy or mysql workbench. both work right from the box.
GHETTOCHiLD
 
Posts: 9
Joined: Mon May 06, 2013 8:39 pm

Return to Web Hosting

  • You cannot post new topics in this forum
    You cannot reply to topics in this forum
    You cannot edit your posts in this forum
    You cannot delete your posts in this forum
    You cannot post attachments in this forum
  • Who is online

    Users browsing this forum: No registered users and 1 guest

cron