[opencms-dev] Problems getting OpenCMS going :-(

[kwaH]

Hi Stefan,

about your ">error: Access denied for user: '@localhost' to database
'opencms'"
message - there seems to be something wrong with the login of opencms to
the mysql
server. There have been many proposals in this mailing list for solving.

The quickest and most dirty one: start the mysqld with the option
"-Sg" to skip the grant tables, so anything will be able to connect without
authentication.

This mailing list should *really* have a searchable archive.

CU.

Emre

At 16:38 11.04.00 +0200, you wrote:
>Hi there,
>
>I'm half way through installing a first opencms testbed but have a few 
>problems:
>
>1) When populating the mysql-database I crash with the following 
>   message (filesystem seems to have plenty of space left) :
>
>[....]
>Importing: 5_2_2_3_1.html ok
>Importing: 5_2_2_3_2.htmljava.lang.reflect.InvocationTargetException:
>java.lang.
>OutOfMemoryError
>        at org.gjt.mm.mysql.PreparedStatement.executeQuery(Compiled
>Code)
>        at com.opencms.file.CmsAccessGroupMySql.getGroupsOfUser(Compiled
>Code)
>        at com.opencms.file.CmsAccessUserGroup.getGroupsOfUser(Compiled
>Code)
>        at com.opencms.file.CmsRbUserGroup.getGroupsOfUser(Compiled
>Code)
>        at com.opencms.file.CmsRbUserGroup.userInGroup(Compiled Code)
>        at com.opencms.file.CmsResourceBroker.isAdmin(Compiled Code)
>        at com.opencms.file.CmsResourceBroker.accessOwner(Compiled Code)
>        at com.opencms.file.CmsResourceBroker.accessLock(Compiled Code)
>        at com.opencms.file.CmsResourceBroker.lockResource(Compiled
>Code)
>        at com.opencms.file.CmsDbImportFiles.readResource(Compiled Code)
>        at com.opencms.file.CmsDbImportFiles.xmlImport(Compiled Code)
>        at com.opencms.file.CmsDbImport.xmlImport(Compiled Code)
>        at com.opencms.file.CmsResourceBroker.importDb(Compiled Code)
>        at com.opencms.file.CmsObject.importDb(Compiled Code)
>        at com.opencms.setup.CmsShell.importDb(Compiled Code)
>        at java.lang.reflect.Method.invoke(Native Method)
>        at com.opencms.setup.CmsShell.call(Compiled Code)
>        at com.opencms.setup.CmsShell.commands(Compiled Code)
>        at com.opencms.setup.CmsShell.main(Compiled Code)
>> java.lang.reflect.InvocationTargetException: java.lang.OutOfMemoryError
>        at org.gjt.mm.mysql.PreparedStatement.executeQuery(Compiled
>Code)
>        at com.opencms.file.CmsAccessFileMySql.readFile(Compiled Code)
>        at com.opencms.file.CmsAccessFileMySql.publishProject(Compiled
>Code)
>        at com.opencms.file.CmsAccessFile.publishProject(Compiled Code)
>        at com.opencms.file.CmsRbFile.publishProject(Compiled Code)
>        at com.opencms.file.CmsResourceBroker.publishProject(Compiled
>Code)
>        at com.opencms.file.CmsObject.publishProject(Compiled Code)
>        at com.opencms.setup.CmsShell.publishProject(Compiled Code)
>        at java.lang.reflect.Method.invoke(Native Method)
>        at com.opencms.setup.CmsShell.call(Compiled Code)
>        at com.opencms.setup.CmsShell.commands(Compiled Code)
>        at com.opencms.setup.CmsShell.main(Compiled Code)
>> [CmsException]: 0 Unknown exception
>Detailed Error: readFolder [com.opencms.file.CmsAccessFileMySql]
>/system/workplace/pics/
>Caught Exception: [CmsException]: 2 Not found
>Detailed Error: [com.opencms.file.CmsAccessFileMySql]
>/system/workplace/pics/
>
>
>        at com.opencms.file.CmsAccessFileMySql.readFolder(Compiled Code)
>        at com.opencms.file.CmsAccessFile.readFolder(Compiled Code)
>        at com.opencms.file.CmsRbFile.readFolder(Compiled Code)
>        at com.opencms.file.CmsResourceBroker.readFolder(Compiled Code)
>        at com.opencms.file.CmsResourceBroker.addMountPoint(Compiled
>Code)
>        at com.opencms.file.CmsObject.addMountPoint(Compiled Code)
>        at com.opencms.setup.CmsShell.addMountPoint(Compiled Code)
>        at java.lang.reflect.Method.invoke(Native Method)
>        at com.opencms.setup.CmsShell.call(Compiled Code)
>        at com.opencms.setup.CmsShell.commands(Compiled Code)
>        at com.opencms.setup.CmsShell.main(Compiled Code)
>
>bash$
>
>2) Ignorant as I am I still try to connect via Servlet engine and get 
>the following message in the opencms.log file :
>
>
>[11.04.2000 16:26:20] <opencms_init> [OpenCmsServlet] initializing
>opencms with initializer: com.opencms.file.CmsInitMySqlCache
>[11.04.2000 16:26:20] <opencms_init> [OpenCmsServlet] connecting to
>propertyDB via org.gjt.mm.mysql.Driver
>[11.04.2000 16:26:20] <opencms_init> [OpenCms] creating first cms-object
>[11.04.2000 16:26:20] <opencms_init> [OpenCms] initializing the
>cms-object and the main resource-broker
>[11.04.2000 16:26:21] <opencms_init> [CmsInitMySqlCache] initialized rb
>for user and groups
>[11.04.2000 16:26:21] <opencms_init> [CmsInitMySqlCache] initialized rb
>for propertydefinitions and properties
>[11.04.2000 16:26:21] <opencms_init> [CmsInitMySqlCache] initialized rb
>for properties
>[11.04.2000 16:26:21] <opencms_init> [CmsInitMySqlCache] initialized rb
>for projects
>[11.04.2000 16:26:21] <opencms_init> [CmsInitMySqlCache] initialized rb
>for tasks
>[11.04.2000 16:26:21] <opencms_init> [OpenCms]
>[com.opencms.file.CmsAccessSystemPropertyMySql]Error during query:
>Unexpected Exception: java.sql.SQLException message given: General
>error: Access denied for user: '@localhost' to database 'opencms'
>[11.04.2000 16:26:21] <opencms_init> [OpenCms] initialize launchers...
>[11.04.2000 16:26:21] <opencms_init> [CmsLauncherManager] launcher
>package is:com.opencms.launcher
>[11.04.2000 16:26:21] <opencms_init> [CmsLauncherManager] OpenCms
>launcher "CmsXmlLauncher" with launcher ID 3 loaded successfully.
>[11.04.2000 16:26:21] <opencms_init> [CmsLauncherManager] OpenCms
>launcher "CmsDumpLauncher" with launcher ID 1 loaded successfully.
>
>
>
>What am I doing wrong here?
>
>Cheers,
>  Stefan
>
>