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>