[Xerte] Re: admin-site password for management
Bruno Van Bogaert
bruno.van.bogaert at vub.ac.be
Fri Jan 25 08:30:02 GMT 2013
Hi,
unfortunately there is no phpmyadmin on that machine, so I try to manage
with mysql commands
(But I this is my first try with mysql commands, so not so sure what to
do...)
I did manage to find the database, and got the next results on my 'show
commands':
(sorry for the bad layout of the columns...)
mysql> show columns from sitedetails;
+--------------------------+-----------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default |
Extra |
+--------------------------+-----------+------+-----+---------+----------------+
| site_id | int(11) | NO | PRI | NULL |
auto_increment |
| site_url | char(255) | YES | | NULL
| |
| apache | char(255) | YES | | NULL
| |
| mimetypes | text | YES | | NULL
| |
| site_session_name | char(255) | YES | | NULL
| |
| LDAP_preference | char(255) | YES | | NULL
| |
| LDAP_filter | char(255) | YES | | NULL
| |
| integration_config_path | char(255) | YES | | NULL
| |
| admin_username | char(255) | YES | | NULL
| |
| admin_password | char(255) | YES | | NULL
| |
| site_title | char(255) | YES | | NULL
| |
| site_name | char(255) | YES | | NULL
| |
| site_logo | char(255) | YES | | NULL
| |
| organisational_logo | char(255) | YES | | NULL
| |
| welcome_message | char(255) | YES | | NULL
| |
| site_text | char(255) | YES | | NULL
| |
| news_text | text | YES | | NULL
| |
| pod_one | text | YES | | NULL
| |
| pod_two | text | YES | | NULL
| |
| copyright | char(255) | YES | | NULL
| |
| rss_title | char(255) | YES | | NULL
| |
| synd_publisher | char(255) | YES | | NULL
| |
| synd_rights | char(255) | YES | | NULL
| |
| synd_license | char(255) | YES | | NULL
| |
| demonstration_page | char(255) | YES | | NULL
| |
| form_string | text | YES | | NULL
| |
| peer_form_string | text | YES | | NULL
| |
| module_path | char(255) | YES | | NULL
| |
| website_code_path | char(255) | YES | | NULL
| |
| users_file_area_short | char(255) | YES | | NULL
| |
| php_library_path | char(255) | YES | | NULL
| |
| import_path | char(255) | YES | | NULL
| |
| root_file_path | char(255) | YES | | NULL
| |
| play_edit_preview_query | text | YES | | NULL
| |
| error_log_path | char(255) | YES | | NULL
| |
| email_error_list | char(255) | YES | | NULL
| |
| error_log_message | char(255) | YES | | NULL
| |
| max_error_size | char(255) | YES | | NULL
| |
| error_email_message | char(255) | YES | | NULL
| |
| ldap_host | char(255) | YES | | NULL
| |
| ldap_port | char(255) | YES | | NULL
| |
| bind_pwd | char(255) | YES | | NULL
| |
| basedn | char(255) | YES | | NULL
| |
| bind_dn | char(255) | YES | | NULL
| |
| flash_save_path | char(255) | YES | | NULL
| |
| flash_upload_path | char(255) | YES | | NULL
| |
| flash_preview_check_path | char(255) | YES | | NULL
| |
| flash_flv_skin | char(255) | YES | | NULL
| |
| site_email_account | char(255) | YES | | NULL
| |
| headers | char(255) | YES | | NULL
| |
| email_to_add_to_username | char(255) | YES | | NULL
| |
| proxy1 | char(255) | YES | | NULL
| |
| port1 | char(255) | YES | | NULL
| |
| feedback_list | char(255) | YES | | NULL
| |
+--------------------------+-----------+------+-----+---------+----------------+
54 rows in set (0.00 sec)
mysql> SELECT DISTINCT admin_username FROM sitedetails;
+----------------+
| admin_username |
+----------------+
| |
+----------------+
1 row in set (0.00 sec)
mysql> SELECT DISTINCT admin_password FROM sitedetails;
+----------------+
| admin_password |
+----------------+
| |
+----------------+
1 row in set (0.00 sec)
Next I would like to set admin_username and admin_password, can someone
provide me with the right mysql commands?
Bruno
On 25 January 2013 08:25, Tom Reijnders <reijnders at tor.nl> wrote:
> Hi,
>
> The admin username and password are stored in the sitedetails table in
> mysql. You can edit the record admin_username and admin_password (plain
> text) with phpMyAdmin or similar tools. Normally it is set during setup
> (but you can easily miss that)
>
> Tom
>
> Op 25-1-2013 8:05, Bruno Van Bogaert schreef:
>
> Hi,
>
> I have succesfully installed XOT.
> And it works nice.
> But when I try to log in on the management page
> http://localhost/xertetoolkits/management.php
> no matter what username and password I type, it will not allow me to the
> management page.
>
> Where (I suppose the admin-site username and password is stored in some
> file) can I set the 'right' username and password for management access?
>
> Bruno Van Bogaert
>
>
> _______________________________________________
> Xerte mailing listXerte at lists.nottingham.ac.ukhttp://lists.nottingham.ac.uk/mailman/listinfo/xerte
>
>
> --
> --
>
> Tom Reijnders
> TOR Informatica
> Chopinlaan 27
> 5242HM Rosmalen
> Tel: 073 5226191
> Fax: 073 5226196
>
>
>
>
>
>
> _______________________________________________
> Xerte mailing list
> Xerte at lists.nottingham.ac.uk
> http://lists.nottingham.ac.uk/mailman/listinfo/xerte
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.nottingham.ac.uk/pipermail/xerte/attachments/20130125/51acea42/attachment-0001.html>
More information about the Xerte
mailing list