Support Forums
ATutor Support
Cannot Install AT 1.6.3
You must be signed-in to post.
| Author | Subject | |
|---|---|---|
| Page: 1 | 2 | ||
| TrakSoft | Subject: Cannot Install AT 1.6.3 |  |
| 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 Posted: 2009-08-01 17:08:32 | ||
 | ||
greg | Subject: 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. Posted: 2009-08-01 17:57:54 | ||
| ||
harris | Subject: Re: Cannot Install AT 1.6.3 | |
| Also check your database user privileges. Posted: 2009-08-04 09:15:52 | ||
| ||
| greg | Subject: Re: Cannot Install AT 1.6.3 | |
| When you download, make a note of the mirror it is downloading from. Let us know. Posted: 2009-08-04 17:48:49 | ||
| ||
| TrakSoft | Subject: 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 Posted: 2009-08-06 10:36:43 | ||
| ||
| greg | Subject: 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. Posted: 2009-08-06 11:08:28 | ||
| ||
| TrakSoft | Subject: 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 Posted: 2009-08-06 11:35:39 | ||
| ||
cindy test.php 
| Subject: 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". Posted: 2009-08-06 12:00:18 | ||
| ||
| TrakSoft | Subject: 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 Posted: 2009-08-06 12:11:15 | ||
| ||
| greg | Subject: 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. Posted: 2009-08-06 12:35:59 | ||
| ||
| TrakSoft | Subject: 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 Posted: 2009-08-06 14:41:05 | ||
| ||
| greg | Subject: 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. Posted: 2009-08-06 16:07:25 | ||
| ||
| harris | Subject: 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. Posted: 2009-08-07 09:51:33 | ||
| ||
| sumanthkulkarni13 | Subject: 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  Posted: 2009-09-06 07:21:56 | ||
| ||
| sumanthkulkarni13 | Subject: Re: Cannot Install AT 1.6.3 | |
| the browser is IE8 Posted: 2009-09-06 07:22:56 | ||
| ||
| Page: 1 | 2 | ||
You must be signed-in to post.