Author Archive: Mohit .

Adobe connect users getting re-connected to meeting room

PROBLEM -: Meeting users are getting re-connected to the meeting room randomly within a second.

My connect server is hosted on Amazon EC2 cloud on windows 2008 R2 OS.

SOLUTION -:

1. Capture the connect add-in logs generated on the user’s computer joining on the meeting room, To generate addin logs follow the KB Doc http://helpx.adobe.com/adobe-connect/kb/enable-logging-acrobat-connect-professional.html

The connect addin logs would be generated on client/user side , not on the server side.

2. Open the connectaddin log file generated under your documents folder when you expreience reconnects.

3. If you find the lines -:

Player   TRACE: StreamHandler::public/all/screenshare_0::NetStream onStatus for stream: public/all/screenshare_0, code: NetStream.Play.InsufficientBW

4.  And your server is hosted in the Amazon EC2 cloud and has Win 2008 64 bit OS.

5. The fix for this is to switch onto Win 2003 OS

6. This is a known issue reported by a lot of users having Win 2008 server hosted on Amazon EC2 cloud, on this video streaming issue. You can check the blog at http://forums.adobe.com/thread/572258

Configuring Cisco Call Manager with Adobe Connect

PROBLEM -: I want to enable Universal Voice feature on my on-premise Adobe connect server using our internal Cisco call manager server.

SOLUTION -:

There are some basic network configurations needed for this integration as -:

1. SIP port 5060 should be opened between Adobe connect and cisco call manager for SIP communications

2. Port range 5000 – 6000 should be opened between Adobe connect and cisco call manager  for transversing voice packets via RTP.

3. DTMF mode RFC 2833 must be supported by cisco call manager as well as its carrier.

Integration steps -:

1. I need to create username/password based SIP account on cisco call manager

2. Login into cisco call manager and Navigate to Device -> Phone -> Add new ->

Refer to the screenshot below

 Select Third party Basic device

Select Sip profile as standard sip profile

Select Digest user as LDAP ID of a user x

Check mark Media Termination Point Protocol.

 

3. Navigate to User Management > End User .

Search for LDAP ID of user x

The user-id of the LDAP user x would be the username of SIP account

The pin would be the password of the SIP account.

 

4. Configure your adobe connect SIP account settings with username of SIP account , password of the SIP account as per step 3.

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

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

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.

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.

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.