Author Archive: Mohit .

Adobe Connect connection test page fails in step 2 on Google Chrome

Posted on August 30, 2012 by Mohit . | Comments (0)

PROBLEM : – Adobe connect meeting connection test page fails in connection to FMS on Google chrome even though i have removed MS Patch (MS12-006 )which is conflicting with the TLS/SSL handshake

The same test page successfully completes step 2 on firefox web browser

Sample connection test page URL -: https://your-connect-url/common/help/en/support/meeting_test.htm

SOLUTION -: This is applicable when connect server is secured via SSL and chrome browser has Flash Pepper (PPAPI) plug-in

 Disable the default Flash Pepper (PPAPI) plug-in in Chrome 21 as per the screenshots

  

  1. Type chrome://plugins in a browser tab (Figure 1).
  2. Expand Details in the upper-right area of the screen (Figure 1).
  3. Click Disable for the PPAPI Flash plug-in. Ensure that the NPAPI Flash plug-in listed below the PPAPI Flash plug-in is not disabled.
  4. Refresh the browser tab.

 

Adobe Connect disable the “Change My Password” link on the My Profile page

Posted on August 30, 2012 by Mohit . | Comments (0)

PROBLEM -: Need to disable “Change My Password” hyperlink on “My Profile” page

SOLUTION -:  

To Remove the link on login page:
1.  Backup the file: C:\breeze\appserv\apps\lang\en.xml

2.  Open the file: C:\breeze\appserv\apps\lang\en.xml

3.  Find the xml tag : <m id=”forgot-password”>Forgot your password?</m>

4.  Change it to : <m id=”forgot-password”></m>

How to disable the Change My Password link on the My Profile page:

1. Stop the connect service and backup the feature.xml file on location  C:\Breeze\appserv\apps\home\feature.xml

2. Open the file as above in a xml editor like editplus/notepad++.

3 Search the following block of code on feature.xml file 

        <feature id=”password” name=”password” title=”change-my-password” nav=”level-2″ propagate=”true”>        
            <template name=”home/password.xsl”/>
            <param name=”account-id” path=”/results/common/account/@account-id” propagate=”true”/>
            <action name=”password-rules”>
               <param name=”acl-id” from=”account-id”/>
            </action>
            <param name=”user-id” path=”/results/common/user/@user-id”/>
                   
            <feature name=”save” title=”save” nav=”button-bottom” type=”submit”>
             <param name=”user-id” path=”/results/common/user/@user-id”/>
             <action name=”user-update-pwd”/>
             <goto status=”ok” feature=”info”/>
           </feature>           
            <link title=”cancel” feature=”info” nav=”button-bottom”/>
          </feature>

4. Comment out the block of code as follows

<!–
         <feature id=”password” name=”password” title=”change-my-password” nav=”level-2″ propagate=”true”>        
            <template name=”home/password.xsl”/>
            <param name=”account-id” path=”/results/common/account/@account-id” propagate=”true”/>
            <action name=”password-rules”>
               <param name=”acl-id” from=”account-id”/>
           </action>
            <param name=”user-id” path=”/results/common/user/@user-id”/>
                   
            <feature name=”save” title=”save” nav=”button-bottom” type=”submit”>
             <param name=”user-id” path=”/results/common/user/@user-id”/>
             <action name=”user-update-pwd”/>
             <goto status=”ok” feature=”info”/>
            </feature>           
            <link title=”cancel” feature=”info” nav=”button-bottom”/>
          </feature> –>

5. Start the connect services.

Adobe Connect Custom link on “Forgot Your Password” hyperlink.

Posted on August 30, 2012 by Mohit . | Comments (4)

ISSUE -: Need to customize the “Forgot your password” link on connect login page to redirect it to custom link.

SOLUTION -: We have tested out the customization on connect 8.2.0.1

1. you need to update the following files on -:

C:\Breeze\8.2.0.1\appserv\apps\system\login.xsl
C:\Breeze\8.2.0.1\appserv\apps\lang\en.xml

Sample updated files -: custom_url_on_forgot_your_password_link

2. Find the line on en.xml -:

 <m id=”forgot-password”>Forgot your password?</m>

 Replace it with

 <m id=”forgot-password”></m>

3. I have already updated en.xnl file with respect to step 2.

4. Replace login.xsl with the attached file.I have routed the help link to http://google.com on the attached login.xsl file

Search for the line http://google.com on login.xsl file attached on this mail and replace with your custom URL.

5. Restart the connect services to apply the changes.

 

 

Slower system performance on pulling up reports / slower database performance.

Posted on August 20, 2012 by Mohit . | Comments (0)

PROBLEM:

While pulling up connect reports/logging into connect central, system takes a lot time to display data.

 

REASON:

When connect application uses INSERT, UPDATE, and DELETE statements to modify table data, breeze database indexes can become fragmented. Index fragmentation can happen when the logical sequence of pages is disrupted or when an index page contains less than its maximum amount of data, creating a gap in the data page or index. As indexes become fragmented, connect app get inefficient data reads when accessing tables and slower database performance.

Performing routine database maintenance such as reindexing is important for keeping your breeze databases running at peak performance. 

If your connect server usage/web access is too high then Adobe recommends to re-index your connect database every weekend night to achieve optimal performance.

While searching through the debug.log files , You get the lines similar to  -:

 

[06-25 01:30:22] https-8443-1700 (INFO) SLOW QUERY: 109ms spid:393 com.macromedia.breeze.sco.DAL.getDetailedMeetingAttendance(meeting,”1046523363″,”1012293661″,Fri Jun 22 16:00:42 CDT 2012,Fri Jun 22 17:46:14 CDT 2012)
[06-25 01:30:24] https-8443-1700 (INFO) SLOW QUERY: 156ms spid:393 com.macromedia.breeze.sco.DAL.getDetailedMeetingAttendance(meeting,”1018351354″,”1012293661″,Fri Jun 22 11:28:15 CDT 2012,Fri Jun 22 12:14:15 CDT 2012)
[06-25 01:36:55] https-8443-1649 (INFO) SLOW QUERY: 437ms spid:926 com.macromedia.breeze.sco.Reports$HeaderQuizQuestionAnswerDistribution.execute(“1070892119″,slide-view,lesson-location,core,1,2,3)
[06-25 01:36:55] https-8443-1649 (INFO) SLOW QUERY: 594ms spid:393 com.macromedia.breeze.sco.Reports$ReportQuizQuestionAnswerDistribution.execute(“1070892119″,slide-view,lesson-location,core)
[06-25 01:41:29] https-8443-1641 (INFO) SLOW QUERY: 328ms spid:393 com.macromedia.breeze.sco.Reports$ReportMyMeetings.execute(“1013634615″,view,mini-host,host,”1012293661″,meeting,”1012293745″,”1013634618″)

Observe the query execution time in ms as highlighted in red fonts. If your server logs is having values equal/greater that the highlighted one then the database must be re-indexed.

 

SOLUTION:

1. Schedule downtime and stop the connect services.

2. If connect database is located within the connect server , Launch SQL Server Management Studio Express.Skip to point 5

3. If connect database is located on remote server (Typically called as central database server managed by DBA) , Ask your DBA to execute the database re-index command mentioned on point 6

4.By default connect database name is breeze, If you have specified any other database name , Navigate to connect console page which is accessible only in connect server on URL -: http://localhost:8510/console/application-settings/database-settings?account-id=7 Identify the database name and let DBA know about the database name.

5. Launch a new query editor window.

6.Select breeze database.

Execute the below database re-index command on query editor window.

EXEC sp_MSforeachtable @command1=”print ‘?’ DBCC DBREINDEX (‘?’, ‘ ‘, 80)”
GO

EXEC sp_MSforeachtable @command1=” UPDATE STATISTICS ?”
GO

 

7.Please note that the re-index process will take sometime depending on your database size.

8. Start the connect service when the re-index process is completed.

 

You can also follow the link :- http://blogs.adobe.com/connectsupport/adobe-connect-database-maintenance-activity to perform database maintenance activity to wipe off unused table records created on connect database.