Locked out: howto "unprivate" page? Login page gone
Forum » Wikidot version 1 / Howtos, troubleshooting » Locked out: howto "unprivate" page? Login page gone
Started by: ppp-adminppp-admin
On: 1262571890|%e %b %Y, %H:%M %Z|agohover
Number of posts: 6
rss icon RSS: New posts
Unfold All | Fold All | +More options
Fold
Locked out: howto "unprivate" page? Login page gone
ppp-adminppp-admin 1262571890|%e %b %Y, %H:%M %Z|agohover

Hello,

i locked myself out by turning the site private on my homenetwork-server.
There is no, at least i do not see one, possible way to access the login page.

The login page looks like:
The page does not (yet) exist.

The page system:join you want to access does not exist.

create page

and when i click on edit i see:

Error
Oooops!

This Site is private and accessible only to its members.

Any help is appreciated!
Thanks in adcace.

/tud-geek

Last edited on 1262572269|%e %b %Y, %H:%M %Z|agohover By ppp-admin + Show more
Reply  |  Options
Unfold Locked out: howto "unprivate" page? Login page gone by ppp-adminppp-admin, 1262571890|%e %b %Y, %H:%M %Z|agohover
Fold
Re: Locked out: howto "unprivate" page? Login page gone
Ed JohnsonEd Johnson 1262579776|%e %b %Y, %H:%M %Z|agohover

Install Webmin on your server and log into Webmin using https://www.yourserver.com:10000/ (or use https://xxx.xxx.xxx.xxx:10000/ where the xxx's are your internal IP address). Under servers you should see "PostgreSQL Database Server".

Select that and then your Wikidot database. Open the "site" table and then "View Data". Find your site that you set private, edit the record and change the private field to "f" (for false). Save the changes and you should be able to get back in.

Once you're up and running again, you should create a system:join page that consists of this code:

[[note]]
Please change this page according to your policy (configure first using [[[admin:manage|Site Manager]]]) and remove this note.
[[/note]]

+ Who can join?

You can write here who can become a member of this site.

+ Join!

So you want to become a member of this site? Tell us why and apply now!

[[module MembershipApply]]

Or, if you already know a "secret password", go for it!

[[module MembershipByPassword]]

This is based on an older revision of WDOS (rev 393), so things might have changed in newer versions. Webmin is a great tool for remotely managing small changes in the wikdidot database. Hope this helps.

-Ed

Free Wikidot Applications · Your Shared Photo Gallery · Your Personal Blog

Reply  |  Options
Unfold Re: Locked out: howto "unprivate" page? Login page gone by Ed JohnsonEd Johnson, 1262579776|%e %b %Y, %H:%M %Z|agohover
Fold
Re: Locked out: howto "unprivate" page? Login page gone
ppp-adminppp-admin 1262590266|%e %b %Y, %H:%M %Z|agohover

Thank you Ed,

i will try your suggestion and it is the solution i was searching for.
Webmin should be the right tool even for nebies in database stuff

I will report back!

/tud-geek

Reply  |  Options
Unfold Re: Locked out: howto "unprivate" page? Login page gone by ppp-adminppp-admin, 1262590266|%e %b %Y, %H:%M %Z|agohover
Fold
Reset Database?
ppp-adminppp-admin 1262611957|%e %b %Y, %H:%M %Z|agohover

If shit hits the fan…

I also did not write down the database password which i need to reset.
After to many attempts to login i get locked out:

*Error - Access denied for 192.168.178.101*

So i need to reset to password for the Database. How to?

Thanks again in advance!

edit: little postgres howto use

change to postgresuser

su postgres

invoke "postgres command line":

psql

list databases

\l

quit psql command line

\q

Still need to figure out how to reset the password…

/tud-geek

Last edited on 1262693118|%e %b %Y, %H:%M %Z|agohover By ppp-admin + Show more
Reply  |  Options
Unfold Reset Database? by ppp-adminppp-admin, 1262611957|%e %b %Y, %H:%M %Z|agohover
Fold
Re: Reset Database?
Dai LoDai Lo 1262919860|%e %b %Y, %H:%M %Z|agohover

Once you have access as postgres, you should be able to change it

http://scratching.psybermonkey.net/2009/06/21/postgresql-how-to-reset-user-name-postgres-password/

hope this helps.

Reply  |  Options
Unfold Re: Reset Database? by Dai LoDai Lo, 1262919860|%e %b %Y, %H:%M %Z|agohover
Fold
This is how you log into the postgres database via webmin
ppp-adminppp-admin 1263327346|%e %b %Y, %H:%M %Z|agohover

That was a hard one.

To access the database via webmin you have to login with the username and password it is run by.
In my case i had to login with:

user: root
pass: myrootpassword

I hope this helps someone - it did help me.
So i was neither a postgres-database problem nor a wikidot one.
It seems so simple but it took me some time to see "the big picture" ;)

/tud-geek

ps: thanks for "Ed Johnson" again!

Last edited on 1263327394|%e %b %Y, %H:%M %Z|agohover By ppp-admin + Show more
Reply  |  Options
Unfold This is how you log into the postgres database via webmin by ppp-adminppp-admin, 1263327346|%e %b %Y, %H:%M %Z|agohover
New Post
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License