Hi,<div><br></div><div>I did find the command to change the values:</div><div><div>mysql> <b>UPDATE sitedetails SET admin_username='secret', admin_password='secret' WHERE site_id='1';</b></div><div>
Query OK, 1 row affected (0.00 sec)</div><div>Rows matched: 1 Changed: 1 Warnings: 0</div><div><br></div><div>Bruno</div><div><br></div><br><div class="gmail_quote">On 25 January 2013 09:30, Bruno Van Bogaert <span dir="ltr"><<a href="mailto:bruno.van.bogaert@vub.ac.be" target="_blank">bruno.van.bogaert@vub.ac.be</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hi,<br><br>unfortunately there is no phpmyadmin on that machine, so I try to manage with mysql commands<br>(But I this is my first try with mysql commands, so not so sure what to do...)<br>
I did manage to find the database, and got the next results on my 'show commands':<br>
(sorry for the bad layout of the columns...)<br><br>mysql> show columns from sitedetails;<br>+--------------------------+-----------+------+-----+---------+----------------+<br>| Field | Type | Null | Key | Default | Extra |<br>
+--------------------------+-----------+------+-----+---------+----------------+<br>| site_id | int(11) | NO | PRI | NULL | auto_increment |<br>| site_url | char(255) | YES | | NULL | |<br>
| apache | char(255) | YES | | NULL | |<br>| mimetypes | text | YES | | NULL | |<br>| site_session_name | char(255) | YES | | NULL | |<br>
| LDAP_preference | char(255) | YES | | NULL | |<br>| LDAP_filter | char(255) | YES | | NULL | |<br>| integration_config_path | char(255) | YES | | NULL | |<br>
| admin_username | char(255) | YES | | NULL | |<br>| admin_password | char(255) | YES | | NULL | |<br>| site_title | char(255) | YES | | NULL | |<br>
| site_name | char(255) | YES | | NULL | |<br>| site_logo | char(255) | YES | | NULL | |<br>| organisational_logo | char(255) | YES | | NULL | |<br>
| welcome_message | char(255) | YES | | NULL | |<br>| site_text | char(255) | YES | | NULL | |<br>| news_text | text | YES | | NULL | |<br>
| pod_one | text | YES | | NULL | |<br>| pod_two | text | YES | | NULL | |<br>| copyright | char(255) | YES | | NULL | |<br>
| rss_title | char(255) | YES | | NULL | |<br>| synd_publisher | char(255) | YES | | NULL | |<br>| synd_rights | char(255) | YES | | NULL | |<br>
| synd_license | char(255) | YES | | NULL | |<br>| demonstration_page | char(255) | YES | | NULL | |<br>| form_string | text | YES | | NULL | |<br>
| peer_form_string | text | YES | | NULL | |<br>| module_path | char(255) | YES | | NULL | |<br>| website_code_path | char(255) | YES | | NULL | |<br>
| users_file_area_short | char(255) | YES | | NULL | |<br>| php_library_path | char(255) | YES | | NULL | |<br>| import_path | char(255) | YES | | NULL | |<br>
| root_file_path | char(255) | YES | | NULL | |<br>| play_edit_preview_query | text | YES | | NULL | |<br>| error_log_path | char(255) | YES | | NULL | |<br>
| email_error_list | char(255) | YES | | NULL | |<br>| error_log_message | char(255) | YES | | NULL | |<br>| max_error_size | char(255) | YES | | NULL | |<br>
| error_email_message | char(255) | YES | | NULL | |<br>| ldap_host | char(255) | YES | | NULL | |<br>| ldap_port | char(255) | YES | | NULL | |<br>
| bind_pwd | char(255) | YES | | NULL | |<br>| basedn | char(255) | YES | | NULL | |<br>| bind_dn | char(255) | YES | | NULL | |<br>
| flash_save_path | char(255) | YES | | NULL | |<br>| flash_upload_path | char(255) | YES | | NULL | |<br>| flash_preview_check_path | char(255) | YES | | NULL | |<br>
| flash_flv_skin | char(255) | YES | | NULL | |<br>| site_email_account | char(255) | YES | | NULL | |<br>| headers | char(255) | YES | | NULL | |<br>
| email_to_add_to_username | char(255) | YES | | NULL | |<br>| proxy1 | char(255) | YES | | NULL | |<br>| port1 | char(255) | YES | | NULL | |<br>
| feedback_list | char(255) | YES | | NULL | |<br>+--------------------------+-----------+------+-----+---------+----------------+<br>54 rows in set (0.00 sec)<br><br>mysql> SELECT DISTINCT admin_username FROM sitedetails;<br>
+----------------+<br>| admin_username |<br>+----------------+<br>| |<br>+----------------+<br>1 row in set (0.00 sec)<br><br>mysql> SELECT DISTINCT admin_password FROM sitedetails;<br>+----------------+<br>
| admin_password |<br>+----------------+<br>| |<br>+----------------+<br>1 row in set (0.00 sec)<br><br>Next I would like to set admin_username and admin_password, can someone provide me with the right mysql commands?<span class="HOEnZb"><font color="#888888"><br>
<br>Bruno</font></span><div class="HOEnZb"><div class="h5"><br><br><br><div class="gmail_quote">On 25 January 2013 08:25, Tom Reijnders <span dir="ltr"><<a href="mailto:reijnders@tor.nl" target="_blank">reijnders@tor.nl</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div text="#000000" bgcolor="#FFFFFF">
Hi,<br>
<br>
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)<br>
<br>
Tom<br>
<br>
<div>Op 25-1-2013 8:05, Bruno Van Bogaert
schreef:<br>
</div>
<blockquote type="cite"><div><div>Hi,
<div><br>
</div>
<div>I have succesfully installed XOT.</div>
<div>And it works nice.</div>
<div>But when I try to log in on the management page</div>
<div><a href="http://localhost/xertetoolkits/management.php" target="_blank">http://localhost/xertetoolkits/management.php</a></div>
<div>no matter what username and password I type, it will not
allow me to the management page.</div>
<div><br>
</div>
<div>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?</div>
<div><br>
</div>
<div>Bruno Van Bogaert</div>
<br>
<fieldset></fieldset>
<br>
</div></div><pre>_______________________________________________
Xerte mailing list
<a href="mailto:Xerte@lists.nottingham.ac.uk" target="_blank">Xerte@lists.nottingham.ac.uk</a>
<a href="http://lists.nottingham.ac.uk/mailman/listinfo/xerte" target="_blank">http://lists.nottingham.ac.uk/mailman/listinfo/xerte</a><span><font color="#888888">
</font></span></pre><span><font color="#888888">
</font></span></blockquote><span><font color="#888888">
<br>
<pre cols="72">--
--
Tom Reijnders
TOR Informatica
Chopinlaan 27
5242HM Rosmalen
Tel: 073 5226191
Fax: 073 5226196
</pre>
<br>
<br><br>
</font></span></div>
<br>_______________________________________________<br>
Xerte mailing list<br>
<a href="mailto:Xerte@lists.nottingham.ac.uk" target="_blank">Xerte@lists.nottingham.ac.uk</a><br>
<a href="http://lists.nottingham.ac.uk/mailman/listinfo/xerte" target="_blank">http://lists.nottingham.ac.uk/mailman/listinfo/xerte</a><br>
<br></blockquote></div><br>
</div></div></blockquote></div><br></div>