[Xerte] Re: admin-site password for management
Bruno Van Bogaert
bruno.van.bogaert at vub.ac.be
Fri Jan 25 09:34:14 GMT 2013
Hi,
I did find the command to change the values:
mysql> *UPDATE sitedetails SET admin_username='secret',
admin_password='secret' WHERE site_id='1';*
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
Bruno
On 25 January 2013 09:30, Bruno Van Bogaert <bruno.van.bogaert at vub.ac.be>wrote:
> 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/c1033a7d/attachment-0001.html>
More information about the Xerte
mailing list