ign_password_protect

jstubbs · 2008-03-19 17:55:26

Hi Igner – will your new version work with Manfre’s modified version I have on my site?

igner · 2008-03-19 18:10:07

Yes, I incorporated manfre’s change into this release.

igner · 2008-03-19 18:16:06

Sheru wrote:

First of all my senario is like this..

public_html/textpattern
public_html/index.php
public_html/products(lists the product by search & this is of different database rather than txp database)

Now I would like to place login box on front end in textpattern and u-name and password is valid then redirect to folder called products e.g http://localhost/products/index.php

Is this thing possible using this plugin? if yes, would help me.

Not really, unless the products section pages are being handled by Textpattern. That’s not to say that you couldn’t write a routine to validate users against the user database, but the pages have to be rendered by TXP in order for the plugin to fire off.

Though if you wrote the code that generates the product, list, it may be possible to wrap that up into a plugin, so then TXP could render the product pages, and subsequently you could use ign_pass_protect to secure them. Make sense?

typeshige · 2008-03-20 02:18:16

I can’t seem to download the newest version. Nothing happens when I click the link.

Thanks,
Shige

Niconemo · 2008-03-20 14:03:12

It’s working for me now. No problem for downloading, installing and activating.

Thank you, igner !

Last edited by Niconemo (2008-03-20 14:05:46)

typeshige · 2008-03-20 16:58:44

The problem I had with downloading was on my side…

I’m experimenting with the plugin now and I always see this message at the top of the login form.

“There was a problem logging in.”

I had been using Rudd’s privileged plugin too. So I tried turning that off in case there was a conflict. Then I cleared all my private variables but none of those two things worked.

Do you know what I should look out for?

progre55 · 2008-03-27 14:18:07

igner:

First off, thanks for the great plug in.

Recently I had to transfer a client’s site from one host to another. I made a mySQL backup and then imported it into the new location. Everything worked great (all tables imported and are working correctly), except:

It would not let me import the `txp_priv` table (I get a cannot have null value message …)
When I go to look at the extensions tab, I get a “Restricted Area” message (because I am sure it can not get to (see) ign_user_mgmt)

Now the ign_users table is present and working. I know it is working because I can log into the website using existing user names and passwords. Obviously, my problem is moving forward …

I am running: 0.4.2d of the plug in. I have modified the $ign_levels = array to add additional levels and then when new accounts are created, an appropriate level is assigned to them …

I know the above are inter-connected, if you could give me some guidance it would be greatly appreciated.

Thank you in advance for your assistance.

progre55

Last edited by progre55 (2008-03-27 14:20:06)

igner · 2008-03-27 17:42:47

@typeshige – are you still having issues with the login form?

@progre55 – What version of TXP are you using?

progre55 · 2008-03-27 17:57:58

igner:

On the new host, the v.4.0.6

On the old host, an older version (not sure exactly which one)

progre55

Last edited by progre55 (2008-03-27 17:58:10)

igner · 2008-03-27 18:10:02

Hmm, if I had to guess, I’d suspect that there’s something in the txp_privs table that’s giving you trouble. only a user registered as an ‘admin’ in the back-end can see that tab, so double-check that that user you’re logged in as has admin privileges.

progre55 · 2008-03-27 21:20:48

Inger:

Makes sense, because right now I do not even have a txp_privs table. when I tried to import it, I got error message (with only this table) that it could not import because of “null” values … all of the other tables imported without any errors …

Below is my priv_table

Table structure for table `txp_priv`

CREATE TABLE txp_priv (
  id int(8) NOT NULL auto_increment,
  priv varchar(128) NOT NULL default '',
  1 tinyint(1) NOT NULL default '0',
  2 tinyint(1) NOT NULL default '0',
  3 tinyint(1) NOT NULL default '0',
  4 tinyint(1) NOT NULL default '0',
  5 tinyint(1) NOT NULL default '0',
  6 tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (id)
) TYPE=MyISAM;

Data for table `txp_priv`

INSERT INTO txp_priv VALUES (1, 'admin', 1, 1, 1, 1, 1, 1);
INSERT INTO txp_priv VALUES (2, 'admin.edit', 1, 0, 0, 0, 0, 0);
INSERT INTO txp_priv VALUES (3, 'admin.list', 1, 1, 1, 0, 0, 0);
INSERT INTO txp_priv VALUES (4, 'article.delete.own', 1, 1, 1, 1, 0, 0);
INSERT INTO txp_priv VALUES (5, 'article.delete', 1, 1, 0, 0, 0, 0);
INSERT INTO txp_priv VALUES (6, 'article.edit', 1, 1, 1, 0, 0, 0);
INSERT INTO txp_priv VALUES (7, 'article.edit.published', 1, 1, 1, 0, 0, 0);
INSERT INTO txp_priv VALUES (8, 'article.edit.own', 1, 1, 1, 1, 1, 1);
INSERT INTO txp_priv VALUES (9, 'article.edit.own.published', 1, 1, 1, 1, 0, 0);
INSERT INTO txp_priv VALUES (10, 'article.publish', 1, 1, 1, 1, 0, 0);
INSERT INTO txp_priv VALUES (11, 'article.php', 1, 1, 0, 0, 0, 0);
INSERT INTO txp_priv VALUES (12, 'article', 1, 1, 1, 1, 1, 1);
INSERT INTO txp_priv VALUES (13, 'list', 1, 1, 1, 1, 1, 1);
INSERT INTO txp_priv VALUES (14, 'category', 1, 1, 1, 0, 0, 0);
INSERT INTO txp_priv VALUES (15, 'css', 1, 1, 0, 0, 0, 1);
INSERT INTO txp_priv VALUES (16, 'diag', 1, 1, 0, 0, 0, 0);
INSERT INTO txp_priv VALUES (17, 'discuss', 1, 1, 1, 0, 0, 0);
INSERT INTO txp_priv VALUES (18, 'file', 1, 1, 1, 1, 0, 1);
INSERT INTO txp_priv VALUES (19, 'form', 1, 1, 1, 0, 0, 1);
INSERT INTO txp_priv VALUES (20, 'image', 1, 1, 1, 1, 0, 1);
INSERT INTO txp_priv VALUES (21, 'import', 1, 1, 0, 0, 0, 0);
INSERT INTO txp_priv VALUES (22, 'link', 1, 1, 1, 0, 0, 0);
INSERT INTO txp_priv VALUES (23, 'log', 1, 1, 1, 0, 0, 0);
INSERT INTO txp_priv VALUES (24, 'page', 1, 1, 1, 0, 0, 1);
INSERT INTO txp_priv VALUES (25, 'plugin', 1, 1, 0, 0, 0, 0);
INSERT INTO txp_priv VALUES (26, 'prefs', 1, 1, 0, 0, 0, 0);
INSERT INTO txp_priv VALUES (27, 'section', 1, 1, 1, 0, 0, 1);
INSERT INTO txp_priv VALUES (28, 'tab.admin', 1, 1, 0, 0, 0, 0);
INSERT INTO txp_priv VALUES (29, 'tab.content', 1, 1, 1, 1, 1, 1);
INSERT INTO txp_priv VALUES (30, 'tab.extensions', 1, 1, 0, 0, 0, 0);
INSERT INTO txp_priv VALUES (31, 'tab.presentation', 1, 1, 1, 0, 0, 1);
INSERT INTO txp_priv VALUES (32, 'tag', 1, 1, 1, 1, 1, 1);

One last thing, I just looked at a recent TXP install (without the plug in) and there is no priv table. Is this added when the plug in is installed?

thanks for your assistance.

progre55

Last edited by progre55 (2008-03-27 21:23:25)

igner · 2008-03-27 21:36:04

very odd – though unrelated to the pass_protect plugin.
What I’d try is to add the table, then run the inserts one by one to see which is failing, and correct that item. Though I don’t see any line items that’d cause a failure…

progre55 · 2008-03-28 14:24:44

Inger:

I tried to load just that table, and this is the exact error I am receiving:

—————————————————————

SQL-query:

Table structure for table `txp_priv`

CREATE TABLE txp_priv(

id int( 8 ) NOT NULL AUTO_INCREMENT ,
priv varchar( 128 ) NOT NULL default ‘’,
1tinyint( 1 ) NOT NULL default ‘0’,
2tinyint( 1 ) NOT NULL default ‘0’,
3tinyint( 1 ) NOT NULL default ‘0’,
4tinyint( 1 ) NOT NULL default ‘0’,
5tinyint( 1 ) NOT NULL default ‘0’,
6tinyint( 1 ) NOT NULL default ‘0’,
PRIMARY KEY ( id )
) TYPE = MYISAM
MySQL said:

- You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ’1 tinyint(1) NOT NULL default ‘0’, 2 tinyint(1) NOT NULL def

—————————————

Any suggestions.

progre55

Last edited by progre55 (2008-03-28 14:25:34)

igner · 2008-03-28 15:04:12

that is missing the space before every instance of tinyint. It should be
. . . 1 tinyint( 1 ) NOT NULL default ‘0’, 2 tinyint( 1 ) NOT NULL default ‘0’, 3 tinyint( 1 ) NOT NULL default ‘0’, 4 tinyint( 1 ) NOT NULL default ‘0’, 5 tinyint( 1 ) NOT NULL default ‘0’, 6 tinyint( 1 ) NOT NULL default ‘0’, ...

progre55 · 2008-03-28 15:10:52

Inger:

When I am loading the file … the space is there:

Table structure for table `txp_priv`

CREATE TABLE txp_priv (
  id int(8) NOT NULL auto_increment,
  priv varchar(128) NOT NULL default '',
  1 tinyint(1) NOT NULL default '0',
  2 tinyint(1) NOT NULL default '0',
  3 tinyint(1) NOT NULL default '0',
  4 tinyint(1) NOT NULL default '0',
  5 tinyint(1) NOT NULL default '0',
  6 tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (id)
) TYPE=MyISAM;

I double checked. I am not sure wehy when it throws the erro everything is bunched.

progre55

Last edited by progre55 (2008-03-28 15:18:14)

Textpattern CMS

Textpattern CMS support forum

#526 2008-03-19 17:55:26

Re: ign_password_protect

#527 2008-03-19 18:10:07

Re: ign_password_protect

#528 2008-03-19 18:16:06

Re: ign_password_protect

#529 2008-03-20 02:18:16

Re: ign_password_protect

#530 2008-03-20 14:03:12

Re: ign_password_protect

#531 2008-03-20 16:58:44

Re: ign_password_protect

#532 2008-03-27 14:18:07

Re: ign_password_protect

#533 2008-03-27 17:42:47

Re: ign_password_protect

#534 2008-03-27 17:57:58

Re: ign_password_protect

#535 2008-03-27 18:10:02

Re: ign_password_protect

#536 2008-03-27 21:20:48

Re: ign_password_protect

#537 2008-03-27 21:36:04

Re: ign_password_protect

#538 2008-03-28 14:24:44

Re: ign_password_protect

#539 2008-03-28 15:04:12

Re: ign_password_protect

#540 2008-03-28 15:10:52

Re: ign_password_protect

Board footer