new install - no db tables, blank page

[Steven Taylor]

I just did a fresh install (15 minute install), to ubuntu 10.04. The install creates a db (bigbluebutton_dev), but no tables. When I try to join the demo I get a blank page. After looking at the logs, (I know nothing about java), it looks like it cannot connect to the database.  I had to change the password to log in to mysql as 'bbb', so how can I change what the install set as db password? Is this related to the blank page? 
bbb-conf --clean and bbb-conf --check' produce no errors.

Thank you.

[Fred Dixon]

Hi Steven,

To see if the BigBlueButton can connect to the database, check out the values in

/var/lib/tomcat6/webapps/bigbluebutton/WEB-INF/classes/bigbluebutton.properties

Specifically

dataSource.url=jdbc:mysql://localhost/bigbluebutton_dev
dataSource.username=bbb
dataSource.password=secret
dataSource.driverClassName =com.mysql.jdbc.Driver

Your values for username and password will be different. To see if
BigBlueButton can connect to mysql, try

mysql -u bbb -p

and enter in your password. You should something like the following:

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 65
Server version: 5.1.41-3ubuntu12.7 (Ubuntu)

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

Regards,... Fred

> --
> You received this message because you are subscribed to the Google Groups
> "BigBlueButton-Setup" group.
> To post to this group, send email to bigbluebu...@googlegroups.com.
> To unsubscribe from this group, send email to
> bigbluebutton-s...@googlegroups.com.
> For more options, visit this group at
> http://groups.google.com/group/bigbluebutton-setup?hl=en.
>

[Steven Taylor]

Fred, I changed the password in bigbluebutton.properties and tested
with 'mysql -u bbb -p" and got the mysql prompt, "used" the database
(bigbluebutton_dev) but still showing no tables. Then did a bbb-conf --
clean and bbb-conf --check with no errors. Still getting a blank page
when try to join. Did a nmap scan of the server and all of the
required ports are open. The bbb-web.log has this at the top:

2010-12-09 19:28:19,287 DEBUG
[org.codehaus.groovy.grails.web.context.GrailsContextLoader] -
[GrailsContextLoader] Loading context. Creating parent application
context
2010-12-09 19:28:20,004 WARN
[org.codehaus.groovy.grails.commons.GrailsApplicationFactoryBean] -
Class with name [DataSource] was not found, and hence not loaded.
Possible empty class or script definition?

And a few lines down:
2010-12-09 19:28:29,045 DEBUG
[org.codehaus.groovy.grails.beans.factory.UrlMappingFactoryBean] -
[UrlMappingFactoryBean] Creating URL mappings as...
2010-12-09 19:28:29,046 WARN
[org.codehaus.groovy.grails.web.servlet.mvc.GrailsUrlHandlerMapping] -
Neither 'urlMap' nor 'mappings' set on SimpleUrlHandlerMapping

Further down:

2010-12-09 19:28:30,245 DEBUG
[org.codehaus.groovy.grails.web.converters.configuration.ConvertersConfigurationInitializer]
- Initializing default XML Converters Configuration...
2010-12-09 19:28:30,872 WARN
[org.codehaus.groovy.grails.plugins.DefaultGrailsPlugin] - No
JSecurity realms configured - access control won't work!

Can you help me with this? Thanks again.

On Dec 9, 6:32 pm, Fred Dixon <ffdi...@gmail.com> wrote:
> Hi Steven,
>
> To see if the BigBlueButton can connect to the database, check out the values in
>
>   /var/lib/tomcat6/webapps/bigbluebutton/WEB-INF/classes/bigbluebutton.properties
>
> Specifically
>
> dataSource.url=jdbc:mysql://localhost/bigbluebutton_dev
> dataSource.username=bbb
> dataSource.password=secret
> dataSource.driverClassName =com.mysql.jdbc.Driver
>
> Your values for username and password will be different.  To see if
> BigBlueButton can connect to mysql, try
>
>     mysql -u bbb -p
>
> and enter in your password. You should something like the following:
>
> Welcome to the MySQL monitor.  Commands end with ; or \g.
> Your MySQL connection id is 65
> Server version: 5.1.41-3ubuntu12.7 (Ubuntu)
>
> Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
>
> Regards,... Fred
>

[Fred Dixon]

Hi Steven,

I'm pretty sure it's not the database; BigBlueButton 0.71 doesn't
actually create any tables. Still, it was good to check.

Can you do the following. Do:

sudo bbb-conf --clean
sudo bbb-conf --check

This will do a restart of BigBlueButton and clear all the logs. If
bbb-conf outputs no problems, next, try to join from the web. If it
fails, do

sudo bbb-conf --debug

and let us know the output.

Regards,... Fred

[Steven Taylor]

Fred, I did a bbb-conf --debug. No output. Nothing.

Steve

--

[Fred Dixon]

Hi Steve,

Can you try clearing the cache on your browser. Also, is your server
on an external IP address that we could test from our location?

The install from packages should work out-of-the-box, so we're curious
to dig further and figure out why it's not working on your setup.

Regards,... Fred

[Steven Taylor]

Fred,I cleared the cache - no go. The server is not accessible from the internet. I have attached my logs files after doing a bbb-conf --clean and trying to join the demo. Maybe they will help.

Steve

Regards,... Fred

[Fred Dixon]

Hi Steven,

Was there anything running on this server before? Or was it a fresh
install of Ubuntu 10.04?

Regards,... Fred

[Steven Taylor]

Fred, it is a fresh install - I did it the night before last. I tried both methods of bbb (source, packages) installs proir to re-installing ubuntu. Got the same results.

Steve

[Fred Dixon]

Just to double-check, do you have Flash installed? Can you connect to

http://bigbluebutton.org/

and confirm the BigBlueButton client loads (no blank page).

Regards,... Fred

[Steven Taylor]

Flash is installed, client on your web page loads fine. 

[Steven Taylor]

Fred, when I do a bbb-conf --watch, I see activity for port 80, but no activity for the other two ports when trying to load the client page.

[Fred Dixon]

Can you share the output of the following command

cat /var/log/nginx/bigbluebutton.access.log

Regards,... Fred

[Steven Taylor]

Fred, thanks - here you go:

192.168.1.29 - - [10/Dec/2010:14:22:57 -0500] "GET /bigbluebutton/api HTTP/1.0" 200 75 "-" "Wget/1.12 (linux-gnu)"
192.168.1.29 - - [10/Dec/2010:14:23:07 -0500] "GET /bigbluebutton/api HTTP/1.0" 200 75 "-" "Wget/1.12 (linux-gnu)"
192.168.1.8 - - [10/Dec/2010:14:23:56 -0500] "GET /images/banner_bottom.png HTTP/1.1" 206 3423 "http://192.168.1.29/" "Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.2.13) Gecko/20101206 Ubuntu/10.04 (lucid) Firefox/3.6.13"
192.168.1.8 - - [10/Dec/2010:14:23:56 -0500] "GET /images/arrow.png HTTP/1.1" 206 2944 "http://192.168.1.29/" "Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.2.13) Gecko/20101206 Ubuntu/10.04 (lucid) Firefox/3.6.13"
192.168.1.8 - - [10/Dec/2010:14:23:56 -0500] "GET /images/bbb_logo.png HTTP/1.1" 206 16348 "http://192.168.1.29/" "Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.2.13) Gecko/20101206 Ubuntu/10.04 (lucid) Firefox/3.6.13"
192.168.1.29 - - [10/Dec/2010:14:24:02 -0500] "GET /bigbluebutton/api/create?name=Demo+Meeting&meetingID=Demo+Meeting&attendeePW=ap&moderatorPW=mp&voiceBridge=79505&checksum=d6f58c6cabead812bcff16e39906ec6ad0514a79 HTTP/1.1" 200 249 "-" "Java/1.6.0_20"
192.168.1.8 - - [10/Dec/2010:14:24:02 -0500] "GET /bigbluebutton/demo/demo1.jsp?username=sft&action=create HTTP/1.1" 200 980 "http://192.168.1.29/" "Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.2.13) Gecko/20101206 Ubuntu/10.04 (lucid) Firefox/3.6.13"
192.168.1.8 - - [10/Dec/2010:14:24:02 -0500] "GET /bigbluebutton/api/join?meetingID=Demo+Meeting&fullName=sft&password=mp&checksum=0b615df587d24b05d645db3427e799ce37ab6409 HTTP/1.1" 302 0 "http://192.168.1.29/bigbluebutton/demo/demo1.jsp?username=sft&action=create" "Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.2.13) Gecko/20101206 Ubuntu/10.04 (lucid) Firefox/3.6.13"
192.168.1.8 - - [10/Dec/2010:14:24:02 -0500] "GET /client/BigBlueButton.html HTTP/1.1" 304 0 "http://192.168.1.29/bigbluebutton/demo/demo1.jsp?username=sft&action=create" "Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.2.13) Gecko/20101206 Ubuntu/10.04 (lucid) Firefox/3.6.13"

Regards,... Fred

[Fred Dixon]

Hi Steven,

I can see the command to create the meeting, but nothing afterwards,
which correlates with your browser showing a blank page. Can you do
the following:

1) Try a different browser with your server ... should have the same
problems, but let's double-check
2) Do a view-source on your browser and share the output here (it
might be blank, or it might have some content that gives us clues)

Regards,... Fred

[Steven Taylor]

Fred, this is from google chrome running in a winXp VM:

<!-- saved from url=(0014)about:internet -->

<html lang="en">

<!-- 

Smart developers always View Source. 

This application was built using Adobe Flex, an open source framework

for building rich Internet applications that get delivered via the

Flash Player or to desktops via Adobe AIR. 

Learn more about Flex at http://flex.org 

// -->

<head>

<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

<!--  BEGIN Browser History required section -->

<link rel="stylesheet" type="text/css" href="history/history.css" />

<!--  END Browser History required section -->

<title>BigBlueButton</title>

<script src="AC_OETags.js" language="javascript"></script>

<!--  BEGIN Browser History required section -->

<script src="history/history.js" language="javascript"></script>

<!--  END Browser History required section -->

<style>

body { margin: 0px; overflow:hidden }

</style>

<script language="JavaScript" type="text/javascript">

<!--

// -----------------------------------------------------------------------------

// Globals

// Major version of Flash required

var requiredMajorVersion = 10;

// Minor version of Flash required

var requiredMinorVersion = 0;

// Minor version of Flash required

var requiredRevision = 0;

// -----------------------------------------------------------------------------

// -->

</script>

</head>

<body scroll="no" onfocus="clearblink()">

<script language="JavaScript" type="text/javascript">

<!--

// Version check for the Flash Player that has the ability to start Player Product Install (6.0r65)

var hasProductInstall = DetectFlashVer(6, 0, 65);

// Version check based upon the values defined in globals

var hasRequestedVersion = DetectFlashVer(requiredMajorVersion, requiredMinorVersion, requiredRevision);

if ( hasProductInstall && !hasRequestedVersion ) {

// DO NOT MODIFY THE FOLLOWING FOUR LINES

// Location visited after installation is complete if installation is required

var MMPlayerType = (isIE == true) ? "ActiveX" : "PlugIn";

var MMredirectURL = window.location;

    document.title = document.title.slice(0, 47) + " - Flash Player Installation";

    var MMdoctitle = document.title;

AC_FL_RunContent(

"src", "playerProductInstall",

"FlashVars", "MMredirectURL="+MMredirectURL+'&MMplayerType='+MMPlayerType+'&MMdoctitle='+MMdoctitle+"",

"width", "100%",

"height", "100%",

"align", "middle",

"id", "BigBlueButton",

"quality", "high",

"bgcolor", "#869ca7",

"name", "BigBlueButton",

"allowScriptAccess","sameDomain",

"type", "application/x-shockwave-flash",

"pluginspage", "http://www.adobe.com/go/getflashplayer"

);

} else if (hasRequestedVersion) {

// if we've detected an acceptable version

// embed the Flash Content SWF when all tests are passed

//

// NOTE: Don't use wmode=transparent because it messes up mouse wheel

// see. http://stackoverflow.com/questions/313966/mousewheel-not-working-when-published-movie-has-wmodetransparent

// ralam (mar 31, 2010)

AC_FL_RunContent(

"src", "BigBlueButton.swf?v=3797",

"width", "100%",

"height", "100%",

"align", "middle",

"id", "BigBlueButton",

"quality", "high",

"bgcolor", "#869ca7",

"name", "BigBlueButton",

"allowScriptAccess","sameDomain",

"type", "application/x-shockwave-flash",

"pluginspage", "http://www.adobe.com/go/getflashplayer"

);

  } else {  // flash is too old or we can't detect the plugin

    var alternateContent = 'Alternate HTML content should be placed here. '

   + 'This content requires the Adobe Flash Player. '

   + '<a href=http://www.adobe.com/go/getflash/>Get Flash</a>';

    document.write(alternateContent);  // insert non-flash content

  }

// -->

function startApplet(IP, roomNumber, fullScreen)

{

var iframe = document.createElement("iframe");

   iframe.id = "iframe";

   document.body.appendChild(iframe);

   frames[frames.length - 1].document.write(

   "<applet code=\"org.bigbluebutton.deskshare.client.DeskShareApplet.class\"" +

   "id=\"DeskShareApplet\" width=\"0\" height=\"400\" archive=\"bbb-deskshare-applet-0.71.jar\">" +

         "<param name=\"ROOM\" value=\"" + roomNumber  + "\"/>" +

         "<param name=\"IP\" value=\"" + IP + "\"/>" +

         "<param name=\"FULL_SCREEN\" value=\"" + fullScreen + "\"/>" +      

       "</applet>"

     );

}

function removeFrame () {

    var iframe = document.getElementById("iframe");

    iframe.parentNode.removeChild(iframe);

}

function setScreenCoordinates(x, y) {

   return frames[frames.length - 1].document.DeskShareApplet.setScreenCoordinates(x,y);

}

function stopApplet(){

frames[frames.length - 1].document.DeskShareApplet.destroy();

removeFrame();

}

function checkForJava(){

// if (navigator.javaEnabled() || window.navigator.javaEnabled())

return 1;

}

var blinkTimer = false;

var blinking = false;

var startblink = function(message1, message2)

{

if(!blinking)

{

document.title = (document.title == message2)?message1:message2;

blinkTimer = window.setTimeout("blinktitle('" + message1 + "', '" + message2 + "', 1)", 500);

blinking = true;

}

}

var blinktitle = function(message1, message2)

{

document.title = (document.title == message2)?message1:message2;

blinkTimer = window.setTimeout("blinktitle('" + message1 + "', '" + message2 + "', 1)", 500);

}

var clearblink = function()

{

blinking = false;

if(blinkTimer)

{

window.clearTimeout(blinkTimer);

}

document.title = 'BigBlueButton';

}

// Check locale

var localeChain = "en_US";

if (navigator.language)

        localeChain = navigator.language;

else if (navigator.browserLanguage)

        localeChain = navigator.browserLanguage;

if(/^([a-z]+)-([a-z]+)$/i.test(localeChain)){

        var matches = /^([a-z]+)-([a-z]+)$/i.exec(localeChain);

        localeChain = matches[1].toLowerCase() + "_" + matches[2].toUpperCase();

}

else if(/^en$/i.test(localeChain)){

        localeChain = "en_US";

}

else if(/^([a-z]+)$/i.test(localeChain)){

        var matches = /^([a-z]+)$/i.exec(localeChain);

        localeChain = matches[1].toLowerCase() + "_" + matches[1].toUpperCase();

}

else{

        localeChain = "en_US";

}

function getLanguage(){

return localeChain;

}

</script>

<noscript>

   <object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000"

id="BigBlueButton" width="100%" height="100%"

codebase="http://fpdownload.macromedia.com/get/flashplayer/current/swflash.cab">

<param name="movie" value="BigBlueButton.swf?v=3797" />

<param name="quality" value="high" />

<param name="bgcolor" value="#869ca7" />

<param name="allowScriptAccess" value="sameDomain" />

<embed src="BigBlueButton.swf" quality="high" bgcolor="#869ca7"

width="100%" height="100%" name="BigBlueButton" align="middle"

play="true"

loop="false"

quality="high"

allowScriptAccess="sameDomain"

type="application/x-shockwave-flash"

pluginspage="http://www.adobe.com/go/getflashplayer">

</embed>

</object>

</noscript>

</body>

</html>

Regards,... Fred

[Fred Dixon]

Steven,

We're not sure what's happening at this point. The page is being
loaded, the content is there, but it's not being processed by your
browser.

Can you save this page as a separate file, then login to
demo.bigbluebutton.org (which works), then view source and save this
second page. Compare the two pages; let us know if there is any
difference.

(Most text editors will let you compare two files)

Regards,... Fred

[Steven Taylor]

Fred, the only difference are these two lines (out of context)

"src", "BigBlueButton.swf?v=3797",
<param name="movie" value="BigBlueButton.swf?v=3797"/>    (from blank page)

"src", "BigBlueButton.swf?v=3806",
<param name="movie" value="BigBlueButton.swf?v=3806" />   (page that works- from the net)

Regards,... Fred

[Fred Dixon]

Hmmm ... our next suggestion to download a BigBlueButton VM and try
that within your network.

Again, this should make no difference, but we're now in the territory
of some assumption is wrong, so it's time to systematically check the
assumptions until we find out which one is wrong.

Regards,... Fred

[Steven Taylor]

Fred, I'll do that. But in the meantime (I'm shutting down for the night), I have attached two screenshots, one of the web page served from the local server, the other is your server. Same page, exact same code. But they display differently on the same browser (tabbed pages). I'm not going to try to figure that out yet. But it'll give me something to start with tomorrow night. Try to have a good weekend.

Steve

Regards,... Fred

[Steven Taylor]

Oops, here's the other screenshot.

[Fred Dixon]

OK, that screen shot was very helpful.

There's something wrong the networking because it's obviously not able
to load the banner image, which suggests a configuration problem from
the server. Did the server change its IP address at anytime during
the installation/testing?

Regards,... Fred

[Seun Ojedeji]

Fred  when i saw the screen-shot i was just about asking the same thing then ur post came in :)
@steve is the server running on dhcp and whats the lease period like?
you may want to share your ifcong and bbb-conf --check .

------------------------------------------------------------------------

Seun Ojedeji,
System Analyst/Network Administrator
University of Nigeria, Nsukka
web:      http://www.unn.edu.ng
Mobile: +2348035233535
Skype:  seun.ojedeji

[Steven Taylor]

Fred, the server IP is static. and has not been changed.

[Steven Taylor]

fred & Seun, you will find both files below:

ifconfig

eth0      Link encap:Ethernet  HWaddr 88:ae:1d:1d:ee:2e 
          inet addr:192.168.1.29  Bcast:192.168.1.255  Mask:255.255.255.0
          inet6 addr: fe80::8aae:1dff:fe1d:ee2e/64 Scope:Link
          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
          RX packets:31911 errors:0 dropped:0 overruns:0 frame:0
          TX packets:16154 errors:0 dropped:0 overruns:0 carrier:1
          collisions:0 txqueuelen:1000
          RX bytes:47139840 (47.1 MB)  TX bytes:1167128 (1.1 MB)
          Interrupt:28

lo        Link encap:Local Loopback 
          inet addr:127.0.0.1  Mask:255.0.0.0
          inet6 addr: ::1/128 Scope:Host
          UP LOOPBACK RUNNING  MTU:16436  Metric:1
          RX packets:2006 errors:0 dropped:0 overruns:0 frame:0
          TX packets:2006 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:0
          RX bytes:250657 (250.6 KB)  TX bytes:250657 (250.6 KB)


bbb-conf --check

 bbb-conf --check

BigBlueButton Server 0.71
                    Kernel version: 2.6.32-26-generic
                      Distribution: Ubuntu 10.04.1 LTS (32-bit)
                            Memory: 2955 MB

/var/www/bigbluebutton/client/conf/config.xml
          Port test (tunnel): 192.168.1.29
                              Red5: 192.168.1.29

/etc/nginx/sites-available/bigbluebutton
                       server name: 192.168.1.29
                              port: 80
                    bbb-client dir: /var/www/bigbluebutton

/var/lib/tomcat6/webapps/bigbluebutton/WEB-INF/classes/bigbluebutton.properties (bbb-web)
                      bbb-web host: 192.168.1.29

/var/lib/tomcat6/webapps/bigbluebutton/demo/bbb_api_conf.jsp (API demos)
                  bbb-web-api host: 192.168.1.29

/usr/share/red5/webapps/bigbluebutton/WEB-INF/red5-web.xml
                  voice conference: FreeSWITCH


** Potential problems described below **

[Fred Dixon]

Hi Steven,

There is definitely something amiss with the networking itself. In
the screen shots, the banner logo loaded fine from
http://demo.bigbluebutton.org/, but not from your local server.

Can you try the following URL

http://192.168.1.29/images/bbb_logo.png

To see if your computer can load the logo and let us know the results.

Regards,... Fred

[Steven Taylor]

Fred, the image will not load on any of the computers, regardless of OS or web browser - but it does load on the server.

Steve

Regards,... Fred

[Fred Dixon]

Ok, we've moved beyond investigation of BigBlueButton's configuration
to first solving your network configuration problems...

On 192.168.1.29 can you tell us the output of

cat /etc/network/interfaces
cat /etc/hosts
route
ping google.com

On some other computer (not 192.168.1.29) can you tell us the output of

ping 192.168.1.29

Regards,... Fred

[Steven Taylor]

Fred, sorry for the long delay. After a bit of testing it appears that the driver (al1c) for the NIC is producing corrupt data,  I tested the server with another NIC and bbb works fine so far. Thanks to all for your support, and pointing me to the solution.

Steve