Radicore v2.0 on a single database [message #5973] |
Sat, 15 October 2016 14:39 |
Laevus
Messages: 5 Registered: October 2016
|
Junior Member |
|
|
I am trying to get Radicore v2.0 to work on a single database.
I have created a new mysql database named BLOG and a new user BLOGAdmin with full access to it.
I have also run the requisite mysql schema and data files against BLOG as per the installation guide.
I have the following config.inc as per FAQ150 and FAQ92:
<<
...
if (preg_match('/^(127.0.0.1|localhost|desktop|laptop)$/i', $_SERVER['SERVER_NAME'])) {
global $servers;
// server 0
$servers[0]['dbhost'] = 'localhost';
$servers[0]['dbengine'] = 'mysql';
$servers[0]['dbusername'] = 'BLOGAdmin';
$servers[0]['dbuserpass'] = '<real password>';
$servers[0]['dbnames'] = 'audit,dict,menu,workflow,product,survey';
$servers[0]['switch_dbnames'] = array('audit' => 'blog',
'dict' => 'blog',
'menu' => 'blog',
'workflow' => 'blog',
'product' => 'blog',
'survey' => 'blog');
// server 1
$servers[1]['dbhost'] = 'localhost';
$servers[1]['dbengine'] = 'mysql';
$servers[1]['dbusername'] = 'BLOGAdmin';
$servers[1]['dbuserpass'] = '<real password>';
$servers[1]['dbnames'] = '*';
...
>>
When I navigate my browser to http://localhost/radicore/index.html and click the Logon link, I get the following error:
<<
This application has encountered an unrecoverable error
The following has been reported to the administrator:
2016-10-15 20:30:27
Fatal Error: MySQL: Unknown database 'audit' (# 1049)
Error in line 89 of file 'C:\xampp\htdocs\radicore\includes\dml.mysqli.class.inc'.
Host Info: localhost via TCP/IP
Server Version: 5.6.20
Client Version: mysqlnd 5.0.11-dev - 20120503 - $Id: f373ea5dd5538761406a8022a4b8a374418b240e $, Character sets - client: utf8, - connection: utf8, - database: utf8, - server: utf8
PHP_SELF: /radicore/menu/logon.php
CURRENT DIRECTORY: C:\xampp\htdocs\radicore\menu
SERVER_ADDR: ::1
SERVER_NAME: localhost
HTTP_HOST: localhost
REMOTE_ADDR: ::1
REQUEST_URI: /radicore/menu/logon.php?csxslt=off
>>
Any suggestions would be appreciated.
Thanks in advance.
|
|
|