I upgraded to version 9.2. When i try to create a new project from one of the samples it gets stuck on step 4, create database. I am using SQLite and the installation is on a linux server.
Anyone have any idea why this is happening? I’m getting no errors in server logs or from scriptcase. SC is installed on my linux centos server under a domain name. I just reinstalled it and the problem persists. I am running fast-CGI on the server so all folders have to be 755 and files 644. Executable files on the server have to be 755 to run. Does scriptcase use an executable file (like .so or no extension) for the SQlite data connection? If so, that may be my issue. I would not know where to find that.
One other thing, If I try to create a new blank project only MySql show up for database connection. There are no other options including SQlite as a choice.
Found the issue:
I am running SC9 on linux with suPHP enabled. Files have to be 644 and folders 755 permissions. (executable files like .so etc have to be 755 to execute, php files run with 644 permissions)
When SC creates a new sqlite DB it sets the permissions on the file to 777. suPHP will not write to the file so trying to install one of the sample systems is not able to write to the db that was just created in devel/conf/scriptcase. This may be affecting code generation too. I changed the permissions of all .db files in my installation folder to 644 and now things seem to be working until SC tries to create a new db.
ADMIN! A LOT OF HOSTS RUN SUPHP, BLUEHOST, HOSTGATOR ETC. YOU NEED TO FIX THESE FILE PERMISSION ISSUES ONCE AND FOR ALL FOR THOSE OF US THAT PREFER TO INSTALL SC ON A LINUX HOST. THERE SHOULD BE A SELECTION IN SETTINGS THAT ALLOWS US TO INFORM SCRIPTCASE THAT WE ARE INSTALLED ON A SUPHP SYSTEM AND THEN INSTALL CORRECTLY AND GENERATE NEW FILES WITH THE CORRECT PERMISSIONS. THIS SHOULD ALSO BE A SELECTION WHEN WE DEPLOY PROJECTS, THE ZIP FILE THAT IS CREATED BY SC SETS THE FILE PERMISSIONS ON FILES SO WHEN YOU UPLOAD TO THE HOST YOU WILL GET SERVER ERRORS.
I have fought with permission issues with SC since I first stated using in with Version 5. Please figure this out. Not everyone installs on windows. If you install on a linux host it is more likely you will have suPHP running than not these days.
One other thing, you could provide a list of files that have to have executable permissions for the SC install folder AND the project once it is deployed on a host. That would be helpful. I know there are some files in _lib/prod/third that need to be executable and set to 755 to run on suPHP.