[Deploying Sakai] Sakai Down

Sun Aug 21 20:12:45 PDT 2011

Cool, good to hear, it's nice when it's something simple but easy to
overlook when rushing to get it going.

The smtp wasn't that big of a deal (just email archive wouldn't be working),
but you might want to check out your database tables I mentioned when you
get a chance to ensure they are the correct engine and the tables are being
created correctly.

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

> 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/53292b12/attachment.html 