Local installation

Trying to install BNT? No guarantees we can help you (especially if you're hosting it on windows) but we''ll try.

Rincewind
Posts: 64
Joined: Thu Nov 03, 2016 5:16 am

Re: Local installation

Post by Rincewind » Sat Dec 03, 2016 5:47 am

TheMightyDude wrote:I see there is no errors on your game, what have you changed?
jsut waht you said
left it to use adodb-session2.php

and used 'mysqli'

but still it doesn't create sessions tables.

User avatar
TheMightyDude
Site Admin
Posts: 245
Joined: Thu Apr 17, 2014 9:15 am

Re: Local installation

Post by TheMightyDude » Sat Dec 03, 2016 6:08 am

Rincewind wrote:
TheMightyDude wrote:I see there is no errors on your game, what have you changed?
jsut waht you said
left it to use adodb-session2.php

and used 'mysqli'

but still it doesn't create sessions tables.
Hmm strange, I have my sessions table created.

What OS are you running?

I am running Ubuntu 14.04

All that the adodb-sessionX.php does is sets up PHP to handle all the server sessions, so in this case it creates the session table and when ever it needs to set a session variable it stores it in the database etc.
Its very basic.

Also do you still get the following error when you create the universe:

1101: BLOB, TEXT, GEOMETRY or JSON column 'SESSDATA' can't have a default value
TheMightyDude::Blacknova Development.
Development Blog Twitter Twitch

Rincewind
Posts: 64
Joined: Thu Nov 03, 2016 5:16 am

Re: Local installation

Post by Rincewind » Sat Dec 03, 2016 6:40 am

TheMightyDude wrote:
Rincewind wrote:
TheMightyDude wrote:I see there is no errors on your game, what have you changed?
jsut waht you said
left it to use adodb-session2.php

and used 'mysqli'

but still it doesn't create sessions tables.
Hmm strange, I have my sessions table created.

What OS are you running?

I am running Ubuntu 14.04

All that the adodb-sessionX.php does is sets up PHP to handle all the server sessions, so in this case it creates the session table and when ever it needs to set a session variable it stores it in the database etc.
Its very basic.

Also do you still get the following error when you create the universe:

1101: BLOB, TEXT, GEOMETRY or JSON column 'SESSDATA' can't have a default value
I don't get the 1101: BLOB error anymore, but when I create a new player I get

Code: Select all

Notice: Undefined variable: l_new_pwis in /Users/tsaulic/Sites/bnt/new2.php on line 187
followed by the password.

when I try to log in I get the usual sessions error:

Code: Select all

Session Replace: Table 'bnt.bnt_sessions' doesn't exist
I am on OS X El Capitan 10.11.3

PHP Version 5.6.27
MySQL version 14.14 Distrib 5.7.16 for osx10.11

Rincewind
Posts: 64
Joined: Thu Nov 03, 2016 5:16 am

Re: Local installation

Post by Rincewind » Sat Dec 03, 2016 6:45 am

I'm actually thinking of spinning up a vagrant machine for bnt. Will try that today I believe.

User avatar
TheMightyDude
Site Admin
Posts: 245
Joined: Thu Apr 17, 2014 9:15 am

Re: Local installation

Post by TheMightyDude » Sat Dec 03, 2016 7:11 am

Rincewind wrote: I don't get the 1101: BLOB error anymore, but when I create a new player I get

Code: Select all

Notice: Undefined variable: l_new_pwis in /Users/tsaulic/Sites/bnt/new2.php on line 187
followed by the password.

when I try to log in I get the usual sessions error:

Code: Select all

Session Replace: Table 'bnt.bnt_sessions' doesn't exist
I am on OS X El Capitan 10.11.3

PHP Version 5.6.27
MySQL version 14.14 Distrib 5.7.16 for osx10.11
Well I don't have a Mac so I wouldn't know how it runs on it, we chose to only support bnt on a Linux OS due to its free to use.

Well I am not getting anything wrong on my VM Version, mines says its sent the email but I never get it, but that is normal due to no mail server.

I did upgrade to Ubuntu 16.04 LTS just now and upgraded to PHP 7 and even more errors, so I say don't install PHP7 LOL

It just shows how old and crappy our code is :(
TheMightyDude::Blacknova Development.
Development Blog Twitter Twitch

Rincewind
Posts: 64
Joined: Thu Nov 03, 2016 5:16 am

Re: Local installation

Post by Rincewind » Sat Dec 03, 2016 7:13 am

don't be so harsh on your code haha, it's just old and not maintained as of late ;)

you get to fix it soonish I hope :P

still downloading Vagrant. their servers are ultra slow tonight.

User avatar
TheMightyDude
Site Admin
Posts: 245
Joined: Thu Apr 17, 2014 9:15 am

Re: Local installation

Post by TheMightyDude » Sat Dec 03, 2016 7:43 am

Rincewind wrote:don't be so harsh on your code haha, it's just old and not maintained as of late ;)

you get to fix it soonish I hope :P

still downloading Vagrant. their servers are ultra slow tonight.
It all depends on what is more viable.

I am aiming for a stand alone client which will use the Unity Engine, so we could have it look exactly like the current version, but allow us to add animations, 3D Objects, Sounds, Music and more later on.

And for the server, I haven't decided yet due to I keep hitting a brick wall, it could be done in PHP which outputs the requested info as JSON which the client extracts and acts on.
So this way would still be a REST type of game which still has its limitations like a browser does.

I could write complete server code from the ground up using C# or C++ which either uses TCP or UDP Packets, this is better than using REST, however it becomes an issue when we have loads of concurrent connections.

So I am thinking keep it simple and stick with it using REST and save the other way for the next game.
TheMightyDude::Blacknova Development.
Development Blog Twitter Twitch

Rincewind
Posts: 64
Joined: Thu Nov 03, 2016 5:16 am

Re: Local installation

Post by Rincewind » Sat Dec 03, 2016 3:44 pm

I say go with whatever is going to yield results faster. it's all about making it accessible and playable.

Just playing with Ubuntu via Vagrant, and it's not really happening :)

Just upgrading the box now to 14.04.5, so I hope that helps.

User avatar
TheMightyDude
Site Admin
Posts: 245
Joined: Thu Apr 17, 2014 9:15 am

Re: Local installation

Post by TheMightyDude » Sat Dec 03, 2016 3:56 pm

Rincewind wrote:I say go with whatever is going to yield results faster. it's all about making it accessible and playable.

Just playing with Ubuntu via Vagrant, and it's not really happening :)

Just upgrading the box now to 14.04.5, so I hope that helps.
Ubuntu 14.04 was what I had on my VMware and it almost worked out of the box, it comes with PHP 5.5.9 (I think), just don't upgrade to Ubuntu 16.04 which has PHP 7, way too many issue with BNT on that version.
TheMightyDude::Blacknova Development.
Development Blog Twitter Twitch

Rincewind
Posts: 64
Joined: Thu Nov 03, 2016 5:16 am

Re: Local installation

Post by Rincewind » Sun Dec 04, 2016 4:56 am

Very strange that I cannot get it to work, I must be doing something wrong.

http://110.174.197.231:8081/bnt/ (permissions vagrant:vagrant)
http://110.174.197.231:8081/ < --- php info
http://110.174.197.231:8081/bnt2/ with different permissions (root:root)
http://110.174.197.231:8081/bnt3/ with different permissions (www-data:www-data)

This is my ubuntu 14.04.5 instance

This is with your version of adodb-session.php and using adodb-session2.php with 'mysqlt' ('mysqli' produces a Cannot connect to database error)

No errors in apache error log.
The dev file is there, but I only get a white page.

:ugeek:

The phpinfo page (index.php) works though!

Post Reply