[Deploying Sakai] Sakai Down

[Matthew Jones]

I'd probably look at the apache logs (usually in /var/log/apache). On linux
it's 'apachectl status' Or you could look at the process list and see if
'httpd' or 'apache' is running. I'm not too familiar with the commands for
BSD/OSX. And yea, I mean for the Sakai box firewall. I know I've seen (at
least on a notebook) that the OSX firewall (In Sharing->Firewall on the
non-server) gets enabled seemingly randomly.

On Sun, Aug 21, 2011 at 10:19 PM, Larry Dougher <ldougher at wsesu.net> wrote:

> I believe apache is running in front or at least it should be.  What
> command could I use to see if it's running?
>
> By firewall, do you mean on the Sakai box?
>
> Thanks,
>
> Larry
>
> Sent from my iPhone
>
> On Aug 21, 2011, at 10:06 PM, Matthew Jones <jonespm at umich.edu> wrote:
>
> Well, it looks like ajp is listening, which would imply that there is
> apache or something running in front of it.
>
> Some things I would check
> * Can you connect directly to tomcat after it starts up on whichever port
> it's listening as 8080, like " <http://127.0.0.1:8080/>
> http://127.0.0.1:8080/"? This port would be in conf/server.xml.
> * Did some upgrade or something turn on the firewall?
> * Is apache start up?
>
> -- Usually non-fatal
> * There are errors in the logs about "Component named "smtpserver" failed
> to pass through the Initialization stage. (Reason: java.net.BindException:
> Permission denied)."
>   This would imply that you were trying to startup with the mailserver
> (james) configured to run on a port < 1024 as a non root user. (smtp.port=25
> or something) Do you normally start up the app as root? Generally best
> practice would startup James as a high port (like 8025) and use postfix or
> something in front to deliver the mail, but this might not be how you had it
> going.
>
> * There are errors in the logs concerning database errors:
> INFO: [GenericDao] Could not execute first DDL line, skipping the rest:
> StatementCallback; bad SQL grammar [CREATE TABLE ENTITY_PROPERTIES ( id
>        bigint(20) AUTO_INCREMENT NOT NULL PRIMARY KEY, entityRef
> varchar(255) NOT NULL, entityPrefix    varchar(255) NOT NULL, propertyName
>  varchar(255) NOT NULL, propertyValue   text NOT NULL, INDEX (entityRef,
> entityPrefix, propertyName) )]; nested exception is
> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was
> too long; max key length is 1000 bytes:com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:
> Specified key was too long; max key length is 1000 bytes
>
> This is usually because you created the tables in mysql as myisam instead
> of innodb. You can check with this
> <http://stackoverflow.com/questions/213543/how-can-i-check-mysql-engine-type-for-a-specific-table>
> http://stackoverflow.com/questions/213543/how-can-i-check-mysql-engine-type-for-a-specific-table
> And convert with this
>
> <http://stackoverflow.com/questions/1152437/how-to-convert-myisam-to-innodb>
> http://stackoverflow.com/questions/1152437/how-to-convert-myisam-to-innodb
>
> Generally all tables need to be this or they get these errors and have
> transaction issues.
>
> Not sure what else, check you apache error logs. There's no way you're able
> to bind to port 80 if you're not using apache if smtp can't bind.
>
> On Sun, Aug 21, 2011 at 9:32 PM, Larry Dougher < <ldougher at wsesu.net>
> ldougher at wsesu.net> wrote:
>
>>  Hi all,
>>
>> I'm freaking out a bit and would really like some help.  Sakai has been
>> working great since some of you, especially Steve Swinsburg, helped me set
>> it up last spring.  LDAP and everything has been great.
>>
>> Earlier today, a teacher said they couldn't log in so I tried and I
>> couldn't.  It said invalid login.  So, I restarted tomcat.  Same thing.  So,
>> I restarted the server (the box which is an XServe running 10.6.x) and
>> started tomcat, and now I can't even load <http://sakai.windsorschools.net/><http://sakai.windsorschools.net>
>> http://sakai.windsorschools.net
>>
>> Also, on the server I can't even load127.0.0.1/portal either.
>>
>> Here is the tail hoping something jumps out at someone:
>>
>> Last login: Sun Aug 21 11:42:37 on console
>> WSD-Sakai-Server:~ admin$ tomcat/bin/startup.sh
>> Using CATALINA_BASE:   /Users/admin/tomcat
>> Using CATALINA_HOME:   /Users/admin/tomcat
>> Using CATALINA_TMPDIR: /Users/admin/tomcat/temp
>> Using JRE_HOME:
>>  /System/Library/Frameworks/JavaVM.framework/Versions/1.5/Home
>> Using CLASSPATH:       /Users/admin/tomcat/bin/bootstrap.jar
>> WSD-Sakai-Server:~ admin$ tomcat/bin/shutdown.sh
>> Using CATALINA_BASE:   /Users/admin/tomcat
>> Using CATALINA_HOME:   /Users/admin/tomcat
>> Using CATALINA_TMPDIR: /Users/admin/tomcat/temp
>> Using JRE_HOME:
>>  /System/Library/Frameworks/JavaVM.framework/Versions/1.5/Home
>> Using CLASSPATH:       /Users/admin/tomcat/bin/bootstrap.jar
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/production/attachments/20110821/d35e2e46/attachment.html