[Deploying Sakai] Sakai Down

Sun Aug 21 20:05:44 PDT 2011

Thank you everyone for all your help.  I got it working.  I used sudo
apachectl -k start then restarting tomcat and I'm back up.  I wrongfully
assumed that Apache would just restart itself when I restarted the box.  I
knew it was something simple I would forget, like restarting apache which I
don't do have to do everyday because Sakai just runs great :)

Thanks again to everyone,

*Larry Dougher*

*Director of Technology*

*Windsor Southeast Supervisory Union*

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

> I think the reason it won't work with 8080 is because it's not listening
> for tomcat.  I'm using ajp.
>
>
> Thanks,
>
> Larry
>
>  Sent from my iPhone
>
> On Aug 21, 2011, at 10:53 PM, Matthew Jones <jonespm at umich.edu> wrote:
>
> Usually on linux you can start it with
> apachectl start
> or /etc/init.d/apache2 start
> or service apache start
>
> On OSX (if there a GUI) there would probably be something like
> "Sharing->Web Server)
>
> Not sure why it wouldn't have started at boot though (when you restarted).
> You don't have to restart tomcat. I'm not sure why you wouldn't be able to
> connect directly to tomcat, but it might not be listening. You'd have to
> look at the tomcat configuration (in the tomcat directory conf/server.xml)
>
> Not sure if you updated recently, but some people report problems with the
> OSX 10.6.5 apachectl script.
>
> <https://discussions.apple.com/thread/2644342?start=0&tstart=0>
> https://discussions.apple.com/thread/2644342?start=0&tstart=0
>
> On Sun, Aug 21, 2011 at 10:46 PM, Larry Dougher < <ldougher at wsesu.net>
> ldougher at wsesu.net> wrote:
>
>> I ran ps -aux and it gave me a list of processes and apache isn't one of
>> them.  This would seem why it is down.  How do I restart apache?  Should I
>> kill tomcat first?
>>
>>
>> Thanks,
>>
>> Larry
>>
>> Sent from my iPhon
>> On Aug 21, 2011, at 10:26 PM, Matthew Jones < <jonespm at umich.edu>
>> jonespm at umich.edu> wrote:
>>
>> 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><ldougher at wsesu.net>
>> 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><jonespm at umich.edu>
>>> 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/><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><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><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><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><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/7a4f4e56/attachment.html 