ATutor

Install MYSQL problem

• weemooseus
  

  2007-04-08 01:25:37

  Install MYSQL problem

  Server: Windows, (shared access)
  mysql 4.1.18
  
  
  Just installed ATutor 1.5.3.3 and I have the following errors repeated 9 times each:
  
  Warning: mysql_real_escape_string() Access denied for user 'ODBC'@'localhost' (using password: NO) in C:\Inetpub\vhosts\chaparralmiddle.us\httpdocs\atutor\install\include\common.inc.php on line 37
  
  Warning: mysql_real_escape_string() a link to the server could not be established in C:\Inetpub\vhosts\chaparralmiddle.us\httpdocs\atutor\install\include\common.inc.php on line 37
  
  Here is where the table creation seemd to have failed.
  -------------------------------------------
  if ($prefixed_query != false ) {
  $table = $_POST['tb_prefix'].$prefixed_query[4];
  if($prefixed_query[1] == 'CREATE TABLE'){
  if (mysql_query($prefixed_query[0],$db) !== false) {
  $progress[] = 'Table <strong>'.$table . '</strong> created successfully.';
  } else {
  if (mysql_errno($db) == 1050) {
  $progress[] = 'Table <strong>'.$table . '</strong> already exists. Skipping.';
  } else {
  $errors[] = 'Table <strong>' . $table . '</strong> creation failed.';
  }
  }
  --------------------------------------------------------------
  
  When I look at phpmyadmin, it seems that the table for users is there, but its not. Can I fix the install or do I delete and start over. I cannot figure why it created the first tables, but not the last.
  
  Thanks,
  
  Carl

• greg
  

  2007-04-08 08:16:04

  Re: Install MYSQL problem

  I have not seen this happen before. I'd suggest starting over with a fresh install.

• weemooseus
  

  2007-04-08 23:25:41

  Re: Install MYSQL problem

  Ok, install did the same thing, I am having the host provider check the php settings before I go any further. I cannot create my own databases with mysqladmin, I have to use their tools, unfortunately -- I don't think I can edit their script, but I am still checking. I do have access to phpmadmin. I think it is a problem with the specification "if not exists" -- even that I am not sure of.
  
  Will post what I find out.
  
  Thanks,
  
  Carl
  
  [reply][b]In reply to:[/b]
  I have not seen this happen before. I'd suggest starting over with a fresh install.
  [op]forums/view.php?fid=7;pid=10319;page=1#10321[/op][/reply]

• weemooseus
  

  2007-04-09 20:55:52

  Re: Install MYSQL problem

  Further Info:
  
  Here are the settings from the company that is hosting my space:
  
  MySQL 4.1.18-nt
  PHP Version 4.4.2
  Zlib 1.2.3
  
  I just finished the third install with exactly the same results, so its predictible. It may be a script setting in the setup for the database, (which they won't let me edit).
  
  I think this has them wondering as they have offered to look at the install to see what is going on. ATutor was much easier to set up when I had full control of the environment.
  
  Carl
  
  [reply][b]In reply to:[/b]
  I have not seen this happen before. I'd suggest starting over with a fresh install.
  [op]forums/view.php?fid=7;pid=10319;page=1#10321[/op][/reply]

• weemooseus
  

  2007-04-10 01:44:49

  Re: Install MYSQL problem

  Ok, this is what they say about the common.inc.php file, what I need to know is if I can do this before installing?
  
  Please advise.
  
  Carl
  -------------------------
  Reply:
  
  It appears that the script is attempting to connect to user ODBC with no
  password instead of the user that you have created. You may want to edit the
  script before you upload it to include the proper user and password.
  
  I hope this helps, Please advise, Thanks!
  
  If you require additional assistance, please do not hesitate to contact us
  again.
  
  Best Regards,
  
  [reply][b]In reply to:[/b]
  I have not seen this happen before. I'd suggest starting over with a fresh install.
  [op]forums/view.php?fid=7;pid=10319;page=1#10321[/op][/reply]

• weemooseus
  

  2007-04-10 02:35:35

  Re: Install MYSQL problem

  Ok, problem solved, ATutor installed and working correctly. What they told me didn't make sense as the file doesn't exist untill ATutor is installed.
  
  The installation was hanging on creating the statistics report back to here, when I left that step off of ATutor install, it worked!
  
  Thanks for the help.
  
  Carl
  
  [reply][b]In reply to:[/b]
  Ok, this is what they say about the common.inc.php file, what I need to know is if I can do this before installing?
  
  Please advise.
  
  Carl
  -------------------------
  Reply:
  
  It appears that the ...
  [op]forums/view.php?fid=7;pid=10319;page=1#10336[/op][/reply]

• greg
  

  2007-04-10 08:24:15

  Re: Install MYSQL problem

  Thanks for persisting. It's good to hear there's nothing wrong with the installer.
  
  The fact that it hung when trying to send the system information means the system's mail server is probably not working. You may want to test the mail functions in ATutor. The mail server needs to be setup in the php.ini file by the system's administrator.

• weemooseus
  

  2007-04-11 20:45:24

  Re: Install MYSQL problem

  Mail functions seem to be working fine -- at least students can reset forgotten passwords, set up cron, (they called it a scheduler). I even installed a module, probably will install more as time goes on.
  
  Will post if anything goes wrong, right now its running great.
  
  [reply][b]In reply to:[/b]
  Thanks for persisting. It's good to hear there's nothing wrong with the installer.
  
  The fact that it hung when trying to send the system information means the system's mail server is probably not...
  [op]forums/view.php?fid=7;pid=10319;page=1#10340[/op][/reply]

• weemooseus
  

  2007-04-20 01:04:27

  Re: Install MYSQL problem

  Upgraded to latest stable version, no problems!
  
  [reply][b]In reply to:[/b]
  Mail functions seem to be working fine -- at least students can reset forgotten passwords, set up cron, (they called it a scheduler). I even installed a module, probably will install more as time goes...
  [op]forums/view.php?fid=7;pid=10319;page=1#10365[/op][/reply]