error with email config Reviewboard 2.0 Beta3

2014-03-22 Thread Tom Moore
Again, the use of this version is by choice for a class.

ok, got the svn issues figured out.   Now I'm on to an email issue.

I tried to configure the smtp server to use gmail's smtp settings.  I used 
smtp.gmail.com and port 465.  I set use TLS authentication.  The username 
and email are valid.  These credentials work on this same server with 
Bugzilla correctly.   However, we aren't seeing any emails.   We have send 
email turned on for all options as well.   In the apache logs, I see that 
the connection unexpectedly closed, I also see an error about a file not 
being able to be read.  In the debug log I see that the connection 
unexected collapsed.   Also while the send options are turned on, when 
running an operation that would send email, the program hangs.

logs below, usernames changed.

Apache log fragment
[Sat Mar 22 16:23:55 2014] [error] ERROR:root:Error sending e-mail 
notification with subject 'Review Requ
est 9: testme' on behalf of 'u...@gmail.com' to 'User 
u...@gmail.com,u...@gmail.com': Connection unexpectedly closed
[Sat Mar 22 16:23:55 2014] [error] Traceback (most recent call last):
[Sat Mar 22 16:23:55 2014] [error]   File 
/usr/local/lib/python2.7/dist-packages/ReviewBoard-2.0beta3-py2.7.egg/reviewboard/notifications/email.py,
 
line 273, in send_review_mail
[Sat Mar 22 16:23:55 2014] [error] message.send()
[Sat Mar 22 16:23:55 2014] [error]   File 
/usr/local/lib/python2.7/dist-packages/Django-1.6.2-py2.7.egg/django/core/mail/message.py,
 
line 274, in send
[Sat Mar 22 16:23:55 2014] [error] return 
self.get_connection(fail_silently).send_messages([self])
[Sat Mar 22 16:23:55 2014] [error]   File 
/usr/local/lib/python2.7/dist-packages/Django-1.6.2-py2.7.egg/django/core/mail/backends/smtp.py,
 
line 87, in send_messages
[Sat Mar 22 16:23:55 2014] [error] new_conn_created = self.open()
[Sat Mar 22 16:23:55 2014] [error]   File 
/usr/local/lib/python2.7/dist-packages/Django-1.6.2-py2.7.egg/django/core/mail/backends/smtp.py,
 
line 48, in open
[Sat Mar 22 16:23:55 2014] [error] local_hostname=DNS_NAME.get_fqdn())
[Sat Mar 22 16:23:55 2014] [error]   File /usr/lib/python2.7/smtplib.py, 
line 249, in __init__
[Sat Mar 22 16:23:55 2014] [error] (code, msg) = self.connect(host, 
port)
[Sat Mar 22 16:23:55 2014] [error]   File /usr/lib/python2.7/smtplib.py, 
line 310, in connect
[Sat Mar 22 16:23:55 2014] [error] (code, msg) = self.getreply()
[Sat Mar 22 16:23:55 2014] [error]   File /usr/lib/python2.7/smtplib.py, 
line 361, in getreply
[Sat Mar 22 16:23:55 2014] [error] raise 
SMTPServerDisconnected(Connection unexpectedly closed)
[Sat Mar 22 16:23:55 2014] [error] SMTPServerDisconnected: Connection 
unexpectedly closed
Error opening file for reading: Permission denied


I also turned on the logs debug mode.  here is the log
2014-03-22 16:23:55,569 - ERROR -  - Error sending e-mail notification with 
subject 'Re
view Request 9: testme' on behalf of 'u...@gmail.com' to 'user 
u...@gmail.com,u...@gmail.com': Connection unexpectedly closed
Traceback (most recent call last):
  File 
/usr/local/lib/python2.7/dist-packages/ReviewBoard-2.0beta3-py2.7.egg/reviewboard/notifications/email.py,
 
line 273, in send_review_mail
message.send()
  File 
/usr/local/lib/python2.7/dist-packages/Django-1.6.2-py2.7.egg/django/core/mail/message.py,
 
line 274, in send
return self.get_connection(fail_silently).send_messages([self])
  File 
/usr/local/lib/python2.7/dist-packages/Django-1.6.2-py2.7.egg/django/core/mail/backends/smtp.py,
 
line 87, in send_messages
new_conn_created = self.open()
  File 
/usr/local/lib/python2.7/dist-packages/Django-1.6.2-py2.7.egg/django/core/mail/backends/smtp.py,
 
line 48, in open
local_hostname=DNS_NAME.get_fqdn())
  File /usr/lib/python2.7/smtplib.py, line 249, in __init__
(code, msg) = self.connect(host, port)
  File /usr/lib/python2.7/smtplib.py, line 310, in connect
(code, msg) = self.getreply()
  File /usr/lib/python2.7/smtplib.py, line 361, in getreply
raise SMTPServerDisconnected(Connection unexpectedly closed)
SMTPServerDisconnected: Connection unexpectedly closed


-- 
Get the Review Board Power Pack at http://www.reviewboard.org/powerpack/
---
Sign up for Review Board hosting at RBCommons: https://rbcommons.com/
---
Happy user? Let us know at http://www.reviewboard.org/users/
--- 
You received this message because you are subscribed to the Google Groups 
reviewboard group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to reviewboard+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: error with email config Reviewboard 2.0 Beta3

2014-03-22 Thread Christian Hammond
Hi Tom,

Just to check, are you by any chance using Google's per-app passwords?

Christian

-- 
Christian Hammond - chip...@chipx86.com
Review Board - http://www.reviewboard.org
Beanbag, Inc. - http://www.beanbaginc.com


On Sat, Mar 22, 2014 at 11:02 AM, Tom Moore tommoore3...@gmail.com wrote:

 Again, the use of this version is by choice for a class.

 ok, got the svn issues figured out.   Now I'm on to an email issue.

 I tried to configure the smtp server to use gmail's smtp settings.  I used
 smtp.gmail.com and port 465.  I set use TLS authentication.  The username
 and email are valid.  These credentials work on this same server with
 Bugzilla correctly.   However, we aren't seeing any emails.   We have send
 email turned on for all options as well.   In the apache logs, I see that
 the connection unexpectedly closed, I also see an error about a file not
 being able to be read.  In the debug log I see that the connection
 unexected collapsed.   Also while the send options are turned on, when
 running an operation that would send email, the program hangs.

 logs below, usernames changed.

 Apache log fragment
 [Sat Mar 22 16:23:55 2014] [error] ERROR:root:Error sending e-mail
 notification with subject 'Review Requ
 est 9: testme' on behalf of 'u...@gmail.com' to 'User u...@gmail.com,
 u...@gmail.com': Connection unexpectedly closed
 [Sat Mar 22 16:23:55 2014] [error] Traceback (most recent call last):
 [Sat Mar 22 16:23:55 2014] [error]   File
 /usr/local/lib/python2.7/dist-packages/ReviewBoard-2.0beta3-py2.7.egg/reviewboard/notifications/email.py,
 line 273, in send_review_mail
 [Sat Mar 22 16:23:55 2014] [error] message.send()
 [Sat Mar 22 16:23:55 2014] [error]   File
 /usr/local/lib/python2.7/dist-packages/Django-1.6.2-py2.7.egg/django/core/mail/message.py,
 line 274, in send
 [Sat Mar 22 16:23:55 2014] [error] return
 self.get_connection(fail_silently).send_messages([self])
 [Sat Mar 22 16:23:55 2014] [error]   File
 /usr/local/lib/python2.7/dist-packages/Django-1.6.2-py2.7.egg/django/core/mail/backends/smtp.py,
 line 87, in send_messages
 [Sat Mar 22 16:23:55 2014] [error] new_conn_created = self.open()
 [Sat Mar 22 16:23:55 2014] [error]   File
 /usr/local/lib/python2.7/dist-packages/Django-1.6.2-py2.7.egg/django/core/mail/backends/smtp.py,
 line 48, in open
 [Sat Mar 22 16:23:55 2014] [error] local_hostname=DNS_NAME.get_fqdn())
 [Sat Mar 22 16:23:55 2014] [error]   File /usr/lib/python2.7/smtplib.py,
 line 249, in __init__
 [Sat Mar 22 16:23:55 2014] [error] (code, msg) = self.connect(host,
 port)
 [Sat Mar 22 16:23:55 2014] [error]   File /usr/lib/python2.7/smtplib.py,
 line 310, in connect
 [Sat Mar 22 16:23:55 2014] [error] (code, msg) = self.getreply()
 [Sat Mar 22 16:23:55 2014] [error]   File /usr/lib/python2.7/smtplib.py,
 line 361, in getreply
 [Sat Mar 22 16:23:55 2014] [error] raise
 SMTPServerDisconnected(Connection unexpectedly closed)
 [Sat Mar 22 16:23:55 2014] [error] SMTPServerDisconnected: Connection
 unexpectedly closed
 Error opening file for reading: Permission denied


 I also turned on the logs debug mode.  here is the log
 2014-03-22 16:23:55,569 - ERROR -  - Error sending e-mail notification
 with subject 'Re
 view Request 9: testme' on behalf of 'u...@gmail.com' to 'user 
 u...@gmail.com,u...@gmail.com': Connection unexpectedly closed
 Traceback (most recent call last):
   File
 /usr/local/lib/python2.7/dist-packages/ReviewBoard-2.0beta3-py2.7.egg/reviewboard/notifications/email.py,
 line 273, in send_review_mail
 message.send()
   File
 /usr/local/lib/python2.7/dist-packages/Django-1.6.2-py2.7.egg/django/core/mail/message.py,
 line 274, in send
 return self.get_connection(fail_silently).send_messages([self])
   File
 /usr/local/lib/python2.7/dist-packages/Django-1.6.2-py2.7.egg/django/core/mail/backends/smtp.py,
 line 87, in send_messages
 new_conn_created = self.open()
   File
 /usr/local/lib/python2.7/dist-packages/Django-1.6.2-py2.7.egg/django/core/mail/backends/smtp.py,
 line 48, in open
 local_hostname=DNS_NAME.get_fqdn())
   File /usr/lib/python2.7/smtplib.py, line 249, in __init__
 (code, msg) = self.connect(host, port)
   File /usr/lib/python2.7/smtplib.py, line 310, in connect
 (code, msg) = self.getreply()
   File /usr/lib/python2.7/smtplib.py, line 361, in getreply
 raise SMTPServerDisconnected(Connection unexpectedly closed)
 SMTPServerDisconnected: Connection unexpectedly closed


  --
 Get the Review Board Power Pack at http://www.reviewboard.org/powerpack/
 ---
 Sign up for Review Board hosting at RBCommons: https://rbcommons.com/
 ---
 Happy user? Let us know at http://www.reviewboard.org/users/
 ---
 You received this message because you are subscribed to the Google Groups
 reviewboard group.
 To unsubscribe from this group and stop receiving emails from it, send an
 email to reviewboard+unsubscr...@googlegroups.com.
 For more options, visit https://groups.google.com/d/optout.


-- 
Get the 

Re: error with email config Reviewboard 2.0 Beta3

2014-03-22 Thread Tom Moore
considering as I never heard of them, no I don 't think so.

On Saturday, March 22, 2014 2:02:45 PM UTC-4, Tom Moore wrote:

 Again, the use of this version is by choice for a class.

 ok, got the svn issues figured out.   Now I'm on to an email issue.

 I tried to configure the smtp server to use gmail's smtp settings.  I used 
 smtp.gmail.com and port 465.  I set use TLS authentication.  The username 
 and email are valid.  These credentials work on this same server with 
 Bugzilla correctly.   However, we aren't seeing any emails.   We have send 
 email turned on for all options as well.   In the apache logs, I see that 
 the connection unexpectedly closed, I also see an error about a file not 
 being able to be read.  In the debug log I see that the connection 
 unexected collapsed.   Also while the send options are turned on, when 
 running an operation that would send email, the program hangs.

 logs below, usernames changed.

 Apache log fragment
 [Sat Mar 22 16:23:55 2014] [error] ERROR:root:Error sending e-mail 
 notification with subject 'Review Requ
 est 9: testme' on behalf of 'u...@gmail.com' to 'User u...@gmail.com,
 u...@gmail.com': Connection unexpectedly closed
 [Sat Mar 22 16:23:55 2014] [error] Traceback (most recent call last):
 [Sat Mar 22 16:23:55 2014] [error]   File 
 /usr/local/lib/python2.7/dist-packages/ReviewBoard-2.0beta3-py2.7.egg/reviewboard/notifications/email.py,
  
 line 273, in send_review_mail
 [Sat Mar 22 16:23:55 2014] [error] message.send()
 [Sat Mar 22 16:23:55 2014] [error]   File 
 /usr/local/lib/python2.7/dist-packages/Django-1.6.2-py2.7.egg/django/core/mail/message.py,
  
 line 274, in send
 [Sat Mar 22 16:23:55 2014] [error] return 
 self.get_connection(fail_silently).send_messages([self])
 [Sat Mar 22 16:23:55 2014] [error]   File 
 /usr/local/lib/python2.7/dist-packages/Django-1.6.2-py2.7.egg/django/core/mail/backends/smtp.py,
  
 line 87, in send_messages
 [Sat Mar 22 16:23:55 2014] [error] new_conn_created = self.open()
 [Sat Mar 22 16:23:55 2014] [error]   File 
 /usr/local/lib/python2.7/dist-packages/Django-1.6.2-py2.7.egg/django/core/mail/backends/smtp.py,
  
 line 48, in open
 [Sat Mar 22 16:23:55 2014] [error] local_hostname=DNS_NAME.get_fqdn())
 [Sat Mar 22 16:23:55 2014] [error]   File /usr/lib/python2.7/smtplib.py, 
 line 249, in __init__
 [Sat Mar 22 16:23:55 2014] [error] (code, msg) = self.connect(host, 
 port)
 [Sat Mar 22 16:23:55 2014] [error]   File /usr/lib/python2.7/smtplib.py, 
 line 310, in connect
 [Sat Mar 22 16:23:55 2014] [error] (code, msg) = self.getreply()
 [Sat Mar 22 16:23:55 2014] [error]   File /usr/lib/python2.7/smtplib.py, 
 line 361, in getreply
 [Sat Mar 22 16:23:55 2014] [error] raise 
 SMTPServerDisconnected(Connection unexpectedly closed)
 [Sat Mar 22 16:23:55 2014] [error] SMTPServerDisconnected: Connection 
 unexpectedly closed
 Error opening file for reading: Permission denied


 I also turned on the logs debug mode.  here is the log
 2014-03-22 16:23:55,569 - ERROR -  - Error sending e-mail notification 
 with subject 'Re
 view Request 9: testme' on behalf of 'u...@gmail.com' to 'user 
 u...@gmail.com,u...@gmail.com': Connection unexpectedly closed
 Traceback (most recent call last):
   File 
 /usr/local/lib/python2.7/dist-packages/ReviewBoard-2.0beta3-py2.7.egg/reviewboard/notifications/email.py,
  
 line 273, in send_review_mail
 message.send()
   File 
 /usr/local/lib/python2.7/dist-packages/Django-1.6.2-py2.7.egg/django/core/mail/message.py,
  
 line 274, in send
 return self.get_connection(fail_silently).send_messages([self])
   File 
 /usr/local/lib/python2.7/dist-packages/Django-1.6.2-py2.7.egg/django/core/mail/backends/smtp.py,
  
 line 87, in send_messages
 new_conn_created = self.open()
   File 
 /usr/local/lib/python2.7/dist-packages/Django-1.6.2-py2.7.egg/django/core/mail/backends/smtp.py,
  
 line 48, in open
 local_hostname=DNS_NAME.get_fqdn())
   File /usr/lib/python2.7/smtplib.py, line 249, in __init__
 (code, msg) = self.connect(host, port)
   File /usr/lib/python2.7/smtplib.py, line 310, in connect
 (code, msg) = self.getreply()
   File /usr/lib/python2.7/smtplib.py, line 361, in getreply
 raise SMTPServerDisconnected(Connection unexpectedly closed)
 SMTPServerDisconnected: Connection unexpectedly closed




-- 
Get the Review Board Power Pack at http://www.reviewboard.org/powerpack/
---
Sign up for Review Board hosting at RBCommons: https://rbcommons.com/
---
Happy user? Let us know at http://www.reviewboard.org/users/
--- 
You received this message because you are subscribed to the Google Groups 
reviewboard group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to reviewboard+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: Error: Error applying evolution: (1051, Unknown table 'auth_message')

2014-03-22 Thread Kevin Phillips

The devs changed the format to:
DATABASES = {
 'default' : {
  'ENGINE': 'django.db.backends,mysql',
  'NAME': '',
  'USER': '',
  'PASSWORD': '',
  'HOST': '',
 },
}

The caches format has changed similarly. Note that the caches location has 
dropped the URI.
# Cache backend settings.
CACHES = {
'default': {
'BACKEND': 'django.core.cache.backends.memcached.MemcachedCache',
'LOCATION': 'localhost:11211',
},
}

On Wednesday, March 19, 2014 8:48:23 PM UTC-7, Bhaskar Roy wrote:

 Hi Kevin,

 What changes I need to make for the points mentioned below line?

 admin@remotehost2:~$ sudo cp 
 /var/www/reviewboard-1.7.14/conf/settings_local.py /home/admin
 admin@remotehost2:~$ vim /home/admin/settings_local.py (make the mentioned 
 changes from my thread


 My current settings file looks like this.

 # Site-specific configuration settings for Review Board
 # Definitions of these settings can be found at
 # http://docs.djangoproject.com/en/dev/ref/settings/

 # Database configuration
 DATABASES = {
 'default': {
 'ENGINE': 'django.db.backends.mysql',
 'NAME': 'reviewboard',
 'USER': 'root',
 'PASSWORD': 'password',
 'HOST': 'localhost',
 },
 }

 # Unique secret key. Don't share this with anybody.
 SECRET_KEY = 'ic%zzz9a#p_m#1=lip_5_1mkidljkgh89090t@s93fku#kdh@c'

 # Cache backend settings.
 CACHE_BACKEND = 'memcached://localhost:11211/'

 # Extra site information.
 SITE_ID = 1
 SITE_ROOT = '/'
 FORCE_SCRIPT_NAME = ''
 DEBUG = True



 On Thu, Mar 20, 2014 at 3:48 AM, Kevin Phillips 
 kevin.grenvi...@gmail.comjavascript:
  wrote:

 admin@remotehost1:~$ export REVIEWBOARD_DB_NAME=review
 admin@remotehost1:~$ mysqldump  -u backup -p  --max_allowed_packet=512M 
 $REVIEWBOARD_DB_NAME  /tmp/reviewboard-`date`.sql
 admin@remotehost1:~$ scp /tmp/reviewboard-`date`.sql 
 admin@remotehost2:/tmp/
 admin@remotehost1:~$ scp -r /var/www/reviewboard-1.5.2 
 admin@remotehost2:/var/www/reviewboard-1.7.14

 admin@remotehost2:~$ sudo apt-get install mysql-server libmysqlclient-dev 
 memcached ntpd apache2 libapach2-mod-wsgi libapache2-mod-python
 admin@remotehost2:~$ sudo easy_install Reviewboard==1.7.14 Django==1.4.10 
 python-memcached MySQL-Python
 admin@remotehost2:~$ sudo easy_install -m Reviewboard==1.7.14
 admin@remotehost2:~$ sudo cp 
 /var/www/reviewboard-1.7.14/conf/settings_local.py /home/admin
 admin@remotehost2:~$ vim /home/admin/settings_local.py (make the 
 mentioned changes from my thread)
 admin@remotehost2:~$ sudo cp /home/admin/settings_local.py 
 /usr/local/lib/python2.7/dist-packages/Reviewboard-1.7.14-py2.7.egg/reviewboard/
 admin@remotehost2:~$ mysql -u root -p
 mysql create database review;
 mysql create user 'review'@'localhost' identified by 'password';
 mysql grant all on review.* to 'review'@'localhost';
 admin@remotehost2:~$ mysql --max_allowed_packet=128M -u review -p review 
  /tmp/reviewboard-`date`.sql
 admin@remotehost2:~$ mysql -u root -p review
 mysql show table status
 mysql alter table `table_name` engine='InnoDB'; (there are definitely 
 faster ways, but I can't spoon feed you everything...)
 admin@remotehost2:~$ sudo rb-site --version (confirm you are at 1.7.14) 
 admin@remotehost2:~$ sudo rb-site upgrade /var/www/reviewboard-1.7.14
 For Apache, you will need to add:

 Location /review/static
 SetHandler None
 /Location

 Alias /review/static 
 /var/www/reviewboard-1.7.14/htdocs/statichttp://review.company.com/htdocs/static
 

 For lighttpd:

 alias.url = (
 ...
 /review/static = /var/www/review.company.com/htdocs/static,
 ...
 )

 url.rewrite-once = (
 ...
 ^(/review/static/.*)$ = $1,
 ...
 )

 Once you have made these changes, type the following
 to resolve this:

 $ rb-site manage /var/www/r 
 http://review.company.com/eviewboard-1.7.14 resolve-check 
 static-media

 Make the changes...
 admin@remotehost2:~$ ln -s /var/www/reviewboard-1.7.14 /var/www/review
 admin@remotehost2:~$ rb-site manage /var/www/reviewboard-1.7.14 
 resolve-check static-media
 And for good measure...
 admin@remotehost2:~$ rb-site manage /var/www/reviewboard-1.7.14 syncdb

 Hope that helps,

 KP


 On Wednesday, March 19, 2014 3:11:13 AM UTC-7, Bhaskar Roy wrote:

 Hi Kevin,

 I did what you said but I am on same page.

 Can you please provide the procedure to do migration.


 regards
 bahskar 


 On Wed, Mar 19, 2014 at 12:38 AM, Kevin Phillips kevin.grenvi...@
 gmail.com wrote:

 Your database dump appears incomplete. Try dumping with 
 --max_allowed_packet=512M (large packet to avoid truncation). Check your 
 1.5.X db and verify the table exists in production and in the backup. Also 
 verify all your tables are InnoDB instead of MYISAM, you can make manual 
 modification to the table engine without much recourse. 

 Take a look at my thread, I just migrated 1.5.2 to 1.7.14 on the same 
 platform as you.

 KP


 On Tuesday, March 18, 2014 2:31:44 AM