Hi all,
This is my attempt to get a grasp of properly setting up multiple MySQL databases, for the purpose of being able to run multiple sites.
Eventually this 1st post might end up as a basic HowTo, but for now I start with one of the 1st problems I encountered with it.
Initially I did the following:
[ul]Created web enabled Flexshares[/ul][ul]Installed the latest PHP
1 was the admin account and 2 were unreadable words
(I thought that it was pure logic to remove them too, so I didn't write them down ... :blush: )[/ul][ul]I successfully recreated a database and setup Drupal again.[/ul]
Then the problem started ...
hmy:
Now I am unable to browse to the Gallery site (error: "Gallery requires short_open_tag to be on.")
[ul]Would it be a good idea to also remove Gallery 3 and it's database and start from scratch ... ?!?[/ul][ul]Also ... can I remove the "lost+found" database ... ?!?
It appeared after I added an empty disk for the flexshares.[/ul]
Please advice,
John
This is my attempt to get a grasp of properly setting up multiple MySQL databases, for the purpose of being able to run multiple sites.
Eventually this 1st post might end up as a basic HowTo, but for now I start with one of the 1st problems I encountered with it.
Initially I did the following:
[ul]Created web enabled Flexshares[/ul][ul]Installed the latest PHP
yum --enablerepo=timb upgrade phpyum --enablerepo=timb-testing install PHP-xml PHP-gd1 was the admin account and 2 were unreadable words
(I thought that it was pure logic to remove them too, so I didn't write them down ... :blush: )[/ul][ul]I successfully recreated a database and setup Drupal again.[/ul]
Then the problem started ...
hmy: Now I am unable to browse to the Gallery site (error: "Gallery requires short_open_tag to be on.")
[ul]Would it be a good idea to also remove Gallery 3 and it's database and start from scratch ... ?!?[/ul][ul]Also ... can I remove the "lost+found" database ... ?!?
It appeared after I added an empty disk for the flexshares.[/ul]
Please advice,
John
In Database
Share this post:
Responses (13)
-
Accepted Answer
-
Accepted Answer
-
Accepted Answer
You can find explanations in the apache docs
http://httpd.apache.org/docs/2.2/mod/core.html#allowoverride
http://httpd.apache.org/docs/2.2/mod/core.html#directory
Apache has to have some default settings to setup the webroot directory /var/www/html. You can actually have any number of different configs for sub directories or virtual hosts...these can be applied via a *.conf file in /etc/httpd/conf.d/ or as an .htaccess file within the folder itself -
Accepted Answer
Hi all,
I can report that the last problem I reported has been solved and the solution makes it rather off-topic.
But since I don't know the consequences, can some one please enlighten me ... ?!?
I found this in a post on some unknown forum from 2004 ... :blush:
/etc/httpd/conf/httpd.conf
<Directory />
Options FollowSymLinks
AllowOverride All
</Directory>
Changed to:
<Directory />
Options FollowSymLinks
AllowOverride None
Order deny,allow
allow from all
</Directory>
Finished with:
# service httpd restart
But what did I do by making these changes and what is the reason for these 'default' settings ... ?!?
Please advice,
John -
Accepted Answer
Hi all,
This is the next problem I encountered:
I successfully installed Gallery and Joomla to Flexshares and I am able to access and configure them with the web browser.
When I tried to install Dolphin I ended up with the following result:
Forbidden
You don't have permission to access /flexshare/<flexshare>/index.php on this server.
Apache/2.2.3 (ClearOS) Server at <domain>.com Port 80
At first I thought that this was a DNS issue, but because I am able to start configuring Dolphin, I created a database & the admin. acc. in the following way:
[ul]From the home privileges while selecting the corresponding database (Using phpMyAdmin).[/ul][ul]Directly from the databases privileges (more logic to me and because the previous did not work).[/ul]
The same error appears when attempting to install Dolphin in a virtual domain.
[ul]The error assumes that this is an acc./rights issue, so why should this have anything to do with the DNS when I am able to successfully access the other web Flexshares ... ?!?[/ul]
I could explain the whole process in detail, but that would be too much, so if anyone has an idea I would be happy to hear it.
Please advice,
John -
Accepted Answer
Hi all,
Here's an update ...
I recreated the problem on the virtual COS box (so I guess I broke it), but without the 3 red marked lines.
Thanks to Tim's "phpinfo.php" script I was able to successfully edit the correct php.ini file ... :woohoo:
But when I tried to browse to the gallery page I got this memorable picturehmy: :
So I dropped "gallery3" & "lost+found", recreated gallery3 and then it hit me.
Every time when I add a new database I assumed that I needed to create a new administrator account for it and I selected this option:[ul]Create database with same name and grant all privileges[/ul]I suspect that that's the reason why I have an administrator database and that when doing that twice something maybe breaks ... ?!?
Can someone please explain what the differences are (I searched geugle & the MySQL help, but no luck ... :blush
:
Database for user:
[ul]None[/ul][ul]Create database with same name and grant all privileges[/ul][ul]Grant all privileges on wildcard name (username\_%)[/ul][ul]Grant all privileges on database "gallery"[/ul]
Then I emptied the gallery Flexshare and unzipped a clean version and ... :woohoo: ... tadaaa ... hehe
Please advice,
John -
Accepted Answer
Thank you Tim & Andy,
It's not fixed yet, but you were right about me prepping a M$ Windoze sledge hammer ... lol.
The 2nd picture is from the virtual COS box after just installing Gallery 3 on it.
I will drop the database of "gallery" & "lost+found" after I recreated the situation on my virtual COS box ... even if it brakes it.
I didn't create the "lost+found" database, it appeared after I mounted an additional disk, so I don't know where it came from.
AFAIK, the "administrator", "test", "mysql" & "information_schema" database was there before I installed Gallery 3, but no other 3rd party software has been installed yet, so I will drop the "administrator" & "test" database on the virtual COS box 1st.
Eventually I will either end up with (the default databases of my virtual COS box):
administrator
test
mysql
information_schema
or like Tim & Andy suggested:
mysql
information_schema
Wish me luck ... :huh:
John -
Accepted Answer
-
Accepted Answer
So is it fixed? no need to throw the window$ sledge hammer of reinstalling everything to get it to work
The administrator and lost+found database don't exist on mine...you must have made them
Just remove / drop the gallery database and start the install again if you wish.
Gallery3 only requires 1 database, in my case it is called gallery3. Have you read the gallery3 installation notes?
http://codex.gallery2.org/Gallery3:User_guide:Gallery3:Installing_and_upgrading -
Accepted Answer
Thanks Tim,
I freaked out when it happened so I forgot the most simple thing ... :blush:
I was thinking along the line of removing PHP and reinstalling it and I was attempting to recreate this issue on a virtual COS box.
But if it is not necessary to break it, I'd rather not.
Anyway ... the "short_open_tag" is set to "on" in my "php.ini".
[ul]So I guess it would not hurt to remove the "gallery" & "lost+found" database if I want to start from scratch ... ?!?[/ul]
The "administrator", "mysql", "test" & "information_schema" database I'd rather not touch, because I have no clue what it's meant for, but it was also there in my virtual COS box ... or should I ... ?!?
Just after I installed Gallery 3:
Greetings,
John -
Accepted Answer
First google search for "Gallery requires short_open_tag to be on" = http://gallery.menalto.com/node/86140
You need to enable it in your PHP config...edit /etc/php.ini and turn it on, then 'service httpd restart'
To remove a database using PHPMyadmin just select the database, and then click the red "DROP" button in the top right hand corner.
Please login to post a reply
You will need to be logged in to be able to post a reply. Login using the form on the right or register an account if you are new here.
Register Here »