Forum Problems Installing LAMS: Re: installation on debian sarge fails


 
Search: 

2: Re: installation on debian sarge fails
In response to 1 10/31/05 05:59 PM
[ Reply | Forward ]
I haven't used Debian before, but I've installed on Ubuntu (based on Debian?)... I had trouble with the hostname for the lams user:

<!--
        # Tell Ant the hostname of the MySQL server that
        should be put in the MySQL grant able.
        MySQL seems unhappy with just 'localhost' or '%'
        in the grant table, in order to be able to connect
        from a client on the server itself.
        You can use either the hostname or the IP address,
        that is in the server's /etc/host file.
    -->
    <property name="mysql.hostaddress" value="localhost"/>

where 'localhost', '127.0.0.1' didn't work, but using the public IP address of the machine did.  It might also be worth checking the database manually, to see if the tables and the lams user were created.

Posted by Jun-Dir Liew

3: Re: Re: installation on debian sarge fails
In response to 2 11/02/05 12:29 PM
[ Reply | Forward ]
I tried several variations but it did not work.
I think the problem is a syntax error somewhere but can't find it. 'root'@'%' ist definitely no valid database user. Login for DB-user root ist allowed from localhost, hostname and %
I get the following error message:

Buildfile: build.xml

db-prep-only:

prep_db:
[echo] This creates the database and sets username/password
[sql] Executing commands
[sql] Failed to execute: GRANT ALL PRIVILEGES ON lams01.* TO lams@localhost IDENTIFIED BY 'my password'

BUILD FAILED
/home/pruem/lams/lams-server1.0.1/lams-package/ant/build.xml:258: The following error occurred while executing this line:
/home/pruem/lams/lams-server1.0.1/lams-package/ant/build.xml:459: java.sql.SQLException: Syntax error or access violation, message from server: "Access denied for user 'root'@'%' to database 'lams01'"

Total time: 0 seconds
Buildfile: build.xml

db-prep-only:

prep_db:
[echo] This creates the database and sets username/password
[sql] Executing commands
[sql] Failed to execute: GRANT ALL PRIVILEGES ON lams01.* TO lams@localhost IDENTIFIED BY 'Foh7nooj'

BUILD FAILED
/home/pruem/lams/lams-server1.0.1/lams-package/ant/build.xml:258: The following error occurred while executing this line:
/home/pruem/lams/lams-server1.0.1/lams-package/ant/build.xml:459: java.sql.SQLException: Syntax error or access violation, message from server: "Access denied for user 'root'@'%' to database 'lams01'"

Posted by David Prüm

5: Re: Re: Re: installation on debian sarge fails
In response to 3 11/14/05 01:19 AM
[ Reply | Forward ]
David,

You might want to try with the new version of LAMS. We have simplified the installation build.xml a bit. You can download it from the LAMS Foundation site (all other platform installer).

Thanks,

Ernie

Posted by Ernie Ghiglione

Reply to first post on this page
Back to Problems Installing LAMS
.LRN Home