• January 16, 2018, 08:48:39 am
• Welcome, Guest. Please login or register.
 
News: Posting problems?
If for some reasons you can not create your own topics, please see the problem thread in the "Site news & updates" board.

Author Topic: Can't Install EFiction 5  (Read 3991 times)

lucy

  • Member
  • **
  • Posts: 21
  • Country: au
  • Thanked: 1 times
Can't Install EFiction 5
« on: August 31, 2016, 12:33:11 pm »
So I don't know if I should put this topic here, if I've put it in the wrong forum, please move it. Anyway I can't upgrade to Efiction 5, this is what I've put in;

Code: [Select]
DB driver: SQL
Server: 176.32.230.53
Socket/port: 3306
 Username:cl60-rilesluc
Password:
Character set:(auto detect) UTF8 DSN string:(auto built) mysql:dbname=cl60rilesluc;host=176.32.230.53;port=3306;charset=UTF8

Code: [Select]
eFiction 3.5.x specific
Database: cl60rilesluc
Settings prefix: fanfic_table
Sitekey: rzfrkVzSHy
 Found sitename:

Code: [Select]
  eFiction 5.x specific
Database: cl60rilesluz04
 Prefix:fanfic

This is the error I get;
Code: [Select]
Failed to connect to database Server.
Last error was: SQLSTATE[HY000] [1044] Access denied for user 'cl60-rilesluc'@'%' to database 'cl60rilesluc'

Please help me with this, as I'm lost and it's frustrating me. Oh and I got the install zip from github.

Sheepcontrol

  • Administrator
  • Veteran
  • *****
  • Posts: 288
  • Country: de
  • Thanked: 50 times
Re: Can't Install EFiction 5
« Reply #1 on: September 04, 2016, 04:18:21 pm »
Might be the installer not properly handling IP+port connections, let me look into it.

Other than that, eFiction 5 is not ready to be used, yet. It's on the way, but has not arrived, yet.
I speak the worlds most widely used language: bad english

Sheepcontrol

  • Administrator
  • Veteran
  • *****
  • Posts: 288
  • Country: de
  • Thanked: 50 times
Re: Can't Install EFiction 5
« Reply #2 on: September 12, 2016, 04:38:01 pm »
Just checked, the installer should work with IP/port as well.

Does the database / or both databases exist and can the user provided access them, e.g. with phpMyAdmin ?
I speak the worlds most widely used language: bad english

lucy

  • Member
  • **
  • Posts: 21
  • Country: au
  • Thanked: 1 times
Re: Can't Install EFiction 5
« Reply #3 on: September 14, 2016, 02:25:11 pm »
Yep, the databases exist and I can access them. So not quite sure why I'm getting the error.

Sheepcontrol

  • Administrator
  • Veteran
  • *****
  • Posts: 288
  • Country: de
  • Thanked: 50 times
Re: Can't Install EFiction 5
« Reply #4 on: September 16, 2016, 01:14:22 pm »
Not sure either, but 1044 clearly states that the server could be contacted, but rejected this user accessing this very database.

Now here's a thing - maybe:
In order to be able to copy data from one database to the other, the installer needs access to both the old and the new database using the same credentials. Could it be that this user can only access one of them, but not the other? Some hosts create a new user for every database.
Would be great if you could verify this theory.
I speak the worlds most widely used language: bad english

lucy

  • Member
  • **
  • Posts: 21
  • Country: au
  • Thanked: 1 times
Re: Can't Install EFiction 5
« Reply #5 on: September 17, 2016, 12:38:38 pm »
Yeah. I think that's the issue. Do you have any suggestions on how to fix it?

Sheepcontrol

  • Administrator
  • Veteran
  • *****
  • Posts: 288
  • Country: de
  • Thanked: 50 times
Re: Can't Install EFiction 5
« Reply #6 on: September 17, 2016, 08:14:32 pm »
Well, you could do this:
Make an update within the same database using a different prefix.
Then, if desired, export using phpMyAdmin (or anything else) and import in the other database.

I fear that in order to be able to do this within the installer, I'd have to rebuild the entire thing.
Currently, however, I am trying to get all features to a beta-stage before another Christmas passes by.
I speak the worlds most widely used language: bad english

Sheepcontrol

  • Administrator
  • Veteran
  • *****
  • Posts: 288
  • Country: de
  • Thanked: 50 times
Re: Can't Install EFiction 5
« Reply #7 on: October 07, 2016, 11:38:26 pm »
Yeah. I think that's the issue. Do you have any suggestions on how to fix it?

I ran into issues with the installer, mostly it being a bodged-together nightmare, so I decided to redo most parts. Well, while I was at it, I separated the database access between old and new.

It's still throwing a few bugs, but I should have a version on Git in a few days, hope you'll have a look then.
I speak the worlds most widely used language: bad english

Sheepcontrol

  • Administrator
  • Veteran
  • *****
  • Posts: 288
  • Country: de
  • Thanked: 50 times
Re: Can't Install EFiction 5
« Reply #8 on: October 16, 2016, 11:33:39 am »
Ok, it's on Git, you may want to give it a shot.

As seen on the configuration, "old" and "new" now have two separate configuration sets.
I speak the worlds most widely used language: bad english

lucy

  • Member
  • **
  • Posts: 21
  • Country: au
  • Thanked: 1 times
Re: Can't Install EFiction 5
« Reply #9 on: October 26, 2016, 06:27:43 am »
This is what I put in, and I still get an error, I am installing it wrong? I'm not very good with this type of code.

Quote
Server:localhost
Socket/port: 3306
Username: cl60rilesluc
Password: ••••••
Database: cl60rilesluc
 Settings prefix:
Sitekey:NHKpDZ8daT

Failed to connect to database Server.
Last error was: SQLSTATE[HY000] [1045] Access denied for user 'cl60rilesluc'@'10.0.230.53' (using password: YES)
Destination (eFiction 5.x) database settings
Server:localhost
 Socket/port:3306
Username:cl60rilesluz04
 Password:••••••
 
Username: cl60rilesluz04
 Prefix:fanfiction

Failed to open eFiction 5.x database.
Last error was: SQLSTATE[HY000] [1045] Access denied for user 'cl60rilesluz04'@'10.0.230.53' (using password: YES)

I also installed it another way;

Quote

Server:127001
Socket/port: 3306
Username:cl60rilesluc
Password:••••••
Database: cl60rilesluc
 Settings prefix:
Sitekey: NHKpDZ8daT
 
Failed to connect to database Server.
Last error was: SQLSTATE[HY000] [2002] Invalid argument

Destination (eFiction 5.x) database settings
DB driver: Database: cl60rilesluz04
Prefix:fanfics

Failed to open eFiction 5.x database.
Last error was: SQLSTATE[HY000] [2002] Invalid argument
« Last Edit: October 26, 2016, 06:32:26 am by lucy »

muhkuh

  • eFI5 QC
  • Member
  • *
  • Posts: 27
  • Country: de
  • Thanked: 2 times
Re: Can't Install EFiction 5
« Reply #10 on: October 26, 2016, 08:06:22 pm »
The first try looks promising, make sure you got the right Username, Password and Database. You can usualy look up the data in your providers webinterface or ask for some support.

The second try though has a basic mistake. You provided the Server as "127001" which would indeed be a loobback to the same computer, if entered correctly. It would be "127.0.0.1" actually but would in 99% end up with the same result when using "localhost" as server.
« Last Edit: October 26, 2016, 08:08:28 pm by muhkuh »

lucy

  • Member
  • **
  • Posts: 21
  • Country: au
  • Thanked: 1 times
Re: Can't Install EFiction 5
« Reply #11 on: October 27, 2016, 05:53:51 am »
Ok so my database name and username are the same. With the info I provided what database should go in the efiction 5? As it doesn't seem to work for me.

Sheepcontrol

  • Administrator
  • Veteran
  • *****
  • Posts: 288
  • Country: de
  • Thanked: 50 times
Re: Can't Install EFiction 5
« Reply #12 on: October 27, 2016, 03:19:07 pm »
The first try looks promising, make sure you got the right Username, Password and Database. You can usualy look up the data in your providers webinterface or ask for some support.

The second try though has a basic mistake. You provided the Server as "127001" which would indeed be a loobback to the same computer, if entered correctly. It would be "127.0.0.1" actually but would in 99% end up with the same result when using "localhost" as server.

Weird enough, for PDO (the current MySQL engine for PHP), localhost has a different meaning than 127.0.0.1:
- localhost will attempt to connect through a socket
- 127.0.0.1 will open a local IP connection
There could be different issues related to that, but here comes the big but:

Code: [Select]
SQLSTATE[HY000] [1045] clearly states that there was a connection attempt, the MySQL server in fact replied, but didn't agree with the credentials provided.

The database name for the "destination" can either be a different database, combined with the right username/password or it could as well be the very same database, since you can add a prefix there will not be any data loss. It makes things slightly more messy when handling things with, for example phpMyAdmin, but that's about it.

Added: Have you taken a look at http://efiction.org/wiki/Installer_Configyet? Just updated it to reflect recent changes.

Anyway, could you send me your config.php file content, without the password that is?
« Last Edit: October 27, 2016, 04:04:48 pm by Sheepcontrol »
I speak the worlds most widely used language: bad english

Sheepcontrol

  • Administrator
  • Veteran
  • *****
  • Posts: 288
  • Country: de
  • Thanked: 50 times
Re: Can't Install EFiction 5
« Reply #13 on: October 27, 2016, 05:03:15 pm »
Important note:

there was a bug-ish thing in the code that would have removed all special characters from password, username, everything entered into the form.
This was what made 127.0.0.1 become 127001 as we saw above.

I removed this part and up'ed the code, so please d/l again and give it another shot.
I speak the worlds most widely used language: bad english

lucy

  • Member
  • **
  • Posts: 21
  • Country: au
  • Thanked: 1 times
Re: Can't Install EFiction 5
« Reply #14 on: October 28, 2016, 03:36:37 am »
That helped, however now I'm getting a different error;

Quote
Server:

176.32.230.53
 (localhost when using socket, otherwise use hostname or IP)
Socket/port:

3306
 (Empty for default)
 
Username:

cl60-rilesluc
 
Password:

•••••••••
 
 
Database:

cl60-rilesluc
 
Settings prefix:

 (if your settings table is "fanfiction_settings", then this field should be empty)
Sitekey:

NHKpDZ8daT
Below is just some technical information, mainly for troubleshooting:
Character set:
(auto detect)
UTF8MB4
DSN string:
(auto built)
mysql:dbname=cl60-rilesluc;host=127.0.0.1;port=3306;charset=UTF8MB4
Server OK
Failed to open eFiction 3.5.x database.


Quote
Internal Server Error

Undefined index: error

[install/lib/base.php:2015] Base->error()
[install/tmp/1juqfkhmrwycy.1w8ambhzc4ia.php:36] Base->{closure}()
[install/lib/base.php:2487] require()
[install/lib/base.php:2657] View->sandbox()
[install/inc/upgrade.php:53] Preview->render()
[install/lib/base.php:1486] Base->call()
[install/index.php:44] Base->run()

I think it's because I don't seem to have the right admin privileges. I've contacted my hosting provider, however they haven't gotten back to me yet. 
« Last Edit: October 28, 2016, 04:03:01 am by lucy »

Sheepcontrol

  • Administrator
  • Veteran
  • *****
  • Posts: 288
  • Country: de
  • Thanked: 50 times
Re: Can't Install EFiction 5
« Reply #15 on: October 28, 2016, 08:10:49 am »
You don't need admin privs to run this.
Any web user can do his/her stuff in their little shell.

Found an error in the config UI files ...
  • Open install/ui_en/config_upgrade.htm
  • Go to line 36
  • Towards the end, change to: "Last error was: {{ @installerCFG.error.db3 }}" (error.db3 instead of error.data)
(Changes are up on Git already)

What does it say now? Anyway, this still means, there is some issue with connecting to the db server.
I speak the worlds most widely used language: bad english

lucy

  • Member
  • **
  • Posts: 21
  • Country: au
  • Thanked: 1 times
Re: Can't Install EFiction 5
« Reply #16 on: October 28, 2016, 11:24:36 am »
I still get the same error I did before. I feel like I inputed data wrong.

Sheepcontrol

  • Administrator
  • Veteran
  • *****
  • Posts: 288
  • Country: de
  • Thanked: 50 times
Re: Can't Install EFiction 5
« Reply #17 on: October 28, 2016, 12:14:37 pm »
After the fix it should give a more detailed report.
I'll PM you.
I speak the worlds most widely used language: bad english

lucy

  • Member
  • **
  • Posts: 21
  • Country: au
  • Thanked: 1 times
Re: Can't Install EFiction 5
« Reply #18 on: November 06, 2016, 06:47:36 am »
The EFiction 3 database still won't work, also I haven't mentioned this but the error I'm getting is 500 Internal Service Error. I'm also still getting these errors at the config page;

Quote
Internal Server Error

Undefined index: error

[install/lib/base.php:2015] Base->error()
[install/tmp/1juqfkhmrwycy.1w8ambhzc4ia.php:39] Base->{closure}()
[install/lib/base.php:2487] require()
[install/lib/base.php:2657] View->sandbox()
[install/inc/upgrade.php:66] Preview->render()
[install/lib/base.php:1486] Base->call()
[install/index.php:43] Base->run()


Sheepcontrol

  • Administrator
  • Veteran
  • *****
  • Posts: 288
  • Country: de
  • Thanked: 50 times
Re: Can't Install EFiction 5
« Reply #19 on: November 06, 2016, 10:26:18 am »
Another fix on errors in the configuration tool and the UI file.

Should better handle errors with sitekey and no longer 500 on wrong stuff, instead give proper message.
I speak the worlds most widely used language: bad english