SourceForge has been redesigned. Learn more.
Close

#58 Difficulty getting past Step 1 of installer

v4.5
open
nobody
Installer (12)
9
2017-02-03
2009-09-24
Kristy
No

Not sure what I am doing wrong, but I keep getting the "couldn't connect to database server" after entering the MySQL information. I have tried using the actual server name instead of "localhost", and I have double/triple/quadruple checked my password/username for the database. I have also used my login server password/username with no luck. I was unable to find php.ini in my File Manager to "search for MySQL in php.ini."

I have tried the manual installation requests, but I have issues when I try to import the procedures into My SQL. This is the error message: "SQL query:

DELIMITER $$ CREATE FUNCTION SET_CLASS_RANK_MP (
mp_id int
) RETURNS int( 11 ) BEGIN DECLARE done INT DEFAULT 0;

MySQL said: Documentation

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DELIMITER $$

CREATE FUNCTION SET_CLASS_RANK_MP(
mp_id int
) RETURNS int(11' at line 1 "

Please help if you can! Thank you!

Discussion

  • Kristy

    Kristy - 2009-09-25

    Got past Step 1, figured out what server name to use other than "localhost". BUT when I go to Step 2, it says that a new database must be created. I kept with the same database name that I had already created and checked the box for deleting data from existing. This is what met me after loading: "This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you might want to use the less safe log_bin_trust_function_creators variable)"

    Tried letting it create a database, but it said it couldn't because there the username did not match the MySQL Connection info.

     
  • Kristy

    Kristy - 2009-10-07

    Ok, I added the update from 9/29 and it is still stalling me at Step 2. I am getting several different messages this time, and so I keep trying, hoping that it will trick itself into just doing what it is supposed to!

    Some new messages: permissions denied for admin username (which made me check the permissions to find that all were YES) - this happened when I tried to create a new database.

    When I tried to go to an existing database, I was met with the same message as I noted on 9/24/09 with a few "server" messages as well, (that I didn't notate like I should have)

    Maybe one day someone will read this and have an answer - until then I guess I will be looking for another SIS program....:(

     
  • Aecio F. Neto

    Aecio F. Neto - 2009-10-08

    Please, report more details about your installation:
    O.S. and Mysql version

     
  • Kristy

    Kristy - 2009-10-08

    Accessing my Debian platform with my Windows OS - is that what you are asking?
    MySql version 5.0.45
    I believe my site is on Linux though.

     
  • Kristy

    Kristy - 2009-10-08

    Tried the Installer yet again today, and here is the message I get after Step 2: Can't connect to MySQL server on 'mysqldb' (111) - at least it is something different!

     
  • Raymond Val

    Raymond Val - 2009-10-20

    A couple of questions:
    Are you using a hosted webserver and a hosted MySQL server?
    Have you tried using the Fully Quallified Domain Name (FQDN) of the mysql server. (ex. mysql.hosting.com)
    Have you tried using the IP address of the mysql server instead of the hostname?
    What are the permissions on your mysql account?

     
  • Manoj Sai

    Manoj Sai - 2010-04-05

    SET GLOBAL log_bin_trust_function_creators=1;
    execute the above query in mysql console it will work

     
  • bhagwan

    bhagwan - 2017-02-03

    php7.0 not supported

     

Log in to post a comment.