×

Switch Account

MySQL

Reply
Highlighted
Contributor
Contributor
Posts: 4
Registered: ‎06-16-2020

MySQL

Message 1 of 5
(356 Views)

I am trying to get this script to work:

 

<?/* 
<CONFIG application="SAM" version="4.9.6">
	<Database>
		<Driver>MYSQL</Driver>
		<Host>100.33.93.149</Host>
		<Port>3306</Port>
		<Database>SAMDB</Database>
		<Username>root</Username>
		<Password>djhenri</Password>
	</Database>
</CONFIG>

 */?>

 

I added these two Port Forwarding Rules:

MySQL
TCP 3306 -> 3306
Edit Remove
SAM
TCP 1221 -> 1221
Edit Remove

but the computer can't seem to connect to its database. 

4 REPLIES 4
Highlighted
Contributor
Contributor
Posts: 4
Registered: ‎06-16-2020

Tech Support instructions

Message 2 of 5
(319 Views)

I'm trying to get Port Forwarding set up and got these complicated instructions from Verizon FiOS Tech Support:

1. The server had to be changed to bind the new IP address in /etc/mysql.conf 2. Several MySQL based programs had to be modified to connect to the new server address. 3. GRANT had to be invoked by MySQL root for each user on the new host IP addresses.

Can anyone give me a for-dummies explanation how to do these things?  It was way easier with my old router, and Verizon Tech Support can help me no further.

Highlighted
Platinum Contributor III Platinum Contributor III
Platinum Contributor III
Posts: 5,974
Registered: ‎09-24-2008

Re: Tech Support instructions

Message 3 of 5
(275 Views)

Make sure that the source port is set to ANY.

 

If that does not solve the issue, please post and we will go from there..

If you are the original poster (OP) and your issue is solved, please remember to click the "Solution?" button so that others can more easily find it. If anyone has been helpful to you, please show your appreciation by clicking the "Kudos" button.


 

Highlighted
Contributor
Contributor
Posts: 4
Registered: ‎06-16-2020

Re: Tech Support instructions

Message 4 of 5
(200 Views)

When I had sent my question April 16, I had already tried various ways of configuring Port Forwarding, including ANY.  I had gotten 1221 working, but 3306 just never worked for me.  So, between then and now, I abandoned MySQL altogether and switched to Firebird, which has a crude HTML output, but at least something.  I had been using MySQL for more than a decade successfully with other ISPs, and never run into as low a level of support as with Verizon FiOS.

Highlighted
Platinum Contributor III Platinum Contributor III
Platinum Contributor III
Posts: 5,974
Registered: ‎09-24-2008

Re: Tech Support instructions

Message 5 of 5
(159 Views)

Upon reflection I think I know what it is.

 

Besides the source port ANY, your new NAT router does not support loopback/reverse NAT/NAT Hairpinning.

 

By that I point to

 

http://www.pcwintech.com/test-for-reverse-nat

 

You can either use Simple Internet Tools - Port Listener (that tool that is addressed on that page) or you must use a server that logs the IP Address(es) that connect to the server.

 

Once you know the issue is that the router does not support loopback/reverse NAT/NAT Hairpinning, I point to Port forwarding only works seen from outside my local network? 

 

If you are the original poster (OP) and your issue is solved, please remember to click the "Solution?" button so that others can more easily find it. If anyone has been helpful to you, please show your appreciation by clicking the "Kudos" button.


 

How-To Videos
 
The following videos were produced by users like you!
   
Videos are subject to the Verizon Fios Community Terms of Service and User Guidelines and contains content that is not created by Verizon.
Covid19


Browse Categories
Categories:
Posts

Verizon Troubleshooters
Unable to find your answer here? Try searching Verizon Troubleshooters for more options.