I hope this email finds you doing well. I have recently upgraded to ver 3.1 (latest version) and am having problems getting the "wildcards" access to work properly. Before I progress too much further with this info request here is the physical drive directory structure associated with my project.
/home/irreview
/public_html
/index.php
/metabase
/<metabase files and dirs>
/phpsecurityadmin
/<phpsecurityadmin files and dirs>
/ids_admin
/index.php
/ir_admin
/index.php
The top part of my config.php file in the includes directory under /home/irreview/phpsecurityadmin is as follows:
// Database connection/install options
$PSA_SCR=array(
'Type' => 'mysql', // type of database
'Host' => 'localhost', // database server to connect to
'User' => '<sec-usr>', // username for database
'Password' => '<sec-pwd>', // password for database
'Database' => 'psa_db', // name of the database
'Language' => 'en', // the default language for display
'SiteName' => 'localhost/~irreview', // the name of the site
'IncludePath' => dirname(__FILE__).'/../../metabase', // where to find the metabase files
'MbSchemaDir' => dirname(__FILE__).'/..' // where to store metabase schema files
// (can be anywhere on your machine, but it must writeable
// when calling php from command line)
);
// Display options
$PSA_OPTS=array(
'Tables' => '#000099', // Color you want for your tables
'MenuFont' => '#ffffff', // Color of the font for menu items
'DataFont' => '#000099', // Color of the font for the data
'DataBack' => '#ffffff', // Color of the background for the data
'ErrorFont' => '#cc0000', // Color of the font for error messages
'ErrorBack' => '#cccccc', // Color of the background for error messages
'AltRowColor' => '#dfdfdf', // Alternate Row color for tables
'W3C' => TRUE, // TRUE or FALSE for showing the W3C links
'ShowSiteName' => TRUE // TRUE or FALSE to show site name at the top
);
// Registration Email information
$PSA_REGISTER_EMAIL=array(
'activateLink' => '', // The url for activating the password reset process
'headers' => '', // The to / from fields
'subject' => 'Registration Confirmation', // The email subject
'message' => 'Email Message', // The Message
'fromName' => 'PHP Security Admin', // From field in email
'fromEmail' => 'admin@your_domain.com', // From email
'fromReplyTo' => 'reply-to@your_domain.com' // The email address to reply to
);
// Password Reset/Recover Email information
$PSA_RESETPASS_EMAIL=array(
'activateLink' => '', // The url for activating the password reset process
'headers' => '', // The to / from fields
'subject' => 'Password Reset Confirmation', // The email subject
'message' => 'Email Message', // The Message
'fromName' => 'PHP Security Admin', // From field in email
'fromEmail' => 'admin@your_domain.com', // From email
'fromReplyTo' => 'reply-to@your_domain.com' // The email address to reply to
);
I have installed the ver 3.1 successfully and set up a user with the id of 478059. Further, I have set up a structure called "IDS Admin Pages". The location information I have for "IDS Admin Pages" is "/ids_admin/*". I have created a profile called "IDS Admin" and the only thing selected insofar as structure is concerned is "IDS Admin Pages". I have further assigned the profile "IDS Admin" to the user 478059. Below is a dump of my database and the data in said tables.
#
# Dumping data for table `_sequence_psa_settings_id`
#
INSERT INTO _sequence_psa_settings_id VALUES (6);
# --------------------------------------------------------
#
# Table structure for table `psa_pages`
#
CREATE TABLE psa_pages (
id int(11) NOT NULL default '1',
page char(100) NOT NULL default '',
title char(255) NOT NULL default '',
UNIQUE KEY id (id)
) TYPE=MyISAM;
#
# Dumping data for table `psa_pages`
#
INSERT INTO psa_pages VALUES (1, '/ids_admin/*', 'IDS Admin Pages');
INSERT INTO psa_pages VALUES (2, '/ir_admin/*', 'IR Admin Pages');
# --------------------------------------------------------
#
# Table structure for table `psa_pass_recover`
#
CREATE TABLE psa_pass_recover (
id char(32) NOT NULL default '0',
question char(50) NOT NULL default '0',
answer char(50) NOT NULL default '0',
confirm char(50) NOT NULL default '0'
) TYPE=MyISAM;
#
# Table structure for table `psa_profiles`
#
CREATE TABLE psa_profiles (
id int(11) NOT NULL default '1',
name varchar(255) NOT NULL default '',
value text NOT NULL,
admin char(1) NOT NULL default 'N',
UNIQUE KEY id (id)
) TYPE=MyISAM;
#
# Dumping data for table `psa_profiles`
#
INSERT INTO psa_profiles VALUES (1, 'No Access', '', 'N');
INSERT INTO psa_profiles VALUES (2, 'phpSecurityAdmin - All UI Pages', 'a:0:{}', 'Y');
INSERT INTO psa_profiles VALUES (3, 'IDS Admin', 'a:1:{i:1;i:1;}', 'N');
INSERT INTO psa_profiles VALUES (4, 'IR Admin', 'a:1:{i:2;i:1;}', 'N');
# --------------------------------------------------------
#
# Table structure for table `psa_sessions`
#
CREATE TABLE psa_sessions (
sesskey varchar(32) NOT NULL default '',
expiry int(11) NOT NULL default '0',
value text NOT NULL,
UNIQUE KEY sesskey (sesskey)
) TYPE=MyISAM;
#
# Table structure for table `psa_settings`
#
CREATE TABLE psa_settings (
id int(11) NOT NULL default '1',
name varchar(100) NOT NULL default '',
value text NOT NULL,
UNIQUE KEY id (id)
) TYPE=MyISAM;
#
# Dumping data for table `psa_settings`
#
INSERT INTO psa_settings VALUES (1, 'min_username_length', '3');
INSERT INTO psa_settings VALUES (2, 'max_username_length', '25');
INSERT INTO psa_settings VALUES (3, 'min_password_length', '5');
INSERT INTO psa_settings VALUES (4, 'max_password_length', '25');
INSERT INTO psa_settings VALUES (5, 'connection', '');
INSERT INTO psa_settings VALUES (6, 'lockcount', '3');
# --------------------------------------------------------
#
# Table structure for table `psa_users`
#
CREATE TABLE psa_users (
id varchar(255) NOT NULL default '',
groups text NOT NULL,
lname varchar(255) NOT NULL default '',
fname varchar(255) NOT NULL default '',
mname varchar(255) NOT NULL default '',
email varchar(255) NOT NULL default '',
phone varchar(35) NOT NULL default '',
pass varchar(32) NOT NULL default '',
hash varchar(32) NOT NULL default '',
active char(1) NOT NULL default 'N',
connection text NOT NULL,
lockcount int(11) NOT NULL default '0',
updated datetime NOT NULL default '0000-00-00 00:00:00'
) TYPE=MyISAM;
When I try to access http://localhost/~irreview/ids_admin and I try to login with the ID 478059 and appropriate password I get the response "You do not have access rights to this content
". Please let me know where I've strayed. I must be doing something wrong. Thanks in advance for your help.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Anonymous
-
2003-07-08
The directory structure mentioned in the above message DID NOT show up in the posed message as typed. Sorry
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Try changing the site structure to include the "~irreview/" part of the URI. For instance, for your ids_admin the URI is "/~irreview/ids_admin" not "/ids_admin"
HTH
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Anonymous
-
2003-07-08
That was just the trick. Thanks for your help.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hello All,
I hope this email finds you doing well. I have recently upgraded to ver 3.1 (latest version) and am having problems getting the "wildcards" access to work properly. Before I progress too much further with this info request here is the physical drive directory structure associated with my project.
/home/irreview
/public_html
/index.php
/metabase
/<metabase files and dirs>
/phpsecurityadmin
/<phpsecurityadmin files and dirs>
/ids_admin
/index.php
/ir_admin
/index.php
The top part of my config.php file in the includes directory under /home/irreview/phpsecurityadmin is as follows:
// Database connection/install options
$PSA_SCR=array(
'Type' => 'mysql', // type of database
'Host' => 'localhost', // database server to connect to
'User' => '<sec-usr>', // username for database
'Password' => '<sec-pwd>', // password for database
'Database' => 'psa_db', // name of the database
'Language' => 'en', // the default language for display
'SiteName' => 'localhost/~irreview', // the name of the site
'IncludePath' => dirname(__FILE__).'/../../metabase', // where to find the metabase files
'MbSchemaDir' => dirname(__FILE__).'/..' // where to store metabase schema files
// (can be anywhere on your machine, but it must writeable
// when calling php from command line)
);
// Display options
$PSA_OPTS=array(
'Tables' => '#000099', // Color you want for your tables
'MenuFont' => '#ffffff', // Color of the font for menu items
'DataFont' => '#000099', // Color of the font for the data
'DataBack' => '#ffffff', // Color of the background for the data
'ErrorFont' => '#cc0000', // Color of the font for error messages
'ErrorBack' => '#cccccc', // Color of the background for error messages
'AltRowColor' => '#dfdfdf', // Alternate Row color for tables
'W3C' => TRUE, // TRUE or FALSE for showing the W3C links
'ShowSiteName' => TRUE // TRUE or FALSE to show site name at the top
);
// Registration Email information
$PSA_REGISTER_EMAIL=array(
'activateLink' => '', // The url for activating the password reset process
'headers' => '', // The to / from fields
'subject' => 'Registration Confirmation', // The email subject
'message' => 'Email Message', // The Message
'fromName' => 'PHP Security Admin', // From field in email
'fromEmail' => 'admin@your_domain.com', // From email
'fromReplyTo' => 'reply-to@your_domain.com' // The email address to reply to
);
// Password Reset/Recover Email information
$PSA_RESETPASS_EMAIL=array(
'activateLink' => '', // The url for activating the password reset process
'headers' => '', // The to / from fields
'subject' => 'Password Reset Confirmation', // The email subject
'message' => 'Email Message', // The Message
'fromName' => 'PHP Security Admin', // From field in email
'fromEmail' => 'admin@your_domain.com', // From email
'fromReplyTo' => 'reply-to@your_domain.com' // The email address to reply to
);
I have installed the ver 3.1 successfully and set up a user with the id of 478059. Further, I have set up a structure called "IDS Admin Pages". The location information I have for "IDS Admin Pages" is "/ids_admin/*". I have created a profile called "IDS Admin" and the only thing selected insofar as structure is concerned is "IDS Admin Pages". I have further assigned the profile "IDS Admin" to the user 478059. Below is a dump of my database and the data in said tables.
# phpMyAdmin MySQL-Dump
# version 2.4.0
# http://www.phpmyadmin.net/ (download page)
#
# Host: localhost
# Generation Time: Jul 08, 2003 at 02:37 PM
# Server version: 4.0.11
# PHP Version: 4.3.0
# Database : `psa_db`
# --------------------------------------------------------
#
# Table structure for table `_sequence_psa_pages_id`
#
CREATE TABLE _sequence_psa_pages_id (
sequence int(11) NOT NULL auto_increment,
PRIMARY KEY (sequence)
) TYPE=MyISAM;
#
# Dumping data for table `_sequence_psa_pages_id`
#
INSERT INTO _sequence_psa_pages_id VALUES (2);
# --------------------------------------------------------
#
# Table structure for table `_sequence_psa_profiles_id`
#
CREATE TABLE _sequence_psa_profiles_id (
sequence int(11) NOT NULL auto_increment,
PRIMARY KEY (sequence)
) TYPE=MyISAM;
#
# Dumping data for table `_sequence_psa_profiles_id`
#
INSERT INTO _sequence_psa_profiles_id VALUES (4);
# --------------------------------------------------------
#
# Table structure for table `_sequence_psa_settings_id`
#
CREATE TABLE _sequence_psa_settings_id (
sequence int(11) NOT NULL auto_increment,
PRIMARY KEY (sequence)
) TYPE=MyISAM;
#
# Dumping data for table `_sequence_psa_settings_id`
#
INSERT INTO _sequence_psa_settings_id VALUES (6);
# --------------------------------------------------------
#
# Table structure for table `psa_pages`
#
CREATE TABLE psa_pages (
id int(11) NOT NULL default '1',
page char(100) NOT NULL default '',
title char(255) NOT NULL default '',
UNIQUE KEY id (id)
) TYPE=MyISAM;
#
# Dumping data for table `psa_pages`
#
INSERT INTO psa_pages VALUES (1, '/ids_admin/*', 'IDS Admin Pages');
INSERT INTO psa_pages VALUES (2, '/ir_admin/*', 'IR Admin Pages');
# --------------------------------------------------------
#
# Table structure for table `psa_pass_recover`
#
CREATE TABLE psa_pass_recover (
id char(32) NOT NULL default '0',
question char(50) NOT NULL default '0',
answer char(50) NOT NULL default '0',
confirm char(50) NOT NULL default '0'
) TYPE=MyISAM;
#
# Table structure for table `psa_profiles`
#
CREATE TABLE psa_profiles (
id int(11) NOT NULL default '1',
name varchar(255) NOT NULL default '',
value text NOT NULL,
admin char(1) NOT NULL default 'N',
UNIQUE KEY id (id)
) TYPE=MyISAM;
#
# Dumping data for table `psa_profiles`
#
INSERT INTO psa_profiles VALUES (1, 'No Access', '', 'N');
INSERT INTO psa_profiles VALUES (2, 'phpSecurityAdmin - All UI Pages', 'a:0:{}', 'Y');
INSERT INTO psa_profiles VALUES (3, 'IDS Admin', 'a:1:{i:1;i:1;}', 'N');
INSERT INTO psa_profiles VALUES (4, 'IR Admin', 'a:1:{i:2;i:1;}', 'N');
# --------------------------------------------------------
#
# Table structure for table `psa_sessions`
#
CREATE TABLE psa_sessions (
sesskey varchar(32) NOT NULL default '',
expiry int(11) NOT NULL default '0',
value text NOT NULL,
UNIQUE KEY sesskey (sesskey)
) TYPE=MyISAM;
#
# Table structure for table `psa_settings`
#
CREATE TABLE psa_settings (
id int(11) NOT NULL default '1',
name varchar(100) NOT NULL default '',
value text NOT NULL,
UNIQUE KEY id (id)
) TYPE=MyISAM;
#
# Dumping data for table `psa_settings`
#
INSERT INTO psa_settings VALUES (1, 'min_username_length', '3');
INSERT INTO psa_settings VALUES (2, 'max_username_length', '25');
INSERT INTO psa_settings VALUES (3, 'min_password_length', '5');
INSERT INTO psa_settings VALUES (4, 'max_password_length', '25');
INSERT INTO psa_settings VALUES (5, 'connection', '');
INSERT INTO psa_settings VALUES (6, 'lockcount', '3');
# --------------------------------------------------------
#
# Table structure for table `psa_users`
#
CREATE TABLE psa_users (
id varchar(255) NOT NULL default '',
groups text NOT NULL,
lname varchar(255) NOT NULL default '',
fname varchar(255) NOT NULL default '',
mname varchar(255) NOT NULL default '',
email varchar(255) NOT NULL default '',
phone varchar(35) NOT NULL default '',
pass varchar(32) NOT NULL default '',
hash varchar(32) NOT NULL default '',
active char(1) NOT NULL default 'N',
connection text NOT NULL,
lockcount int(11) NOT NULL default '0',
updated datetime NOT NULL default '0000-00-00 00:00:00'
) TYPE=MyISAM;
#
# Dumping data for table `psa_users`
#
INSERT INTO psa_users VALUES ('admin', '2', 'James', 'Eastman', 'W', 'jameseastman@hotmail.com', '901-263-9018', 'b8da6327d0a7083f49d0562693460566', '7dc2e135b46113cfb3945bafc9d39362', 'Y', '', 0, '2003-07-08 14:18:45');
INSERT INTO psa_users VALUES ('478059', '3', 'James', 'Eastman', 'W', 'jameseastman@hotmail.com', '901-263-9018', '56c7001df7d4ca347acd23d97dec8ca6', '6225b2c8f86258ee9cb074483f4d6bb8', 'Y', '', 0, '2003-07-08 14:18:28');
When I try to access http://localhost/~irreview/ids_admin and I try to login with the ID 478059 and appropriate password I get the response "You do not have access rights to this content
". Please let me know where I've strayed. I must be doing something wrong. Thanks in advance for your help.
The directory structure mentioned in the above message DID NOT show up in the posed message as typed. Sorry
Try changing the site structure to include the "~irreview/" part of the URI. For instance, for your ids_admin the URI is "/~irreview/ids_admin" not "/ids_admin"
HTH
That was just the trick. Thanks for your help.