Main Area and Open Discussion > General Software Discussion

In search of ... help with XAMPP [portable] installation.

(1/2) > >>

barney:
Folk,
I recently installed XAMPP v1.8.1 on an 8GB USB stick.  Works fine.  Until I try to use it on a WAMP/LAMP machine.  I finally managed to ferret out the places to change the Apache port so that the stick uses 8080.  However, I cannot get MySQL to run when I change the port to 3308 - or anything other than 3306.

This stick is going to be used in a business - my sailing friend's - to track students, courses, dates, grades, course materials shipments ... y'know, all that minor detail stuff that needs to be recorded  ;).  Yes, it should be done on a dedicated machine with a dedicated admin.  Business not big enough to support that, financially, at this time.

Three (3) machines currently in his office, two (2) of which have WAMP installations that cannot be removed.  Rather than move the operator from machine to machine, we want to be able to move the USB stick.  But that's not a viable option until I can get this MySQL conundrum resolved.

I've run multiple instances of MySQL in the past on ports 3306, 3307, & 3308.  (Needed different versions for then current developments being processed.)  So, I know it's possible, or at least, it was.

Every time I've tried XAMPP in the past, I've ended up throwing it out because of configuration issues, but I cannot do that this time - I need to make it work.  (I've asked over at the XAMPP forum (Apache Friends), but get no response  :(  >:(.)  The event and error logs aren't telling me anything useful.  I'm in hopes that some of you here will be able to point out some - probably obvious  :-\ - oversight on my part to get this thing working as it should.

40hz:
The setting should be in the file my.cnf where port=nnnn

You can try a direct edit rather than trying to do it through MySQL's admin panel. I don't think XAMPP will let you change the port using that.

The only problem is I don't know what ripple-down effect that's going to have on your pHp scriots and everything else that may reference that port number.

barney:
Yep, did that - albeit 'twas my.ini, not my.cnf.  Error message was, "Could not connect:  No connection could be made because the target machine actively refused it."

Only other my.* files are MY.pm and my.pm in the PERL directory structure.

Insofar as I am aware, I've changed every instance of 3306 to 3308 in my.in, httpd.conf, & php.ini.  Also added localhost:3308 to my connect string.  That's what's pulling my cork - technician's version of Hell:  everything is perfect, it just doesn't work  :P.

Shades:
Are you sure that the port you used in the configuration file is open? Could be that firewall/anti-virus software has that port blocked. Are you using a router in the office? Could be that you have to do some configuring there as well (opening and/or forwarding ports).

These are very general hints, but as I do not know 'the lay of the land' it is hard to say anything more useful.

40hz:
+1 w/Shades. That does sound like a firewall or related security setting somewhere is blocking the call.

It could also caused by the localhost variable in a script. XAMPP may be trying to connect to an instance of MySQL or php which is already active on the desktop machine - and that may be what is actually refusing the connection rather than something internal to XAMPP.

Navigation

[0] Message Index

[#] Next page