Apache Friends Support Forum

Hi!
Sorry my english but i'm italian

I have a 2 Pc's
1) Windows Xp sp3 with Xampp 1.7.7 and loaded my Db on mySql (Antivirus AVG Firewall Nothing) <--(Server)
2) Windows 7 <--- (client)

the db, doesn't access on lan... why?
Xampp works perfectly, and windows 7 see the test-page(welcome on xampp) on windows xp.
Only problem is the access on bd.
Also Windows Xp i can't access... i used as the address 'localhost:3306' '127.0.0.1:3306' and 'xxx.dyndns.com:3306' but nothing
the router is correctly configured for portforwarding..

Why ? ideas?

...ah! Have change the port default of apache...
Not 80 but 2133, because use TeamViewer

It would be better that you change the ports that TeamViewer uses as Apache is best suited to using the web server default ports of 80 and 443.

Exit the older XAMPP Control Panel 2.5 and use the newer v3 panel by double clicking on xampp-control-3-beta.exe found in the xampp folder.

It has a better log window that might give you a clue about what has and has not started.

It also creates a log file in the xampp folder that you can open in your text editor if you need to copy and paste to the forum any entries.

Also there is a button Netstat that can check what ports are being used.

Latest XCPv3 versions can be found here:
viewtopic.php?f=16&t=48932

Good luck.

Fantastic!!! the update worked on lan!
but on remote? it's possible?

Many Thank's

Vash_90 wrote:Fantastic!!! the update worked on lan!
but on remote? it's possible?

Many Thank's

You will need to be a more specific about what you mean.

What is working exactly and what is not working exactly?

How are you trying access a remote and what do you mean by remote?
Thanks for more info please.

inside on LAN all Works (access on db, first didn't work)
i wish it worked well on remote... out of my lan.
not through 192.168.1.x:3306 but xxx.dyndns-home.com:3306

Thank's

You can access http://localhost on the remote?

When you get the Welcome page on the remote there are databases in the demo menu on the left.

To access your databases in phpMyAdmin try clicking on the Admin button next to MySQL in the new Control Panel.

Or go to http://localhost/phpmyadmin

192.168.1.x:3306 or http://localhost:3306 will not access a database - using an address with port 3306 won't usually access a database.

Do you have an application that has a database you want to access in the htdocs folder of XAMPP?

ok ok..
everything is working properly on lan
i use on software management contability (invoicex), the first pc, (server) is in my home,
and would like access on db from my lab with second pc.

In phpMyAdmin you have to set the database for invoicex and it's user to Any host % not just localhost.

Or you may have a configuration setting in invoicex that has the database set to localhost when you created the connection settings - this needs to be Any host or the % character not localhost or that is the only location you will be able to access the database of invoicex.

With the Any host setting your database (MySQL) will listen for connection from other locations as well as localhost.

Best wishes.

hi!
here the screen on configuration:
invoicex


PhpMyAdmin


router


should be configured correctly...
but when opening Invoicex, from my lab, i get an error
" error in the opening Database "
same configuration, connecting from home, it works perfectly.. some files to configure?

Try changing the Host name in invoicex to %

error :\

Was it the same error message?

Try changing it to localhost and see if you still get the error message.

It is obvious that the Host name you had in your screen cap gives an error so you need to experiment.

Also in the \xampp\mysql\data folder is an error.log file that may hold a clue.

I don't have invoicex to experiment with so you will need to experiment with different settings in the Host name field.

Does invoicex have any Italian support forum on SourceForge?

This is my problem: at home I use a fastweb adsl, that isn't provided of a public ip. The only solution is the DynDNS for remote access..
In local it works perfectly.
The users in the Italian forum are very rude, they didn't help me. So thank you very much!

Sorry, I have no idea what fastweb is or how it affects your access.

Do you have a firewall or a security system like ZoneAlarm or similar blocking port 3306?