Ric

With this error "pear is not recognized as an internal or external command, an executable file or a batch file” Means you have not installed pear correctly try this: Open a command window and type whats in bold: C:\>w: W:\>cd usr\local\php W:\usr\local\php>php -r "readfile('http://pear.php.net/go-pear');" > go-pear W:\usr\local\php>php go-pear Welcome to go-pear! Go-pear will install the 'pear' command and all the files needed by it. This command is your tool for PEAR installation and maintenance. Use 'php go-pear local' to install a local copy of PEAR. Go-pear also lets you download and install the PEAR packages bundled with PHP: MDB2. If you wish to abort, press Control-C now, or press Enter to continue: Enter HTTP proxy (http://user:password@proxy.myhost.com:port), or Enter for none:: Enter Below is a suggested file layout for your new PEAR installation. To change individual locations, type the number in front of the directory. Type 'all' to change all of them or simply press Enter to accept these locations. 1. Installation prefix : W:\usr\local\php 2. Binaries directory : $prefix 3. PHP code directory ($php_dir) : $prefix\pear 4. Documentation base directory : $php_dir\docs 5. Data base directory : $php_dir\data 6. Tests base directory : $php_dir\tests 7. Temporary files directory : $prefix\temp 8. php.exe path : W:\usr\local\php\php.exe 1-8, 'all' or Enter to continue: Enter The following PEAR packages are bundled with PHP: MDB2. Would you like to install these as well? [Y/n] : y Loading zlib: ok Downloading package: PEAR-stable......ok Downloading package: Archive_Tar-stable....ok Downloading package: Console_Getopt-stable....ok Downloading package: XML_RPC-stable....ok Bootstrapping: PEAR...................(remote) ok Bootstrapping: Archive_Tar............(remote) ok Bootstrapping: Console_Getopt.........(remote) ok Downloading package: MDB2.............ok Extracting installer..................ok warning: pear/PEAR requires package "pear/Archive_Tar" (version >= 1.3.1) warning: pear/PEAR requires package "pear/Console_Getopt" (version >= 1.2) pear/PEAR can optionally use package "pear/XML_RPC" (version >= 1.4.0) pear/PEAR can optionally use package "pear/PEAR_Frontend_Web" (version >= 0.5.0) pear/PEAR can optionally use package "pear/PEAR_Frontend_Gtk" (version >= 0.4.0) pear/PEAR can optionally use package "pear/PEAR_Frontend_Gtk2" (version >= 0.1.0 ) install ok: channel://pear.php.net/PEAR-1.4.11 install ok: channel://pear.php.net/Archive_Tar-1.3.1 install ok: channel://pear.php.net/Console_Getopt-1.2 install ok: channel://pear.php.net/XML_RPC-1.5.1 install ok: channel://pear.php.net/MDB2-2.3.0 ****************************************************************************** WARNING! The include_path defined in the currently used php.ini does not contain the PEAR PHP directory you just specified: If the specified directory is also not in the include_path used by your scripts, you will have problems getting any PEAR packages working. Would you like to alter php.ini ? [Y/n] : y php.ini include_path updated. Current include path : .;\usr\local\PHP\includes;\usr\local\PHP\pear Configured directory : W:\usr\local\php\pear Currently used php.ini (guess) : W:\usr\local\php\php.ini Press Enter to continue: Enter The 'pear' command is now at your service at w:\usr\local\php\pear.bat ** The 'pear' command is not currently in your PATH, so you need to ** use 'w:\usr\local\php\pear.bat' until you have added ** 'W:\usr\local\php' to your PATH environment variable. Run it without parameters to see the available actions, try 'pear list' to see what packages are installed, or 'pear help' for help. For more information about PEAR, see: http://pear.php.net/faq.php http://cvs.php.net/co.php/pearweb/doc/pear...manager.txt?p=1 http://pear.php.net/manual/ Thanks for using go-pear! * WINDOWS ENVIRONMENT VARIABLES * For convenience, a REG file is available under W:\usr\local\php\PEAR_ENV.reg . This file creates ENV variables for the current user. Double-click this file to add it to the current user registry. W:\usr\local\php> Repeat this: If you have installed Pear correctly you probably are running the command from the wrong location! Change to the php folder W: cd usr\local\php A quick check type in pear – help will list all the help commands for pear with this confirmed type your command in: pear channel-discover pear.symfony-project.com

The error message is the results of coding in the index.php template files when you directly access this file by typing into you browser some_ip_address/index.php you get the error message. The pages can only be accessed via a valid top-level index path such as the index.html page. I think the problem you are observing is the fact you have gone live with your site and downloading templates from Siteground at http://www.siteground.com/joomla-hosting/j...a-templates.htm Which expects a valid path for your live site however your path is probably set for a local test site! (This looks like a direct access from an external source) Edit the configuration file configuration.php located in folder W:\www\joomla with a suitable text editor. Change the line: $mosConfig_live_site = 'http://localhost/joomla'; To something like: $mosConfig_live_site = 'http://www.yourlivesite.com/joomla'; Well give that a bash and see if it works. All the best Mike

PS I deleted your second topic post to keep the subject in one place

I have never used stored procedures however that is no excuse. I had a quick look and as you rightly pointed out “table mysql.proc” does not exist. Without this you cannot run procedures. Well always game for a laugh I thought I would have a go at breaking a new installation of UniServer by fixing the mysql privilege table. By the way this also adds the mysql.proc table and a few other things. I have not fully tested this so please perform this on a new installation and test it to see if it meets your expectation it may break other things. However if you are prepared to get your hands dirty here is a blow-by-blow account. 1) You need a copy of mysql_fix_privilege_tables.sql The only way I found of obtaining this was to download a complete up to date MySQL file set. Go to : http://dev.mysql.com/downloads/mysql/5.0.html#downloads And download the file associated with this name “Without installer (unzip in C:\)” it is a large download (50M) save it in any folder you wish. 2) Unzip the file mysql-noinstall-5.0.27-win32.zip accept the defaults (unzips to the folder you saved it in. 3) Run both your servers. 4) Create a new folder in w:usr\local\mysql\ named scripts 5) Copy the file mysql_fix_privilege_tables.sql From: *\mysql-noinstall-5.0.27-win32\mysql-5.0.27-win32\scripts\ To: W:\ usr\local\mysql\scripts\ Note: * is thefolder you performed the unzip operation. 6) Open a command prompt window (start>run>cmd) and type in: w: followed by cd usr\local\mysql You will see the prompt looks like this W:\usr\local\mysql> this just informsyou where you are. 7) Type the following where highlighted (bold). I have included some of the results you will receive. W:\usr\local\mysql>bin\mysql -u root -p mysql Enter password: **** Note:The default is root[/i] Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 20 to server version: 5.0.17 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> SOURCE scripts/mysql_fix_privilege_tables.sql Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected, 1 warning (0.09 sec) ERROR 1060 (42S21): Duplicate column name 'File_priv' Query OK, 0 rows affected (0.00 sec) +------------------+ | @hadGrantPriv:=1 | +------------------+ | 1 | | 1 | +------------------+ 2 rows in set (0.00 sec) ERROR 1060 (42S21): Duplicate column name 'Grant_priv' ERROR 1060 (42S21): Duplicate column name 'Grant_priv' ERROR 1054 (42S22): Unknown column 'Type' in 'columns_priv' ERROR 1060 (42S21): Duplicate column name 'type' Query OK, 0 rows affected (0.00 sec) +-------------------+ | @hadShowDbPriv:=1 | +-------------------+ | 1 | | 1 | +-------------------+ 2 rows in set (0.00 sec) ERROR 1060 (42S21): Duplicate column name 'Show_db_priv' Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.08 sec) Records: 0 Duplicates: 0 Warnings: 0 Query OK, 0 rows affected (0.00 sec) ERROR 1054 (42S22): Unknown column 'Create_view_priv' in 'where clause' Query OK, 1 row affected (0.11 sec) Records: 1 Duplicates: 0 Warnings: 0 Query OK, 0 rows affected (0.06 sec) Records: 0 Duplicates: 0 Warnings: 0 mysql> exit Bye W:\usr\local\mysql> 8) Stop and restart your MySQL server. Thats it have fun. I am not sure if that will help and what bits I have missed, would be nice for some one to come back and explain any other bits that are required. Note: I had PHPGlossar Version 0.8 installed in the database at the time of upgrading it did not kill this application off. Note: Tested on OS Windows XP home SP2 did you know that 40% (Mostly corporate) still use SP1 and that support for this has been withdrawn? All the best Mike

The path remains set only during an active command window session once you close this window the path is lost and you need to run the batch file again in every new CMD window. If you find this to be a pain set the Windows path permanently (well you can change it back at any time). Command line interface: Update How to add php.exe path to the Windows PATH environment variable. 1) Start > Control panel 2) Switch to classic view (top left) 3) Click on system 4) Select Advance tab 5) Click on Environment Variables button 6) Highlight “Path” in “System variables” and click Edit button 7) The Edit System Variable box is displayed. Click in the “Variable value” window. Move cursor to the end of whatever is already there and add the path: ;w:\usr\local\php 8) Click OK and OK again OK to finish To see what is in the PATH variable, open a command window (start > run > cmd) and enter "echo %PATH%". Note: If you already have a CMD window open close it. Open a new one and the new path will be picked up. ------- I never had time to address the Stunnel issue because I was in the process of writing a few notes to explain its installation. “I'm still a bit confused about the Stunnel/OpenSSL other issue I mentioned in the post as well...” This may or may not help: http://center.uniformserver.com/stunnel/stunnel_1_intro.html All the best

Hi Megan, Not every one knows about this why like myself would they be looking for cakes lol. Well now I know how to bake cakes and in the process picked up a few tips well worth a read. All the best Mike

If you have installed Pear correctly you probably are running the command from the wrong location! Change to the php folder W: cd usr\local\php A quick check type in pear – help will list all the help commands for pear with this confirmed type your command in: pear channel-discover pear.symfony-project.com W:\usr\local\php>pear channel-discover pear.symfony-project.com Adding Channel "pear.symfony-project.com" succeeded Discovery of channel "pear.symfony-project.com" succeeded I tested it see above All the best

I gave the script a road test to see what it does, only to discover not a great deal. I bashed it a little more these are the changes I made. To give you a clue I have posted the relevant pieces of code the changes are obvious when compared to the original. I have add $_GET, $_POST and changed the compare in most places. 1)\www\phpglossar_0.8\admin\index.php $menue_do = $_GET['menue_do']; if ($menue_do != "") { $do = "inc/"; $do .= $menue_do; $do .= ".php"; 2) add_action.php <?php require("../connect.php"); $word = $_POST['word']; $definition = $_POST['definition']; //Fixes Input-Bugs for the Word 3) change_action.php <?php $uid = $_GET['uid']; $result = mysql($db_name,"select * from $table where uid='$uid'"); 4) delete_action.php <?php $uid = $_GET['uid']; //Deletes Newsentry from Database 5)show_action.php <?php $uid = $_GET['uid']; $result = mysql($db_name,"select * from $table where uid='$uid'"); 6) change_action2.php <?php require("../connect.php"); //Fixes Input-Bugs for the Word $change_word = $_POST['change_word']; $change_definition = $_POST['change_definition']; $uid = $_POST['uid']; if ($change_word == "") 7)\www\phpglossar_0.8\index.php // Here is set the start up look of Glossary - first_letter comes from config_style.inc $letter = $_GET['letter']; $word = $_POST['word']; I have probably missed something fundemental just seems strange the need to do this. Ho well it was just a hack to get it working. PHPGlossar Version 0.8 version_date = "2002" It could be old code that I downloaded however it was off the authors site. Well have fun

I could not leave this one alone. Managed to download the script. Well since you are seeing the menu selections and have no problems with the database you must have got the file structure correctly in place should look like this: UniServer3_3\Uniform Server\diskw\www\phpglossar_0.8\ UniServer3_3\Uniform Server\diskw\www\phpglossar_0.8\admin\ UniServer3_3\Uniform Server\diskw\www\phpglossar_0.8\admin\inc The links when hovered over should be like this: http://localhost/phpglossar_0.8/admin/inde...p?menue_do=show http://localhost/phpglossar_0.8/admin/index.php?menue_do=add As you have found the links do not work you need to open the file index.php located in folder \UniServer3_3\Uniform Server\diskw\www\phpglossar_0.8\admin Change the code from this: if ($menue_do "") { $do = "inc/"; $do .= $menue_do; $do .= ".php"; }else{ To this: $menue_do = $_GET['menue_do']; if ($menue_do != "") { $do = "inc/"; $do .= $menue_do; $do .= ".php"; }else{ You will now find the links work. Like I said 0.8 is still beta and contains this small error the rest appears to work OK although I have not tested it. All the best

Stunnel is an excellent plugin uses openSSL allows you to quickly product a secure HTTPS server. The lack of documentation, no longer an excuse for not using it check out this page: http://center.uniformserver.com/stunnel/stunnel_1_intro.html It includes a step-step installation guide followed by how to up-grade Stunnel (recommended before using it). I found a few problems with Windows XP home these I have been resolved not an elegant solution but seems to work.

Welcome back Olajide I would like add my sixth penith, my comments may seem obvious however if not stated will never be recorded. 1) It must remain a production server with all security in place straight out of the box. 2) No extraneous bells or whistles by this I mean if you buy a washing machine that has a thousand and one programs and you only use three tops you are catering for a sales person and not the end user. 3) All goodies that are bolted on shall work with no interaction problems and work across all platforms stated. Well my friend 1) and 2) extremely hard work but not impossible. Three poses an intellectual and logistics challenge, software compatible and testing on all platforms for that number of plugins? Laying down such a gauntlet will be fun. Well I am game will be interesting to see what the real requirement spec is. All the best Mike

First port of call is this page: http://center.uniformserver.com/wiki/wikka_wiki.html Another page http://center.uniformserver.com/joomla_ins..._install_1.html They deal with what you require All the best Mike

I have done a quick Goggle for this program it would appear you are not the only one with this problem. I would have downloaded the program to test but was faced with a German site so I was completely lost. Uni Server is working correctly because you were able to create the database. I scanned over one of the links and my instant reaction is they look wrong! http://localhost/phpglossar_0.8/phpglossar...p?menue_do=show I could be wrong but if there is nothing in the first phpglossar_0.8 folder other than the second (phpglossar_0.8 folder) then I think it has been installed incorrectely. If you could supply a download link I will give it a bash. I saw mentioned that 0.8 is still beta this could be the problem.

You will find this page may help http://center.uniformserver.com/uniserver/..._uniserver.html

Steps in detail: 1) Open Apache configuration file and change the listening port UniServer3_3\Uniform_Server\diskw\usr\local\apache2\conf\httpd.conf Change the line: Listen 80 to Listen 8000 2) Open .htaccess UniServer3_3\Uniform_Server\diskw\www\.htaccess Change the IP access address from 127.0.0.1 to 127.0.0.100 Order Deny,Allow Deny from all Allow from 127.0.0.100 This will allow you to run the test file as follows. http://127.0.0.100:8000/test.html Note: Apanel will not display because re-direct needs forcing to port 8000 in addition admin htaccess file needs changing. I will cover this a little later. 3) Memorable name instead of using 127.0.0.100:8000 lets use fred:8000 The name “fred” needs resolving to achieve this add it to the hosts file: C:\WINDOWS\system32\drivers\etc\ hosts The entry looks like this: 127.0.0.100 fred 4) Open file redirect.html UniServer3_3\Uniform_Server\diskw\home\admin\www\ redirect.html Change the line: window.setInterval("window.location = 'http://localhost/apanel/'", 500); To: window.setInterval("window.location = 'http://fred:8000/apanel/'", 500); If you re-run the servers you will receive a forbidden error message because you need to change the admin htaccess file: UniServer3_3\Uniform_Server\diskw\home\admin\www\.htaccess Order Deny,Allow Deny from all Allow from 127.0.0.100 5) Recap With the changes so far you can type the following to run your test page: http://fred:8000/test.html OR fred:8000/test.html To make it slightly shorter use port 81 instead of 8000 You could force your browser to use another port say 8000 instead of 80 hence the above would reduce to fred/test.html. I have never seen this option on any browser that I have used hence you are forced to enter it manually. Well that turned into a ramble hope some of it helped. I am sure to have missed something so be prepared to change some other files.

I think this is still true: http://forum.uniformserver.com/index.php?showtopic=237

I am glad you resolved your problem; I have no problem with that. The real problem I have is what is the underlying mechanism causing it. To port forward port 3306 means you want to run MySQL as a separate instance (a MySQL server in its own right as a separate server). When you say, “this web server thing is all local” true for a local test server but when you put it on line Apache is on line! MySQL remains local however you have chosen to forward 3306 I am thinking secure it.

When using Server_Start.bat and starting MySql from apanel (Run MySql) you may receive this message: MySQL said: #2003 - The server is not responding This is because the MySql server is not running Cause the dreaded http_refer problem check this page out: http://center.uniformserver.com/uniserver/...er_problem.html Note: If you use Disk Start.vbs it will force MySql server to start.

I am not sure what you require but if you type this into your browsers address bar: http://127.0.0.1/test.html you will receive from your machine that test page (assuming the file is in folder www) 127.0.0.1 is the standard IP address used for a loopback network connection that means your machine. The same result can be obtained by typing in http://localhost/test.html note localhost will be resolved to 127.0.0.1 via your host file. Note: 127.0.0.1 is the most common address for localhost, however any IP address in the range 127.*.*.* can be used (see RFC 3330: Special-Use IPv4). Hence the specific address 127.0.0.100 is valid for a local loop back. So typing in http://127.0.0.100/test.html will bring up that test page. However the default instalation of Uniserver will not allow this. Because the htaccess file contained in folder www restricts access to only 127.0.0.1 to allow acess to 127.0.0.100 either modify that line or add a new line to your htaccess file eg # This file provides security to the server limiting access to the localhost only. # Comment to deactivate. Order Deny,Allow Deny from all Allow from 127.0.0.1 Allow from 127.0.0.100 Note: Deny from all ... means no one is allowed access The next two lines allow access to IP address 127.0.0.1 and 127.0.0.100 all other IP addresses will be denied access. With those changes and your port change the complete address to access the page will look like: http://127.0.0.100:8000/test.html It would be interesting for others to know why you want to do this. Have fun

Well not sure what you are looking for but do a google search for: htaccess and you will receive 16 million hits such as http://www.javascriptkit.com/howto/htaccess.shtml and http://www.freewebmasterhelp.com/tutorials/htaccess hope that helps

I agree that a non-configured Uniform Server would be smart for your specific application however think of the consequences. Anyone wishing to use UniformServer straight out of the box would need to configure it. All software comes pre-configured by virtue that defaults are used if none supplied. In this respect Uniform Server is no different hence default port 80 this is configurable in control panel. Since you need to run two instances of UniServer at the same time, to prevent conflicts one of these require modification. If they do not need to coexist at the same time the problem does not arise you can switch one off before running the other?

Sounds like a fun thing to do never tried this but I see no reason why you cannot have more than one instance of Apache running. Almost sure there will be a conflict with MySQL and PHPmyAdmin. The conflict with Apache is easy to resolve run it on another listening port for example 8080. Let the development machines run on disk W and force USB version to run on disk X. The start bat on USB stick will attempt to kill off Apache so REM these lines out. The redirection for apanel needs to be changed to port 8080. I think that will get Apache working. As for MySQL you can run more than one instance of this not sure of the details however it is irrelevant if you cannot get Apache working so try that first. It is a matter of taken it one step at a time. Well have fun.

That Solution I do like Thanks Shamanm

Skype is a pain because of this: http://en.wikipedia.org/wiki/List_of_TCP_a...DP_port_numbers Bottom line it will not go away so we must live with it!

1) The security warnings in red do remain even when you have changed usernames and passwords. 2) You correctly observed that disk W is created when the server starts and is destroyed when you stop the servers. The drive letter W (Disk) created is a virtual drive meaning it does not physically exist in reality it is a mapping to where the real server was installed. This allows you to move the real server to any location and when you run the servers the virtual drive will appear unchanged. The virtual drive acts and appears like a real disk drive if you create a folder or load your web site into the folder W:\www the folder will be created and your website will be loaded into W:\www. It looks like a real drive but what you have really changed is the real server contents. Hence when you stop the server you do not loose your changes. If you change the original www folder contents these will be reflected in drive W when you start the servers. The point is that with the servers running you can use either the original or the virtual drive to load your test site (folder www) because they are the same thing. The test site will be saved in the orignal server location regardless. Another way to view drive W is that it acts as short cuts to the original. Move the original onto a memory stick and run the servers from it. Drive W will be created change anything in Drive W and it will be saved to you memory stick. Close the servers down, drive W dissaperas however any changes you made will still be on the memory stick. Note: You can create as many servers as you like you currently have a folder named test server. Create a new folder named test1 and copy all the contents from your test server into it. Run your servers from this folder change things in W check to see what happens to the content of test1, will reflect whatever you done however these will not be reflected in you original test server folder. Hence when you break test1 just delected it and use your original folder. My point; have a play and have fun if you break it just use another working copy.