topic Re: no alfresco database afrer reinstal 3.2 community from canon in Alfresco Archive

no alfresco database afrer reinstal 3.2 community from canon

oggo — Fri, 04 Sep 2009 21:43:46 GMT

Hallo, i reinstalled alfresco community edition on my ubuntu 9.04 from canonical, and now i got no alfresco database exception by starting the tomcat. i looked in the mysql database and it's true, there is no alfresco database. is there some workaround? can i start just the database scripts?cheers o

Re: no alfresco database afrer reinstal 3.2 community from canon

norgan — Sat, 05 Sep 2009 12:59:11 GMT

Hi oggo,
if you check the installation manuals, you should find a hint after installing mysql, you _must_ create the alfresco database & user first before starting tomcat the first time.

Norgan

Re: no alfresco database afrer reinstal 3.2 community from canon

oggo — Sat, 05 Sep 2009 18:31:31 GMT

hi again,
i installed alfresco from canonical … just "apt-get install alfresco-community". would you please post a link to install manuals? thanks in advance.

cheers
oggo

Re: no alfresco database afrer reinstal 3.2 community from canon

gronfelt — Mon, 07 Sep 2009 13:00:03 GMT

Installation manual:

http://wiki.alfresco.com/w/images/e/e4/ECM_InstallConfigure_CommunityEdition32.pdf

If the canonical distribution is like the ordinary installation there should be a database setup script in extras/databases/mysql in your Alfresco directory.

Run that with mysql, like this:

mysql -u root -p < db_setup.sql‍

(assuming 'root' is your MySQL administrator username)