XAMPP & db MySql

Problems with the Windows version of XAMPP, questions, comments, and anything related.

XAMPP & db MySql

Postby Vash_90 » 28. November 2011 15:14

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?
Vash_90
 
Posts: 10
Joined: 28. November 2011 15:00
Operating System: Windows xp / 7

Re: XAMPP & db MySql

Postby Vash_90 » 28. November 2011 17:10

...ah! Have change the port default of apache...
Not 80 but 2133, because use TeamViewer
Vash_90
 
Posts: 10
Joined: 28. November 2011 15:00
Operating System: Windows xp / 7

Re: XAMPP & db MySql

Postby Sharley » 28. November 2011 19:53

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. :)
User avatar
Sharley
AF Moderator
 
Posts: 3316
Joined: 03. October 2008 05:10
Location: Yeppoon, Australia Time Zone: GMT/UTC+10
Operating System: Win 7 Pro 32bit/XP Pro SP3

Re: XAMPP & db MySql

Postby Vash_90 » 28. November 2011 23:26

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

Many Thank's :)
Vash_90
 
Posts: 10
Joined: 28. November 2011 15:00
Operating System: Windows xp / 7

Re: XAMPP & db MySql

Postby Sharley » 28. November 2011 23:32

Vash_90 wrote:Fantastic!!! the update worked on lan! :D
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. :)
User avatar
Sharley
AF Moderator
 
Posts: 3316
Joined: 03. October 2008 05:10
Location: Yeppoon, Australia Time Zone: GMT/UTC+10
Operating System: Win 7 Pro 32bit/XP Pro SP3

Re: XAMPP & db MySql

Postby Vash_90 » 28. November 2011 23:39

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 :)
Vash_90
 
Posts: 10
Joined: 28. November 2011 15:00
Operating System: Windows xp / 7

Re: XAMPP & db MySql

Postby Sharley » 28. November 2011 23:47

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?
User avatar
Sharley
AF Moderator
 
Posts: 3316
Joined: 03. October 2008 05:10
Location: Yeppoon, Australia Time Zone: GMT/UTC+10
Operating System: Win 7 Pro 32bit/XP Pro SP3

Re: XAMPP & db MySql

Postby Vash_90 » 28. November 2011 23:55

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.
Vash_90
 
Posts: 10
Joined: 28. November 2011 15:00
Operating System: Windows xp / 7

Re: XAMPP & db MySql

Postby Sharley » 29. November 2011 00:03

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. :)
User avatar
Sharley
AF Moderator
 
Posts: 3316
Joined: 03. October 2008 05:10
Location: Yeppoon, Australia Time Zone: GMT/UTC+10
Operating System: Win 7 Pro 32bit/XP Pro SP3

Re: XAMPP & db MySql

Postby Vash_90 » 29. November 2011 09:24

hi! :)
here the screen on configuration:
invoicex
Image

PhpMyAdmin
Image

router
Image

should be configured correctly...
but when opening Invoicex, from my lab, i get an error :evil:
" error in the opening Database "
same configuration, connecting from home, it works perfectly.. some files to configure?
Vash_90
 
Posts: 10
Joined: 28. November 2011 15:00
Operating System: Windows xp / 7

Re: XAMPP & db MySql

Postby Sharley » 29. November 2011 09:39

Try changing the Host name in invoicex to %
User avatar
Sharley
AF Moderator
 
Posts: 3316
Joined: 03. October 2008 05:10
Location: Yeppoon, Australia Time Zone: GMT/UTC+10
Operating System: Win 7 Pro 32bit/XP Pro SP3

Re: XAMPP & db MySql

Postby Vash_90 » 29. November 2011 09:51

error :\
Vash_90
 
Posts: 10
Joined: 28. November 2011 15:00
Operating System: Windows xp / 7

Re: XAMPP & db MySql

Postby Sharley » 29. November 2011 10:01

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?
User avatar
Sharley
AF Moderator
 
Posts: 3316
Joined: 03. October 2008 05:10
Location: Yeppoon, Australia Time Zone: GMT/UTC+10
Operating System: Win 7 Pro 32bit/XP Pro SP3

Re: XAMPP & db MySql

Postby Vash_90 » 29. November 2011 19:16

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!
Vash_90
 
Posts: 10
Joined: 28. November 2011 15:00
Operating System: Windows xp / 7

Re: XAMPP & db MySql

Postby Sharley » 29. November 2011 23:20

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?
User avatar
Sharley
AF Moderator
 
Posts: 3316
Joined: 03. October 2008 05:10
Location: Yeppoon, Australia Time Zone: GMT/UTC+10
Operating System: Win 7 Pro 32bit/XP Pro SP3

Next

Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 34 guests