The Uniform Server Wiki

5.0-Nano: Known Issues: Difference between revisions

← Older edit
 
(2 intermediate revisions by the same user not shown)
Line 3: Line 3:


This page contains known issues and problems, where applicable offers solutions.  
This page contains known issues and problems, where applicable offers solutions.  
== MySQL host name 127.0.0.1 or localhost ==
The following applies to Windows 7 users.
=== No registry dust and portable ===
MySQL 5 supports only IPv4 unfortunately Windows 7 gives priority to IPv6 and returns an IPv6 address for '''localhost''' hence a connection fails.
Uniform Server’s solution is to replace '''localhost''' with port address '''127.0.0.1''' this forces an IPv4 connection.
* When requested for a MySQL '''host name''' use '''127.0.0.1'''
=== Registry dust and portability sacrificed ===
I like alternatives and if you wish to use localhost as the MySQL host name perform the following:
* Run regedit and create a DWORD entry at
**  HKLM\SYSTEM\CurrentControlSet\services\TCPIP6\Parameters called “DisabledComponents”,
* Set value to 0x20. it sets IPv4 to be preferred over IPv6
Full details of this solution is found on [http://bobstrand.com '''Bob Strand’s'''] website.
See page: [http://bobstrand.com/totm/2010/04/13/hey-dude-wheres-my-localhost/ '''hey-dude-wheres-my-localhost''']


== Services not starting ==
== Services not starting ==
Line 325: Line 345:
* Problem: Missing import TAB
* Problem: Missing import TAB
* Solution: Use the Query window  
* Solution: Use the Query window  
'''''Note'':''' Corrected in phpMyAdmin version 3.3.2 and Uniform Server 5.6.3


Although you can use the Query window (second icon top left) to import files I prefer an import TAB.
Although you can use the Query window (second icon top left) to import files I prefer an import TAB.
Line 346: Line 368:


'''''[[#top | Top]]'''''
'''''[[#top | Top]]'''''
== MySQL root password (host 127.0.0.1) ==
== MySQL root password (host 127.0.0.1) ==
Versions affected, all Mona and Nano series.
Versions affected, all Mona and Nano series.
Line 356: Line 379:


A] Edit file: UniServer\home\admin\www\'''mqsetup.php'''
A] Edit file: UniServer\home\admin\www\'''mqsetup.php'''
Locate this code:
Locate this code:
<pre>
<pre>
Line 372: Line 396:
</pre>
</pre>
B] Start servers
B] Start servers
C] From Unitray run restore MySQL password (root name and password both restored to root)
C] From Unitray run restore MySQL password (root name and password both restored to root)
D] From Apanel set a new MySQL root password or use the one you previously set.
D] From Apanel set a new MySQL root password or use the one you previously set.


Retrieved from "https://wiki.uniformserver.com/5.0-Nano:_Known_Issues"