At this point, I can't really spend any additional time on this without a paid support contract.
-David On Sun, Sep 7, 2014 at 10:05 PM, Rama krishna <imr...@gmail.com> wrote: > Hi David, > Thanks for the reply, I am new to SQL query . Can you please provide sql > for below request. > > On Saturday, September 6, 2014 5:24:20 AM UTC+5:30, David Trowbridge wrote: > >> You may have to join across multiple tables. For instance, the >> 'reviews_review_comments' table has two columns, 'review_id' and >> 'comment_id', which are foreign keys into the 'reviews_review' table and >> 'reviews_comments' table respectively. The 'reviews_review' table has a >> 'review_request_id' column which is a foreign key into the >> 'reviews_review_request' table (and should also match the IDs you see in >> the web UI). >> >> -David >> >> >> On Fri, Sep 5, 2014 at 12:26 AM, Rama krishna <imr...@gmail.com> wrote: >> >>> Hi David, >>> Thanks for the reply, I am able to connect to data base. >>> >>> Have another query as below; >>> *Kindly provide the command to query following fields; "Review Request >>> ID", "Comment ID" and "Comment text" through "mysql" query* >>> >>> we refered "reviews_comment " and "reviews_review_comments" tables but >>> we are not able to read above fields since there is no common field between >>> these 2 tables. >>> Need your inputs for same. >>> >>> >>> On Thursday, September 4, 2014 8:45:16 AM UTC+5:30, David Trowbridge >>> wrote: >>> >>>> The correct database location and credentials are listed in that. You >>>> may want to change the database password and SECRET_KEY now that you've >>>> divulged them to the world. >>>> >>>> -David >>>> >>>> On Sep 3, 2014, at 4:36 AM, Rama krishna <imr...@gmail.com> wrote: >>>> >>>> Hi David, >>>> below is my settings_local.py file but still I am not able to connect >>>> to proper database: >>>> >>>> # 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': 'bitnami_reviewboard', >>>> 'USER': 'bitnami', >>>> 'PASSWORD': 'eadf57801d', >>>> 'HOST': '/opt/reviewboard-2.0.1-0/mysql/tmp/mysql.sock', >>>> 'PORT': '', >>>> }, >>>> } >>>> # Unique secret key. Don't share this with anybody. >>>> SECRET_KEY = '5+bopex32rr%0%!#5^=(s))fb9a89k!s3e(f*(14ms+...@' >>>> # Cache backend settings. >>>> CACHES = { >>>> 'default': { >>>> 'BACKEND': 'django.core.cache.backends.me >>>> mcached.MemcachedCache', >>>> 'LOCATION': 'localhost:11212', >>>> }, >>>> } >>>> # Extra site information. >>>> SITE_ID = 1 >>>> SITE_ROOT = '/reviewboard/' >>>> FORCE_SCRIPT_NAME = '' >>>> DEBUG = False >>>> ALLOWED_HOSTS = ['*'] >>>> >>>> >>>> On Wednesday, September 3, 2014 12:25:52 PM UTC+5:30, David Trowbridge >>>> wrote: >>>> >>>>> Look at your settings_local.py file to see how your database is >>>>> configured. >>>>> >>>>> -David >>>>> >>>>> >>>>> On Tue, Sep 2, 2014 at 10:26 PM, Rama krishna <imr...@gmail.com> >>>>> wrote: >>>>> >>>>>> Hi David, >>>>>> How to check correct data base server? >>>>>> >>>>>> >>>>>> On Monday, September 1, 2014 5:18:11 PM UTC+5:30, Rama krishna wrote: >>>>>> >>>>>>> Hi All, >>>>>>> I have successfully installed review board and I am using it now. Is >>>>>>> there any plugin for extracting review comments from Review Board tool >>>>>>> to >>>>>>> xl file? >>>>>>> >>>>>>> *Setup environment Details:* >>>>>>> >>>>>>> *BitNami Review Board* >>>>>>> <https://www.google.co.in/url?sa=t&rct=j&q=&esrc=s&source=web&cd=6&cad=rja&uact=8&ved=0CDQQFjAF&url=http%3A%2F%2Fwiki.bitnami.com%2FApplications%2FBitNami_Review_Board&ei=SUqVU9mGN4ONuASe6oDQDQ&usg=AFQjCNG5tGnCDuE3iRN9pZ2Ug-dOszdy5w&sig2=4-xRP4zlD4F6Nd4AC0-5Sg&bvm=bv.68445247,d.c2E> >>>>>>> Installed >>>>>>> location: /opt/reviewboard-2.0.1-0 >>>>>>> Mysql port : 3307 http port: 8081 Memcached Port: 11212 >>>>>>> >>>>>> -- >>>>>> Get the Review Board Power Pack at http://www.reviewboard.org/pow >>>>>> erpack/ >>>>>> --- >>>>>> 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...@googlegroups.com. >>>>>> For more options, visit https://groups.google.com/d/optout. >>>>>> >>>>> >>>>> -- >>>> Get the Review Board Power Pack at http://www.reviewboard.org/pow >>>> erpack/ >>>> --- >>>> 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...@googlegroups.com. >>>> For more options, visit https://groups.google.com/d/optout. >>>> >>>> -- >>> 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...@googlegroups.com. >>> For more options, visit https://groups.google.com/d/optout. >>> >> >> -- > 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 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.
