Ric

This is the intended functionality: “From Apanel under Server Control you can start and stop the MySQL server.” However as you rightly pointed out: “Actually you can't.” Yep! You have found a minor bug. To correct this, edit the following file: UniServer\home\admin\www\includes\server.inc Navigate to end of file and replace this <?php if(get_mysql_tracker()=='program'){ //=== MySQL ?> <a target="content" onclick="h(this);" href="server_control.php?sel=start_mysql"?><?php echo $US['nav-rmysql']?></a> <a target="content" onclick="h(this);" href="server_control.php?sel=stop_mysql"?><?php echo $US['nav-smysql']?></a> <?php } ?> With <?php if(get_mysql_tracker()=='program'){ //=== MySQL ?> <a target="content" onclick="h(this);" href="server_control.php?sel=stop_mysql"?><?php echo $US['nav-smysql']?></a> <?php } ?> <?php if(get_mysql_tracker()=='free'){ //=== MySQL ?> <a target="content" onclick="h(this);" href="server_control.php?sel=start_mysql"?><?php echo $US['nav-rmysql']?></a> <?php } ?> Note: After starting or stopping MySQL server Apanel’s navigation menu will no longer reflect correct MySQL state until your browser is manually refreshed. This can be corrected by editing the following file: UniServer\home\admin\www\server_control.php Add this line: update_navigation_menu(); // update nav In two places as shown blow: print "<p>".$US['start-mysql-txt3']."</p>"; // inform user update_navigation_menu(); // update nav print "<p>".$US['stop-mysql-txt2']."</p>"; // inform user server stopped update_navigation_menu(); // update nav Finally add the following function just above the footer include as shown below: function update_navigation_menu(){ print '<script language="javascript">'; print "window.onload = setTimeout('parent.navigation.location.href=\"navigation.php\" ',2000);"; print '</script>'; } include_once "includes/footer.php"; Note: The two-second (2000) timeout is a compromise, however it should be adequate for the servers to have started or stopped before navigation menu checks current server status. All the best Ric

I am not sure if I fully understand your request. From Apanel under Server Control you can start and stop the MySQL server. All the best Ric

5.7.4-Nano and 6.1.4-Carbo, Released Updated phpMyAdmin to 3.3.9.2 -- Security update Ref: http://www.phpmyadmin.net/home_page/securi...MASA-2011-2.php Download: UniServer 5.7.4-Nano UniServer 6.1.4-Carbo Regards, The Uniform Server Development Team

OK Let’s see if we can move this forward! First gather some diagnostic info: Download UniServer 5.7.3 Run Run_pre_check.exe ensure ports are free Start servers From Apanel change MySQL password Stop servers Post log files: UniServer\usr\local\apache2\logs\error.log UniServer\usr\local\mysql\data\mysql.err All the best Ric

Apart from enabling SSL it looks as if you have enabled the “personal” server features (server access including apanel require a name and password). The following Wiki page explains these features: http://wiki.uniformserver.com/index.php/5....curity_features To disable name password access edit the following files (.htaccess): Apanel: File: UniServer\home\admin\www\.htaccess Edit these sections to that shown below: Order Deny,Allow Deny from all Allow from 127.0.0.1 #AuthName "Uniform Server - Admin Panel 2.0" #AuthType Basic #AuthUserFile ../../../htpasswd/home/admin/www/.htpasswd #Require valid-user Server folder www: File: UniServer\www\.htaccess Edit these sections to that shown below: Order Deny,Allow Deny from all Allow from 127.0.0.1 #AuthName "Uniform Server - Server Access" #AuthType Basic #AuthUserFile ../../../htpasswd/www/.htpasswd #Require valid-user Server folder ssl: File: UniServer\ssl\.htaccess Edit these sections to that shown below: Order Deny,Allow Deny from all Allow from 127.0.0.1 #AuthName "Uniform Server - Secure Server Access" #AuthType Basic #AuthUserFile ../../../htpasswd/ssl/.htpasswd #Require valid-user All the best Ric

Your log files show some interesting results. mysql.err: While starting MySQL shows correct sequence. MySQL is running and ready to receive connections. Apache error.log: Shows Apache started and listening on port 80. The error shows an attempt was made from apanel to change the MySQL password. Apanel cannot complete its task because MySQL is no longer running resulting in error message [2002]. Above results suggest MySQL initially starts and them stops. More diagnostic info is required: Download UniServer 5.7.3 From tray menu switch php.ini to development. Run Servers. From apanel change the MySQL password. Expected result: Error [2002] From tray menu run server status: Expected result: MySQL not running and port 3306 free to use. Directly run MySQL: Navigate to folder UniServer\a_diagnostic Double click on 3_Start_MySQL_program.bat Note any errors. Hopefully this will provide more information as to why the server should start and then stop. All the best Ric

Without any further information it really is extremely difficult to resolve this type of problem. What do the log files show? Check the following files: UniServer\usr\local\apache2\logs\error.log UniServer\usr\local\mysql\data\mysql.err Run the test batch files in folder UniServer\a_diagnostic in particular 3_Start_MySQL_program.bat Any diagnostic information obtained will help. Please use UniServer 5.7.3 and state your OS All the best Ric

UniServer 5.7.3-Nano Released: Core components: Apache 2.2.17 MySQL 5.5.9 -- Update PHP 5.3.5 phpMyAdmin 3.3.9 .1 -- Security update Go-Pear 1.1.2 msmtp 1.4.23 eAccelerator 1.0-snv427 OpenSSL 0.9.8q UniServer 6.1.3-Carbo Released: (Note: This is a VC9 version of 5.7.3-Nano) Core components: Apache 2.2.17 MySQL 5.5.9 - Update PHP 5.3.5 phpMyAdmin 3.3.9.1 - Security update Go-Pear 1.1.2 msmtp 1.4.23 eAccelerator 1.0-snv427 WinBinder 2010.10.14 OpenSSL updated to 1.0.0d Download: UniServer 5.7.3-Nano UniServer 6.1.3-Carbo Regards, The Uniform Server Development Team

UniServer 5.7.2-Nano Released: Core components: Apache 2.2.17 MySQL 5.5.8 PHP 5.3.5 phpMyAdmin 3.3.9 Go-Pear 1.1.2 msmtp 1.4.23 -- Update eAccelerator 1.0-snv427 -- Update Bug fixes: - MySQL ini corrected defaults to UTF8 - updated go-pear.php - Updated openssl.cnf - Minor change to server certificate script - mysql service force config file - pear confg now tracks server location - corrected PHP development ini spelling UniServer 6.1.2-Carbo Released: (Note: This is a VC9 version of 5.7.2-Nano) Core components: Apache 2.2.17 MySQL 5.5.8 PHP 5.3.5 phpMyAdmin 3.3.9 Go-Pear 1.1.2 msmtp 1.4.23 - Update eAccelerator 1.0-snv427 - Update WinBinder 2010.10.14 Bug fixes: - MySQL ini corrected defaults to UTF8 - updated go-pear.php - Updated openssl.cnf - Minor change to server certificate script - mysql service force config file - pear confg now tracks server location - corrected PHP development ini spelling - OpenSSL updated to 1.0.0c - Update Note: For completeness UniServer 5.7.2_5217-Nano Released: Core components: Apache 2.2.17 MySQL 5.5.8 PHP 5.2.17 phpMyAdmin 3.3.9 Go-Pear 1.1.2 msmtp 1.4.23 - Update eAccelerator 1.0-snv427 - Update Bug fixes: - MySQL ini corrected defaults to UTF8 - updated go-pear.php - Updated openssl.cnf - Minor change to server certificate script - mysql service force config file - pear confg now tracks server location - corrected PHP development ini spelling Download: UniServer 5.7.2-Nano UniServer 6.1.2-Carbo UniServer 5.7.2_5217-Nano Regards, The Uniform Server Development Team

If you want to correct the file name in tray menu there is no need to re-compile Edit the tray menu configuration file: UniServer\unicon\tray_menu\UniTray1.ini and change the file name accordingly “Please let us know when this change is reflected in new unitray code.” New version release this weekend! All the best Ric

Uniform Server PHP IDE updated release. There are two versions plugin and standalone. Plugin: Allows you to develop and debug web pages directly on Uniform Server. Installs on either Nano or Carbo series. File: us_plugin_php_ide_1_0_2.exe Standalone Runs independently of Uniform Server. This allows you to develop and debug PHP CLI scripts. It contains an integrated console and PHP interpreter making it ideal for learning PHP. File: us_portable_php_ide_1_0_3.exe Plugin – Core components Notepad++ Core to 5.8.7 - Updated NppExec_041_dll_Unicode Plugin DBGpPlugin_0_12b_dll Plugin php_xdebug-2.1.0-5.2-vc6.dll - Added php_xdebug-2.1.0-5.3-vc6.dll php_xdebug-2.1.0-5.3-vc9.dll Standalone portable PHP IDE – Core components Notepad++ Core 5.8.7 - Updated PHP to 5.3.5 VC9 NppExec_041_dll_Unicode Plugin DBGpPlugin_0_12b_dll Plugin WinBinder 2010.10.14 PHP Extension php_xdebug-2.1.0-5.2-vc6.dll - Added php_xdebug-2.1.0-5.3-vc6.dll php_xdebug-2.1.0-5.3-vc9.dll Download: SourceForge links: Plugin Standalone Wiki Support: Install and configuration PHP IDE Design notes Both releases now include missing licence for Xdebug Regards, The Uniform Server Development Team

Hey! If you need to correct spellings there is no lack of communication. It is a well-known fact it is impossible to check your own work for errors. Thanks for pointing out the spelling error. "It's a minor point but if your batch file attempts to write to this file, or you use php to do file editing, it will fail unless the name is misspelled in both places..." Yep! Misspelling was perpetuated hence self-correcting in terms of functionality. Interestingly while correcting the above spelling noticed a potential bug. Anyone reading this post, may at first think your comment pedantic however detail is all-important? Most appreciated and highlighted a potential bug. All the best Ric

It looks as if you hand coded the Vhost section! Not a problem however you removed the default Vhost and a line that enables vhosts. Your vhost section should look similar to the following: NameVirtualHost * #====== DEFAULT VIRTUAL HOST =========== # LOCALHOST <VirtualHost *> ServerName localhost:80 DocumentRoot C:/UniServer/www </VirtualHost> ### Section 4: Secure section <IfModule mod_ssl.c> Include conf/ssl.conf </IfModule> ##########VIRTUAL HOST SETUP########## # SUNSHINESTATEDATES.COM <VirtualHost *> ServerName www.sunshinestatedates.com ServerAlias sunshinestatedates.com DocumentRoot c:/UniServer/www/sunshinestatedates </VirtualHost> ##########VIRTUAL HOST SETUP########## # SOLDIERSNETWORKS.COM <VirtualHost *> ServerName www.soldiersnetworks.com ServerAlias soldiersnetworks.com DocumentRoot C:/UniServer/www/soldiersnetworks </VirtualHost> This line enables vhost : NameVirtualHost * The default section is used when Apache cannot find a match. If you delete this section the first Vhost becomes the default. #====== DEFAULT VIRTUAL HOST =========== # LOCALHOST <VirtualHost *> ServerName localhost:80 DocumentRoot C:/UniServer/www </VirtualHost> Local testing: You can test your websites locally with the following urls: http://soldiersnetworks.com/ http://www.soldiersnetworks.com/ http://sunshinestatedates.com/ http://www.sunshinestatedates.com/ Your browser needs to resolve the above to IP addresses hence you require the following entries in your host file: C:\WINDOWS\system32\drivers\etc\hosts 127.0.0.1 localhost 127.0.0.1 www.sunshinestatedates.com 127.0.0.1 www.soldiersnetworks.com 127.0.0.1 sunshinestatedates.com 127.0.0.1 soldiersnetworks.com Test from another PC (Intranet): You can test from another PC that is networked. First you need to enable external access by editing this file: UniServer\www\.htaccess Change this section: Order Deny,Allow Deny from all Allow from 127.0.0.1 To: # Order Deny,Allow #Deny from all #Allow from 127.0.0.1 The remote PC browser needs to resolve the following http://soldiersnetworks.com/ http://www.soldiersnetworks.com/ http://sunshinestatedates.com/ http://www.sunshinestatedates.com/ to your IP addresses 192.168.1.6 Hence the remote PC requires the following entries in their host file: 192.168.1.6 www.sunshinestatedates.com 192.168.1.6 www.soldiersnetworks.com 192.168.1.6 sunshinestatedates.com 192.168.1.6 soldiersnetworks.com Note: Assumes your IP (192.168.1.6) is static Internet access: Edit file UniServer\www\.htaccess as explained above. Configure your router to port forward (port 80) to your internal IP address 192.168.1.6 Ensure the above domains point to your external IP address. All the best Ric

Drupal state the following: For Apache, you will need to make sure php_pdo.dll and php_pdo_mysql.dll exist in the php/ext directory, un-comment or add the appropriate lines in php.ini, and restart the web server. Note: The php_pdo.dll is pre-compiled into PHP 5.3.5 hence will not appear in the extensions folder. Extension php_pdo_mysql.dll exists in the extensions folder however it needs to be enabled in php.ini configuration file. To enable perform the following: Edit file: UniServer\usr\local\php\php.ini Locate this line: ;extension=php_pdo_mysql.dll Un-comment the line (remove ; ) as shown below: extension=php_pdo_mysql.dll Enable InnoDB Otherwise you will receive this error: Syntax error or access violation: 1286 Unknown storage engine 'InnoDB' Edit file: UniServer\usr\local\mysql\my.ini Locate this line: skip-innodb Comment line (add #) as shown below: #skip-innodb Finally: During installation use a real e-mail address otherwise install will fail. Tested on: Nano 5.7.1 Drupal 7.0 All the best Ric

It looks as if go-pear.php v1.1.2 remains the latest version (as per Pear web-site). However core and other elements have been updated while go-pear has been neglected. Solution is to edit file: UniServer\home\admin\www\plugins\pear\go_pear.php Locate this section: 'PEAR.php' => 'http://svn.php.net/viewvc/pear/pear-core/branches/PEAR_1_4/PEAR.php?view=co', 'Archive/Tar.php' => 'http://svn.php.net/viewvc/pear/packages/Archive_Tar/tags/RELEASE_1_3_2/Archive/Tar.php?view=co', 'Console/Getopt.php' => 'http://svn.php.net/viewvc/pear/pear-core/branches/PEAR_1_4/Console/Getopt.php?view=co', Change as shown below: 'PEAR.php' => 'http://svn.php.net/viewvc/pear/pear-core/branches/PEAR_1_6/PEAR.php?view=co', 'Archive/Tar.php' => 'http://svn.php.net/viewvc/pear/packages/Archive_Tar/tags/RELEASE_1_3_3/Archive/Tar.php?view=co', 'Console/Getopt.php' => 'http://svn.php.net/viewvc/pear/pear-core/branches/PEAR_1_6/Console/Getopt.php?view=co', All the best Ric

Hi nikudza try the following. Navigate to folder: UniServer\usr\local\mysql Edit file: my.ini Change this section: [mysqld] port=3306 server-id = 1 pid-file=mysql.pid default-storage-engine=MYISAM skip-external-locking To the following: [mysqld] port=3306 server-id = 1 pid-file=mysql.pid character-set-server=utf8 default-storage-engine=MYISAM skip-external-locking All the best Ric

It is difficult to change tray icon to match server’s current running state hence will not be implemented in the current releases. However the Carbo series uses tri-state menu buttons providing user feedback. Run the latest Carbo and see if that meets your requirements. Tray numbers 1 to 9 identify an instance of Uniform Server. You can run more than one instance of Uniform Server at the same. Default is number one this uses standard server ports. For details check out the following: http://wiki.uniformserver.com/index.php/5....:_Multi-Servers A more up to date write up can be found here: http://bobstrand.com/totm/2010/05/05/running-multiple-wamps/ All the best Ric

UniServer 5.7.1_5217-Nano Released: This one-off release is a downgrade of 5.7.1-Nano. Components: Apache 2.2.17 MySQL 5.5.8 PHP 5.3.5 – Downgraded to PHP 5.2.17 phpMyAdmin 3.3.9 Go-Pear 1.1.2 msmtp 1.4.21 eAccelerator 1.0-snv425 Download: UniServer 5.7.1_5217-Nano All the best Ric

PHP has released 5.2.17 this release marks the end of support for PHP 5.2 series. PHP strongly advise to update to this version immediately. Ideally you should downgrade the latest release of Uniform Server this allows any security updates for other components to be retained. This one-off release is a downgrade of 5.7.1-Nano. Components: Apache 2.2.17 MySQL 5.5.8 PHP 5.3.5 – Downgraded to PHP 5.2.17 phpMyAdmin 3.3.9 Go-Pear 1.1.2 msmtp 1.4.21 eAccelerator 1.0-snv425 Download: UniServer 5.7.1_5217-Nano All the best Ric

Standalone portable PHP IDE – Updated File: us_portable_php_ide_1_0_2.exe Core components: Notepad++ Core 5.8.5 NppExec_041_dll_Unicode Plugin DBGpPlugin_0_12b_dll Plugin WinBinder 2010.10.14 PHP Extension PHP 5.3.5 VC9 - Update Download: SourceForge link: Standalone All the best Ric

UniServer 5.7.1-Nano Released: Apache 2.2.17 MySQL 5.5.8 PHP 5.3.5 -- Update phpMyAdmin 3.3.9 -- Update Go-Pear 1.1.2 msmtp 1.4.21 eAccelerator 1.0-snv425 UniServer 6.1.1-Carbo Released: (Note: This is a VC9 version of 5.7.1-Nano) Apache 2.2.17 MySQL 5.5.8 PHP 5.3.5 -- Update phpMyAdmin 3.3.9 -- Update Go-Pear 1.1.2 msmtp 1.4.21 eAccelerator 1.0-snv425 WinBinder 2010.10.14 Download: UniServer 5.7.1-Nano UniServer 6.1.1-Carbo Regards, The Uniform Server Development Team

To explicitly release a drive letter (W). First Stop Uniform Server Enter the following command into a command window: subst W: /D Alternatively create a new batch file containing the above line. All the best Ric

Please note Active Support for MySQL series 5.1 ends on 2010-12-31 New production series is 5.5, official production release is version 5.5.8 (Released 2010-12-15) References http://www.mysql.com/about/legal/lifecycle/ http://olex.openlogic.com/packages/mysql/5.5.8 Uniform Server has been updated to use the official release of MySQL UniServer 5.7.0-Nano Released: Apache 2.2.17 MySQL 5.5.8 -- Update PHP 5.3.4 phpMyAdmin 3.3.8.1 Go-Pear 1.1.2 msmtp 1.4.21 eAccelerator 1.0-snv425 UniServer 6.1.0-Carbo Released: (Note: This is a VC9 version of 5.7.0-Nano) Download: UniServer 5.7.0-Nano UniServer 6.1.0-Carbo Merry Xmas Regards, The Uniform Server Development Team

This really is a pain continued! http://forums.zend.com/viewtopic.php?f=57&t=1365 It appears Zend Optimizer has been renamed ZendLoader Hence path required in php.ini file is: [Zend] zend_extension=C://ZendLoader.dll This would have been fine however the binary is non-thread safe VC9. Hence will not run on either the Nano or Carbo series. The above issue is covered in this post: http://forums.zend.com/viewtopic.php?f=57&t=8721 All the best Ric