Won't go past initial setup screen

[trancer01]

I'm trying to install the OST on a windows 2003 with php installed (tested it, it works now) but I can't get past the initial index.php setup screen. We are using a mySQL db on a different server and no matter what, when I hit submit it just sends me to a blank page. If I don't put something in, it DOES correct me, but beyond that, nothing happens. Any thoughts.

Sorry I actually can not submit the server path at this time.

[DackR]

Take a look at this thread. I believe it may help you.

http://www.osticket.com/forums/showthread.php?t=65

(Not sure, but this could be fixed in RC2. I upgraded, so I didn't do the installer again.)

[trancer01]

no my problem is also that I can't directly modify the db (running on dreamhost's server) We would like to be able to use MSSQL but need to know the hooks or commands to tell it to use it instead of MYSQL (we have programers looking)

[DackR]

Dreamhost has the ability to edit the MySQL tables through PHPMyAdmin.

I found the info on their web site:
http://blog.dreamhosters.com/kbase/index.cgi?area=27

Edit: Just double-checking, but you're using the RC2 release, right? (It would be cool if the installation was already fixed in RC2... or future releases)

[trancer01]

ahhh I see! so then do I add it as a table not as a "row"

[DackR]

basically, just find and click the osticket database name on the left side-bar then click the ost_config table and then click the insert tab on the main page. (leave the default values and click 'go' to insert.)

Hopefully that made sense...

[trancer01]

makes sense but I don't think the installer has even started to write to the DB because there is nothing in the db, no tables no nothing.

[DackR]

Ok... weird... You can add the tables into your database manually

First, make a blank database (named something like 'osticket') if you haven't already.

Next you will need to modify the osticket.sql file....
Find the './setup/osticket.sql' file on the server, and open it in wordpad.
Find and replace anywhere where it reads '%TABLE_PREFIX%' with the desired table prefix. (default is 'ost_')

Finally, import the modified file using the PHPMyAdmin interface into your new database.

Edit: After adding the tables, you may also want to check your ./config.php file to make sure it is pointing to your mysql server correctly:

#Mysql Login info
define('DBTYPE','mysql');
define('DBHOST','youhostserver');
define('DBNAME','osticket');
define('DBUSER','username');
define('DBPASS','password');
#Table prefix
define('TABLE_PREFIX','ost_');

[trancer01]

sorry, yes I am using RC2
k thanks for that last edit,
modded the config file, then it errored saying that it may already be complete, but that the config file had been modified and may not be "clean"

so I replaced the config file, and now I'm at least getting an error code of 500

[DackR]

Sorry it took so long for me to respond. Work emergency. I'm not sure what error code 500 means. Does it give any other message?
EDIT:
Ok... I tried my own steps and found the error saying that it may already be installed... and found the issue... one more edit in the config.php file.

change the line:
DEFINE('OSTINSTALLED', FALSE);
to
DEFINE('OSTINSTALLED', TRUE);

Once this is changed, you should be able to access the admin page.
'./scp/'

[DackR]

One more thing... If you get to the admin login page and you cannot login, you may need to manually add an admin user into the database.

To do this, insert a new row in the ost_staff table.
username: Admin
firstname: Admin
lastname: User
password: 04ca3c2a1ee24aa29541a0de2a822455
email: whatever you want
isactive: 1
isadmin: 1
isvisible: 1

Add this information and try to login with password: adermin

(not 100% that this will work because I am unfamiliar with the encryption process used by osticket for the passwords, but it's worth a shot.)

[trancer01]

nope didn't work, still getting the 500 error
but the index.php did say the same as before even after putting TRUE in there

[DackR]

It gave the 500 error after you replaced the config.php file, right? Have you made sure your security settings are correct for the config.php file? Also, you'll want to re-modify the config.php file as it sounds like it will be required for your issue.

ALSO- just wanted to confirm, but does the error go like this: "HTTP 500 - Internal Server Error", if so, it sounds even more like the security settings were cleared from your config file after replacing it.

[trancer01]

yes that is the error.
so if that's the case, what kind of settings does it need? we essentially chmoded it to 777 (yes I know it's windows, so the windows equivilent)

and what do u mean by "re-moddify" the config file? how?

[DackR]

yes that is the error.
so if that's the case, what kind of settings does it need? we essentially chmoded it to 777 (yes I know it's windows, so the windows equivilent)

and what do u mean by "re-moddify" the config file? how?

I'm sorry that I am not very good at giving directions. I am assuming a couple of things...

That when you copied the config.php file, I assume you remembered to make it world readable.

Just in case:
In Internet Information Services(IIS) right click on the web site, click properties, directory security, edit... This will show the user name configured for anonymous access. Remember this. To make the config.php file world read-able you will need to right click on the file in explorer and change the security settings for that user to make sure it has read and execute permissions.

By re-moddify the the config file, I mean to apply the changes you made to it (config.php) previously but then wiped out by copying the default file over it.

Sorry if I'm being unclear. It's been a long day. ;)

(Basically if you can get back to the config file may not be clean error, you are one or two steps away from being done.)

[trancer01]

No I appreciate the help, I had thought that we had already set it to those permissions. I will have to check in 2 weeks (goin on vacation) but thank you and I'll let you know what happens. Really appreciate your help!:D

[DackR]

No problem. See you again in two weeks! Have a good vacation! :)

[trancer01]

ok I'm back and I have MySQL installed and I've thrown everything away and started from scratch and guess what...same damn thing! It thinks that the OST is already setup and won't let me do anything.

[trancer01]

what tables need to be created/added for this to work?

[bigben]

Go into the setup folder, inside there is the osticket.sql that has all the setting you would need to run against the sql server to create the tables needed.
Good luck,
Ben

[trancer01]

god I wish my boss would just let me do this on a linux box

here's the new issue of the day

Warning: session_start() [function.session-start]: open(C:\DOCUME~1\XXXXXX\LOCALS~1\Temp\php\session\ sess_iiql2mmpefl624gcja1odul7e5, O_RDWR) failed: No such file or directory (2) in C:\home\support\upload\setup\setup.inc.php on line 26


Warning: Unknown: open(C:\DOCUME~1\XXXXXX\LOCALS~1\Temp\php\session\ sess_iiql2mmpefl624gcja1odul7e5, O_RDWR) failed: No such file or directory (2) in Unknown on line 0

Warning: Unknown: Failed to write session data (files). Please verify that the current setting of session.save_path is correct (C:\DOCUME~1\XXXXX\LOCALS~1\Temp\php\session) in Unknown on line 0


what I can tell is that someone else logged into the box in another session, they didn't access these files but somehow it cached them.
I've tried clearing their temp files, restarting, and even removed all of the install files and replaced them with clean ones. I'm getting the same errors.

any thoughts?