 | | | Batch Serve admin/guest | Batch Serve admin/guest 2004-03-22 - By Alexei.Godek@(protected)
Back
You havent followed the instructions correctly... or your not running
supported versions of php and mysql
I installed Batchserve last week with no problems....
I have had your problem last summer while doing an install but following the
instructions ironed it out by its self.
You might get this error during the update.php step of the installation, or
when trying to login to the BatchServe server for the first time after the
installation.
DB ERROR! Access denied for user: 'xsi_server@(protected)' to database 'xsi_r'
Cause
An unsupported version of MySql was installed. (ex: 3.23.55)
Solution
Please install version 3.23.52 of MySql.
Alternatively do the following:
1) Run winmysqladmin.exe
go to the "my.ini" tab and make sure the user and password are the following
user name = xsiserver
password = XSIBatchServe
2) backup and edit Functions.php under the server directory and change the
following lines like this
before:
$mysql_server_user = 'xsi_server';
$mysql_server_password = 'XSIBatchServe';
after:
$mysql_server_user = 'xsiserver';
$mysql_server_password = 'XSIBatchServe';
3) backup and edit XSI_R.sql under the server directory and add the
following lines at the very end
GRANT ALL ON XSI_R.* TO 'xsiserver@(protected)' IDENTIFIED BY 'XSIBatchServe';
GRANT ALL ON XSI_R.* TO 'xsiclient@(protected)' IDENTIFIED BY 'XSIBatchServe';
GRANT ALL ON XSI_R.* TO 'xsi_server@(protected)' IDENTIFIED BY
'XSIBatchServe';
GRANT ALL ON XSI_R.* TO 'xsi_client@(protected)' IDENTIFIED BY
'XSIBatchServe';
GRANT ALL ON XSI_R.* TO 'xsi_client' IDENTIFIED BY 'XSIBatchServe';
GRANT ALL ON XSI_R.* TO 'xsi_server' IDENTIFIED BY 'XSIBatchServe';
GRANT ALL ON XSI_R.* TO 'xsiclient' IDENTIFIED BY 'XSIBatchServe';
GRANT ALL ON XSI_R.* TO 'xsiserver' IDENTIFIED BY 'XSIBatchServe';
GRANT all ON xsi_r TO xsiclient;
GRANT all ON xsi_r TO xsi_client;
GRANT all ON xsi_r TO xsiserver;
GRANT all ON xsi_r TO xsi_server;
FLUSH PRIVILEGES;
then open http://localhost/update.php> and proceed with the update.
-- --Original Message-- --
From: Roberto Sarlenga [mailto:roberto_sarlenga@(protected)]
Sent: 22 March 2004 12:42
To: XSI@(protected)
Subject: Re: Batch Serve admin/guest
Excuse me for insisting, but anyone knows anything about this problem?
Can figure it out!
-- -- Original Message -- --
From: "Roberto Sarlenga" <roberto_sarlenga@(protected)>
To: <XSI@(protected)>
Sent: Saturday, March 20, 2004 12:15
Subject: Batch Serve admin/guest
> Hi,
>
> I' ve installed BatchServe. Everything goes ok until the update.php. then
I
> says the xsi_server@(protected) can't acces the database.
>
> I' ve installed frontmysql (a GUI for MySQL) and granted all privileges to
> xsi_server and it worked, BUT I logged in as admin/admin and I appear to
be
> logged as guest (top right corner guest@) and I can't add users or submit
> any work. Any other user/pass will fail to log in.
>
> Cheers,
> Rob, completly lost with this problem!
> ---
> Unsubscribe? Mail Majordomo@(protected) with the following text in body:
> unsubscribe xsi
>
---
Unsubscribe? Mail Majordomo@(protected) with the following text in body:
unsubscribe xsi
---
Unsubscribe? Mail Majordomo@(protected) with the following text in body:
unsubscribe xsi
|
|
|