ATutor

Learning Management Tools


  1. Home



Pages:1 2 3 4 5 6 7 8 9 10 11 12 13 14 15


Cannot Install AT 163



  • 2009-08-01 17:08:32

    Cannot Install AT 163

    Hi All,
    I am having a difficulty installing AT for the first time. I can't get past step 3. Any help would be greatly appreciated.

    Things to describe:
    Operating system ATutor is installed on - Linux infong 2.4
    ATutor version - Trying to install 1.6.3
    Patch #s applied - n/a
    ATutor theme name - Can't get past installation
    PHP version - 4.4.9
    MySQL version - 5.0.67
    Webserver & version - Apache (Can't find version)
    Copies of error messages - See below
    Changes to default settings - n/a
    Web browser being used - Firefox 3.0.11
    ...and anything else relevant - See below

    Step 2 Problem: It would not create the database tables and I got an error message stating that it could not connect to database.

    I changed the following line
    From: $db = @mysql_connect($_POST['db_host'] . ':' . $_POST['db_port'], $_POST['db_login'],
    $_POST['db_password']);

    To: $db = mysql_connect($db_host, $db_login, $db_password);

    And it created the tables and went to step 3.

    Step 3 Error Messages:
    Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /homepages/atutor/install/include/step3.php on line 95

    Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /homepages/atutor/install/include/step3.php on line 98

    Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /homepages/atutor/install/include/step3.php on line 102

    Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /homepages/atutor/install/include/step3.php on line 106

    Again, I can't get past step 3.

    Any help will be greatly appreciated.

    Thanks in advance!

    Gary


  • 2009-08-01 17:57:54

    Re: Cannot Install AT 1.6.3

    Download a fresh copy and try again. There have been issues with downloads from sourceforge for the past while, breaking files.

    You should not need to change anything if MySQL is setup with default port settings.


  • 2009-08-04 09:15:52

    Re: Cannot Install AT 1.6.3

    Also check your database user privileges.


  • 2009-08-04 17:48:49

    Re: Cannot Install AT 1.6.3

    When you download, make a note of the mirror it is downloading from. Let us know.


  • 2009-08-06 10:36:43

    Re: Cannot Install AT 1.6.3

    Ok - I re-downloaded the program two more times (from the NY and Texas mirror sites), re-installed it two times, and got the exact same errors above again. I did a file compare of all thee downloads and they are all the same so I don't think it is a download problem. Even in step 2, if I don't change the mysql_connect statement as mentioned in my first posting above, it will not even connect to the database. I run several sites from this database server using third party software and software that I have written without any issues, so I don't know what the issue is with ATutor. In step 1 I get all green checks so the checks it goes through at the beginning seems to be ok. The permissions on the include directory and config file are 777. The database permissions are ok. It appears to me that the problem exists with the way AT connects and talks to the database. Any help will be greatly appreciated.

    Thanks,
    .........Gary


  • 2009-08-06 11:08:28

    Re: Cannot Install AT 1.6.3

    Not sure what to tell you. We've never had a problem with installing on a variety of systems. Nor have the vast majority of others. Assuming the port number is the default for MySQL, and the mysql login and password entered during the database setup step are correct, there's nothing special about the way ATutor connects to the database.

    Review the requirements again to be sure your system has everything it needs.

    Are you using standard downloads of Apache,php,mysql, or are they installed from a package of the three of them? There have been reports of people having trouble with packaged systems.


  • 2009-08-06 11:35:39

    Re: Cannot Install AT 1.6.3

    Greg,

    I am really hoping to get ATutor installed and working because it meets all of my needs. I didn't install Apache, PHP, or MySQL on my server. I have a managed server that I purchased through 1&1.com. Everything came pre-installed. I put a page out that calls PHPInfo() and everything meets all the requirements. The mysql.default_port shows no value, so I am assuming it uses the default port then. Any way of checking?

    Question: Doesn't the fact that I have to change the mysql_connect statement in the step2.php file to get it to create the database tables indicate that there is a problem with the script?

    Another Question: I noticed in version 1.6 you went to UTF-8. Could this be an incompatibility with my server? If so, Can I download version 1.5.5 to see if that will work?

    Again, thanks for your help.

    Gary


  • 2009-08-06 12:00:18

    Re: Cannot Install AT 1.6.3

    Hi, it might because somehow the global var $_POST was not handled properly by ur web server. I attached a simple test script, pls put it in ur web server and run it. Click on "Submit" button, the top line should become "Current var: test".


  • 2009-08-06 12:11:15

    Re: Cannot Install AT 1.6.3

    Greg,

    I uploaded the test script and it worked as you described. It displayed "Current var: test". I changed the word to "five" and it displayed "Current var: five". So it looks like it is ok.

    I downloaded version 1.5.5. Do you think that will be worth trying?

    Thanks,

    Gary


  • 2009-08-06 12:35:59

    Re: Cannot Install AT 1.6.3

    It should not be a UTF-8 problem, but it can't hurt to install 1.5.5 as a test.


  • 2009-08-06 14:41:05

    Re: Cannot Install AT 1.6.3

    Greg,

    Version 1.5.5 had the exact same problem. Any other thoughts? It still seems like some sort of a connection problem. All of the errors I am getting deals with PHP statements that talk to the database.

    Guess I will have to use another product because I have no other ideas. And I don't have the time to rewrite all the database statements.

    Thanks for your help.

    Gary


  • 2009-08-06 16:07:25

    Re: Cannot Install AT 1.6.3

    Its certainly a server based issue, given you are the only one that seems to be experiencing this problem.

    A couple options: install on a different system, or purchase a support ticket, and one of your staff will log onto your server to troubleshoot.


  • 2009-08-07 09:51:33

    Re: Cannot Install AT 1.6.3

    Just curious, can you do "SHOW GRANTS;" on your mysql shell and tell me if it gives you all privileges? Also, if you have more than 1 database, make sure your Apache is pointing to the right one.


  • 2009-09-06 07:21:56

    Re: Cannot Install AT 1.6.3

    If you are asking for help, provide lots of detail so problems can be reproduced.

    Things to describe:
    Operating system ATutor is installed on -
    ATutor version - unix
    Patch #s applied -
    ATutor theme name -
    PHP version - recommended version
    MySQL version - recommended version
    Webserver & version - apache (recommended version
    Copies of error messages -
    Error
    *Unable to connect to database server.
    Changes to default settings -
    Web browser being used - nothing
    ...and anything else relevant - the installation states that it is unable to connect to the database and gets stuck in the step2.
    please help me out:(


  • 2009-09-06 07:22:56

    Re: Cannot Install AT 1.6.3

    the browser is IE8


  • 2009-09-06 09:11:05

    Re: Cannot Install AT 1.6.3

    Double check your mysql login and password. This problem is usually due to typo or using the shell login instead of the mysql login.


  • 2009-09-06 12:30:10

    Re: Cannot Install AT 1.6.3

    Thank You very much.... i got it solved. You can do hope that a first time user gets this kind of errors.
    But can we test the skill of the course attendee after the completion/ partial complettion of the course? Can you help me outta this?

    cheers from india....!!!

    [reply][b]In reply to:[/b]
    Double check your mysql login and password. This problem is usually due to typo or using the shell login instead of the mysql login.
    [op]forums/view.php?fid=7;pid=18207;page=2#18586[/op][/reply]


  • 2009-09-06 14:26:52

    Re: Cannot Install AT 1.6.3

    For reference, how did you solve the problem?

    You can create a test if you want to test your attendees. See the Tests & Surveys section of the instructor handbook.


  • 2009-09-07 01:15:10

    Re: Cannot Install AT 1.6.3

    Actually, there was a messup with the database name and password. We got it right now.

    Thanks for your kind help.

    [reply][b]In reply to:[/b]
    For reference, how did you solve the problem?

    You can create a test if you want to test your attendees. See the Tests & Surveys section of the instructor handbook.
    [op]forums/view.php?fid=7;pid=18207;page=2#18589[/op][/reply]


  • 2009-11-23 17:21:27

    Re: Cannot Install AT 1.6.3

    I also have problems with installing ATutor on my 1and1 web server.

    During step 2 of the install, I get "Unable to connect to database server" error.

    Since 1and1 requires I give my hostname as "localhost:/tmp/mysql5.sock", I have my doubts whether the ATutor installation setup can process it correctly.

    I have verified that my mySQL database is working fine with my other applications including phpMyAdmin.

    Any suggestions on what I can do to overcome this problem?


  • 2009-11-24 07:50:15

    Re: Cannot Install AT 1.6.3

    "localhost:/tmp/mysql5.sock" does not sound right to me, though I don't know anything about the 1and1 setup. I suggest you talk to them, and tell them the problem.


  • 2009-11-25 07:53:16

    Re: Cannot Install AT 1.6.3

    I contacted 1and1 support with my complaint about using "localhost:/tmp/mysql5.sock" as hostname in LAMP applications.

    Their answer was...

    "If your web application will not accept 'localhost:/tmp/mysql5.sock' as a valid hostname, you may also try '127.0.0.1:/tmp/mysql5.sock' or simply ':/tmp/mysql5.sock'.

    If none of these options resolve your issue, you maybe specify the socket for connecting to mysql in the apache configuration by adding the following line to an php.ini file

    mysql.default_socket = /tmp/mysql5.sock

    and then placing this php.ini in every folder that contains a php file with a mysql connection script or by making a symbolic link to the php.ini in every folder that contains a php file with a mysql connection script."

    I tried using the 1and1 support suggested hostnames, they did not work with ATutor install step 2.

    The ATutor install step 2 DID WORK when the suggested php.ini was added to EVERY directory containing php files.
    :)


  • 2009-11-25 10:48:07

    Re: Cannot Install AT 1.6.3

    Seems like a lot of unnecessary work. I'm curious why this provider has set things up like this. It's not something we've ever encountered before.