Just installed OpenRoom on my server. Setting is normal i.e. non HTTPS.
I get the install success. I sget the login screen, I went to create account, was successful but never receive the related email to activate.
Tried multiple times, reinstalled, same.
Anyway to activate manually as a worst case?
Thx in advance
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
And my contact info:
Alexis Martial
Managing Director
tel: +65 6292 0048
fax: +65 6292 5168
hp: +65 9117 7682
alexis@plixo.com.sg
Plixo: Where Innovation, Art & Workmanship Join Hands http://www.plixo.com.sg and our blog http://blog.plixo.com.sg
Blk 3 no 136A Kallang Avenue
Kallang Industrial Centre
Singapore 339456
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Can you tell me what kind of server you have OpenRoom installed on, such as operating system and web server software?
If you try some of the examples on this page: http://php.net/manual/en/function.mail.php do any of them work?
Sorry for the delay in responding to you. I see you've added a way for users to click an activation link immediately after creating an account. The purpose of the activation, however, is to ensure that the email address used is a valid one, and to (at least partially) prevent bots from creating a bunch of false accounts.
The mail function in PHP seems to be kind of finicky depending on the way your server is set up, so I'll try to help as best I can!
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
The following is how you can craft a url to manually activate the account:
# Login to your MySQL server
mysql> use YOUR_OPENROOMS_DATABASE;
mysql> SELECT active FROM users WHERE username = "deleteme";
<pre>
+---------+
| active |
+---------+
| Ei13zfvqtyaK |
+---------+
1 row in set (0.00 sec)
</pre>
In this example I created a user called deleteme so I use that value when I run the query and I get the activation code that you use with the above url.
You could also directly edit the db, but the example I provided only requires read-only access to complete the unlock. If you do want to directly modify the db, you'll change the "active" value from the random character string to the number 0. I suggest sticking with the url approach.
Regarding why the email wasn't sent in the first place, I mention that on this support thread:
Just installed OpenRoom on my server. Setting is normal i.e. non HTTPS.
I get the install success. I sget the login screen, I went to create account, was successful but never receive the related email to activate.
Tried multiple times, reinstalled, same.
Anyway to activate manually as a worst case?
Thx in advance
Access to openroom: http://www.plixo.com.sg/_openroom/
And my contact info:
Alexis Martial
Managing Director
tel: +65 6292 0048
fax: +65 6292 5168
hp: +65 9117 7682
alexis@plixo.com.sg
Plixo: Where Innovation, Art & Workmanship Join Hands
http://www.plixo.com.sg and our blog http://blog.plixo.com.sg
Blk 3 no 136A Kallang Avenue
Kallang Industrial Centre
Singapore 339456
Can you tell me what kind of server you have OpenRoom installed on, such as operating system and web server software?
If you try some of the examples on this page: http://php.net/manual/en/function.mail.php do any of them work?
Sorry for the delay in responding to you. I see you've added a way for users to click an activation link immediately after creating an account. The purpose of the activation, however, is to ensure that the email address used is a valid one, and to (at least partially) prevent bots from creating a bunch of false accounts.
The mail function in PHP seems to be kind of finicky depending on the way your server is set up, so I'll try to help as best I can!
The following is how you can craft a url to manually activate the account:
# Login to your MySQL server
<pre>
+---------+
| active |
+---------+
| Ei13zfvqtyaK |
+---------+
1 row in set (0.00 sec)
</pre>
In this example I created a user called deleteme so I use that value when I run the query and I get the activation code that you use with the above url.
So, if our OpenRooms installation was at:
https://rooms.example.org/openroom/
our user account was deleteme
and the random characters that we got back from the db were Ei13zfvqtyaK
this would be the complete url to use:
That should unlock the account so you can login.
You could also directly edit the db, but the example I provided only requires read-only access to complete the unlock. If you do want to directly modify the db, you'll change the "active" value from the random character string to the number 0. I suggest sticking with the url approach.
Regarding why the email wasn't sent in the first place, I mention that on this support thread:
http://sourceforge.net/projects/openroom/forums/forum/1815286/topic/5143379
See bug #3553701 for additional information/patches.