Loading...
 
Skip to main content

Architecture / Installation

Forum List Topic List

 
Thread actions
Print this page
  • Print all pages

    • tiki4 installation problem

    Posted by noam

    after following all the wizard steps, i get
    "The following error message was returned:
    SQLSTATEHY000 2002 Invalid argument"
    as the 1st response of the portal (just after final step of the wizard)

    i am running on vserver /debian, and using xampp 1.7.2
    tiki3.3. is running perfect on same setup, but since i am just starting to use it, i rather go to 4.0 now, instead of upgrading later on.

    any help ?

    thanks

    Noam

    Reads: 3785
    Posted by noam

    Problem solved😊

    after googling, i have found out that you need to modify the php.ini, to include the following line:
    pdo_mysql.default_socket=/opt/lampp/var/mysql/mysql.sock

    once done (and off course restart xampp), everything works find

    noam


    Posted by JustKen

    Hi all,

    I'm having problems with migrating my website, built with Tiki 9.1, from my development environment on my local xampp W7 host to my production environment on BellHosting.ca. I've set up a database in the environment and was able to import my database tables. I was also able to upload the tiki installation files to the file system on BellHosting (with some "file already exists" errors - a clue?) and I could start the tiki installer. I passed the memory test, and the email test, but I'm hitting the error message that you see in the message title above, with the detail text "Can't connect to MYSQL Server on my_domain_name(111)". I searched the forums and found a little information, such as the need to modify php.ini (which I probably won't be allowed to do in my environment) and a statement that someone else with the same problem was "using the wrong hostname". But none of the advice seems to be applicable or effective. I have some questions, then:

    What should I use for the Host Name field? The help button says to use localhost if the database is running on the same sever as tiki. Does this apply to remote servers? Should I use localhost even on a remote server? Or should I use my proper domain name? FYI neither option gets me past the problem.

    Would the manual installation procedure work for me (i.e. would it be worth trying)? I don't have shell access.

    Thanks! I really want to make this work.


    Posted by pdallaire

    I got the same issue with Bell Hosting for one of my client. The problem is Bell, it’s the worst hosting you could get.

    The database is set in ISO-8859 but you need UTF-8. So you have to call them and ask for change the setting.

    After, everything should work but my client has some problem with the session and sometime with the database setting cause of Bell.

    So the best solution for you it’s to change hosting for something like dreamhost or some else.

    Posted by JustKen

    Thanks pdallaire! I have a call in with Bell Hosting and I'll ask them to make that change. I have no choice but to work with Bell Hosting: It's where my client has her business account.

    JK

    Posted by JustKen

    I discovered I could change the character set to utf-8 myself. However that didn't fix the problem. I looked up the 111 MySQL error code and a lot of the suggestions for fixing the problem involve configuration changes that I can't do on my web host. I called the Bell Web Hosting support and, predictably, they said that they can't help with "third party products".

    I tried the manual install also, and set up my db/local.php file and uploaded it. But this caused a "server not found" error. Sigh.

    It might be time to try dreamhost.