Unable to connect to MySQL server. Possibly invalid login info.

MySQL Table Prefix: ost_

MySQL Hostname: localhost

MySQL Database: osticket

MySQL Username: what goes here?

MySQL Password: what goes here?

Trying to install on SME 7.4 which is based on Centos

mkdir -p /temp/downloads

cd /temp/downloads

wget http://www.osticket.com/download/osticket_1.6.rc4.tar.gz(http://www.osticket.com/download/osticket_1.6.rc4.tar.gz)

tar xvzf osticket_1.6.rc4.tar.gz

mv /temp/downloads/osticket_1.6.rc4 /opt/osticket

chown -R www.www(www.www) /opt/osticket

chmod 750 /opt/osticket

mkdir -p /etc/e-smith/templates-custom/etc/httpd/conf/httpd.conf/

mkdir -p /opt/osticket/upload/attachments

chmod 777 /opt/osticket/upload/attachments

osTicket installer needs to be able to write and modify ostconfig.php found in the upload's root directory. Change the permission settings for the ostconfig.php file so that it is writable by the webserver.

chmod 777 /opt/osticket/upload/ostconfig.php

Create a Template Fragement

cd /etc/e-smith/templates-custom/etc/httpd/conf/httpd.conf/

pico 99osticket

# osticket

Alias /support /opt/osticket/upload

Options -Indexes

AllowOverride None

order deny,allow

deny from all

allow from all

AuthName "osticket"

AuthType Basic

AuthExternal pwauth

Satisfy all

AddType application/x-httpd-php .php .php3

php_admin_value open_basedir /opt/osticket/upload/:/tmp

php_flag magic_quotes_gpc on

php_flag track_vars on

Save by pressing Ctrl x, press y to save changes and press enter

expand-template /etc/httpd/conf/httpd.conf

/etc/rc.d/init.d/httpd-e-smith restart

Create Database

mysql -e "create database osticket"

mysql -e "grant all privileges on osticket.* to osticketuser@localhost identified by 'osticketpassword'"

mysql -e "flush privileges"

Right here below.

This webpage setup screen is where I am getting the top line error message.

Using web installation script

Once all of the above steps are complete, you can complete the installation and basic setup in a web browser. You can invoke the installer by simply browsing the osTicket URL http://www.yourdomain.com/support/setup(http://www.yourdomain.com/support/setup)

http://www.yourdomain.com/support/setup(http://www.yourdomain.com/support/setup)

Finishing Up

If the setup script has finished running with no errors, then congratulations osTicket is installed. Your next step should be to fully configure your new support ticket system for use, but before you get to it please take a second to cleanup.

Change permission of ostconfig.php to 644

Delete install directory.

cd /opt/osticket/upload

chmod 644 ostconfig.php

rm -rf /opt/osticket/upload/setup

mysql

Do I have to be on the server to install osticket. I have been trying all this over a VPN connection.

NO, you can upload it and run it from anywhere. You do have to create a mysql database first though, setting up a user name and password, before the install.

NO, you can upload it and run it from anywhere. You do have to create a mysql database first though, setting up a user name and password, before the install.

I thought I did when:

expand-template /etc/httpd/conf/httpd.conf

/etc/rc.d/init.d/httpd-e-smith restart

Create Database

mysql -e "create database osticket"

mysql -e "grant all privileges on osticket.* to osticketuser@localhost identified by 'osticketpassword'"

mysql -e "flush privileges"

Got it! See what you did? Made me go back and read what I was suppose to be using. Thanks!

Now how do I get back to the setup after cleanup?

After you finish the install and delete the directory? For configuration you need to login to http://www.yourdomain.com/support/scp(http://www.yourdomain.com/support/scp)

After you finish the install and delete the directory? For configuration you need to login to http://www.yourdomain.com/support/scp(http://www.yourdomain.com/support/scp)

Got it thanks again.

Write a Reply...