Jump to content
The Uniform Server Community


  • Content Count

  • Joined

  • Last visited

Everything posted by Nicero

  1. If you wish to install PostgreSQL and make it work with Uniform Server you may find useful the following guidelines. 1. Stop UniformServer (Apache and MySql) from running 2. Download PostgreSQL latest stable release for Windows (these guildelines apply to version 9.5.3) 3. Download PhpPgAdmin (which is the PhpMyAdmin for PostgreSQL) 4. Launch PostgreSQL installer and choose the Uniform 'core' folder (\UniServerZ\core) as PostgreSQL installation folder. Default username is postgres. 5. Once installed you may rename the folder with a shorter name for ex. 'postgres' 6. Open httpd.conf (\[uniformServer_path]\core\apache2\conf) and add the following line to the and of the file: LoadFile "\[uniformServer_path]\core\[postgres_path]\bin\libpq.dll" 7. Unzip PhpPgAdmin into the Uniform Server www path 8. If you wish, rename PhpPgAdmin folder to a shorter name 9. Open PhpPgAdmin configuration file config.inc.php (PhpPgAdmin/conf/) and change the two following lines as below: $conf['servers'][0]['host'] = 'localhost'; $conf['extra_login_security'] = false; 10. Enable PostgreSQL PHP extensions using the Uniform Server systray console: Menu PHP -> Edit Basic and Modules -> PHP Modules Enable/Disable php_pdo_pgsql.dll php_pgsql.dll 11. Start PostgreSQL. PostgreSQL must be started and stopped using its console. Go to \[uniformServer_path]\core\[postgres_path]\scripts\ and start PostgreSQL: serverctl.vbs start serverctl.vbs has other parameters: serverctl.vbs reload|wait|start|stop 12. Start Apache as usual from the Uniform console. 13. Open the browser and type: http://localhost/[phppgadmin_path]/ Use the default postgres user chosen during installation or any other user set and the chosen password to login in PhpPgAdmin. These installation guidelines work properly even if you are keeping all Uniform Server installation and your work on a portable USB harddisk as I do. In this case you may delete from your Windows Start menu all the references to the PostgreSQL installation.
  2. Please update MySQL to version 5.7 as starting from this version MySQL added the important support to JSON.
  3. SOLVED by changing files permissions to 'Everyone' to the whole HD.
  4. I'm developing some PHP scripts. I installed UniformZ on a portable USB HD so I can carry it from work to home and viceversa. I noticed that at home (Windows 10) I have to launch Uniform as administrator to make it work). The weird thing is that the files inside the \www folder must be opened with the Administrator priviledges too. Not only I need to run Uniform.EXE as administrator but every PHP file has to be loaded in Notepad++ as administrator. Although I don't understand why I have to run these as administrator, at least it works. The fact is that I'm working with Excel files and these have to be opened as Administrator too or better, I have to run Excel as administrator and then open the XLS file from Excel (because there is no "Run as administrator" item in the right-click menu when clicking on a XLS file). Nothing of the above happens on my Windows 7 work PC. How can I avoid the use of the administrator proviledges? Thank you.
  5. Hi Bob! Yes you're right, it's exactly what happened: I locked my keys inside the car! I did as you suggested and it worked perfectly. Thank you. Regards, Enrico
  6. I'm using Coral 8.5.2. I accidentally deleted the 'root' MySQL account from PHPmyAdmin and now I get the error: #1045 - Access denied for user 'root'@'localhost' (using password: YES) I tried every solution I read about but I still can't access PHPmyAdmin. This I what I've tried so far: 1. Restore MySQL password via Coral interface: Server configuration -> MySQL -> Restore password 2. Change MySQL password to 'root' via Coral interface: Server configuration -> MySQL -> Change password 3. Edit PHPMyAdim config.inc.php which now is as follows: $cfg['Servers'][$i]['auth_type'] = 'config'; $cfg['Servers'][$i]['user'] = 'root'; $cfg['Servers'][$i]['password'] = $password; $cfg['Servers'][$i]['AllowNoPassword'] = false; But I also tried the following combinations: $cfg['Servers'][$i]['auth_type'] = 'cookie'; $cfg['Servers'][$i]['user'] = 'root'; $cfg['Servers'][$i]['password'] = 'root'; $cfg['Servers'][$i]['AllowNoPassword'] = true; Nothing worked. I'm using Windows XP and I'm working locally. Any help, please?
  • Create New...