The Uniform Server Wiki

5.0-Nano: Known Issues: Difference between revisions

← Older edit
mNo edit summary
 
(4 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 322: Line 342:


'''''[[#top | Top]]'''''
'''''[[#top | Top]]'''''
== phpMyAdmin (versions 3.3.0 and 3.3.1) ==
* Problem: Missing import TAB
* 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.
If you want to re-establish this tab proceed as follows:
Edit file:
* UniServer\home\admin\www\phpMyAdmin\libraries\'''server_links.inc.php'''
Locate this block:
<pre>
$tabs['import']['icon'] = 's_sync.png';
$tabs['import']['link'] = 'server_synchronize.php';
$tabs['import']['text'] = $strSynchronize;
</pre>
Replace with:
<pre>
$tabs['synchronize']['icon'] = 's_sync.png';
$tabs['synchronize']['link'] = 'server_synchronize.php';
$tabs['synchronize']['text'] = $strSynchronize;
</pre>
'''''[[#top | Top]]'''''
== MySQL root password (host 127.0.0.1) ==
Versions affected, all Mona and Nano series.
'''''Note'':''' Version 5.6.2-Nano Updated
=== Problem ===
When changing MySQL root password “localhost” is correctly updated however host “127.0.0.1” remains unchanged. This is undesirable and should be rectified straight away.
=== Solution ===
Solution is to download the latest version of Uniform Server. However this may be inconvenient. Existing installation are easily upgradeable as follows:
A] Edit file: UniServer\home\admin\www\'''mqsetup.php'''
Locate this code:
<pre>
// Create query string (not sure if you need to flush privs)
$query = 'SET PASSWORD FOR \'root\'@\'localhost\' = PASSWORD(\'' . $nwpass . '\')';
$result = mysql_query($query);
</pre>
Just below it add the following code:
<pre>
// Create query string
$query = 'SET PASSWORD FOR \'root\'@\'127.0.0.1\' = PASSWORD(\'' . $nwpass . '\')';
$result = mysql_query($query);
$query = "FLUSH PRIVILEGES";
$result = mysql_query($query);
</pre>
B] Start servers
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.
'''''[[#top | Top]]'''''
----
----


[[Category: Uniform Server 5.0-Nano]]
[[Category: Uniform Server 5.0-Nano]]
Retrieved from "https://wiki.uniformserver.com/5.0-Nano:_Known_Issues"