Jump to content
The Uniform Server Community

Nicero

Member
  • Posts

    7
  • Joined

  • Last visited

Previous Fields

  • Main OS
    Windows 7

Nicero's Achievements

Newbie

Newbie (1/14)

  • Conversation Starter
  • Week One Done Rare
  • One Month Later Rare
  • One Year In Rare

Recent Badges

0

Reputation

  1. These errors are probably due to the fact that UniController was not closed properly before exiting the program and MySQL left behind some fail-safe "trackers" that should recover the status of MySQL when a new connection is established but this does not work in a WAMP environment. Before switch off Apache and MySQL from UniController, then close UniController.exe The solution is to delete in \core\mysql\data the files (make a backup copy of the files before deleting them) ib_logfile0 ib_logfile1 auto.cnf *.err *.pid As this issue happend to me very very frequently despite carefully closing UniController interface I wrote a simple .BAT file that does the job. Copy/paste the following code into a file such as repair.bat and save it in the same folder of UniController.exe: cd core/mysql/data IF EXIST _auto.cnf ( DEL _auto.cnf REN auto.cnf _auto.cnf ) ELSE ( REN auto.cnf _auto.cnf ) IF EXIST _ib_logfile0 ( DEL _ib_logfile0 ren ib_logfile0 _ib_logfile0 ) ELSE ( ren ib_logfile0 _ib_logfile0 ) IF EXIST _ib_logfile1 ( DEL _ib_logfile1 ren ib_logfile1 _ib_logfile1 ) ELSE ( ren ib_logfile1 _ib_logfile1 ) IF EXIST _mysql.err ( DEL _mysql.err ren mysql.err _mysql.err ) ELSE ( ren mysql.err _mysql.err ) When the access issues happens, close and exit UniController.exe, run the BAT file, then run UniController.exe, switch on Apache and MySql, then click PhpMyAdmin!
  2. 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.
  3. Please update MySQL to version 5.7 as starting from this version MySQL added the important support to JSON.
  4. SOLVED by changing files permissions to 'Everyone' to the whole HD.
  5. 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.
  6. 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
  7. 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...