Can't get SQL Buddy working from the start

[Jamie LeBlanc]

I downloaded SQL Buddy, got it all installed and ran into permission
denied issues. I found out that my server had to be reconfigured to
allow index.php as part of the allowed indexes. Once I got that done I
finally got to the login page. Once I was there, I went to login, but
it just keeps redirecting me back to the login page. I then proceeded
to change the SQL Buddy config file to add in the default username and
password and now it just keeps redirecting in an infinite loop. Anyone
have any ideas what the problem is and how to fix it. I am looking to
setup a program to administer my MySQL database, but I spent 4 days
and couldn't get PhpMyAdmin working, so I thought I would try SQL
Buddy, but yet even that isn't working right.

Is there any MySQL web based program that actually works after being
installed? I have tried a few of the most popular ones, but after a
full week of no luck, I am close to giving up. If anyone out there
knows how to get the SQL Buddy setup from the beginning working,
please reply back. Thanks.

[Steve Gricci]

Jamie,

Both PHPMyAdmin and SQL Buddy work after simply extracting them to a web directory for me on countless servers that I've installed them on.

I have to assume here that the problem isn't these programs, but your server, since I've never had any issues.

Have you tried looking at the php error log after it redirects you when you try to login?

--Steve

[Jamie LeBlanc]

I checked the error log, but there were no errors. That is the hard
part about this. If I saw an error at least I would have some sort of
clue. I just login, and it redirects back to the login page.

[Jamie LeBlanc]

When it came to phpmyadmin, I got the same error that tons of people
out there are getting too. It is the invalid type error.

import.php: Missing parameter: import_type

There are a bunch of people online who have gotten that error with no
fix for it. Very annoying and stops you from doing any action in
phpmyadmin. I don't really care which of these 2 programs I get
working, I would just like one of them to work, but both of them right
out of the box required configuration changes, or like phpmyadmin,
needed modules like mycrypt to be installed etc. It would have been
nice if one of these programs worked out of the box after untarring it
like they claim.

On Nov 9, 8:51 am, Steve Gricci <st...@gricci.org> wrote:

[Calvin Lough]

It sounds like you don't have sessions enabled for php. Or maybe you are blocking cookies in your browser.

Calvin

[Jamie LeBlanc]

I have sessions enabled in PHP since I use them for many sections of
my site, and I verified they are working. I also don't have cookies
blocked in my browser. I checked all of that stuff when I had issues
with PhpMyAdmin.

On Nov 9, 10:19 am, Calvin Lough <calvinlo...@gmail.com> wrote:
> It sounds like you don't have sessions enabled for php. Or maybe you are
> blocking cookies in your browser.
>
> Calvin
>

[Steve Gricci]

Calvin,

Do the sessions in SQL Buddy start themselves or rely on PHP to autostart them?

Jamie,

Do sessions autostart or do you have to call session_start()?

--Steve

[Steve Gricci]

Also, Jamie:

In the index.php file, right after the <? (or <?php) tag, add error_reporting(E_ALL);

That may show some things in the error log that may be squelched by your configuration.

--Steve
On Nov 9, 2011, at 10:55 AM, Jamie LeBlanc wrote:

[Jamie LeBlanc]

Sessions start automatically, and I added in the error reporting line,
but id didn't do anything.

[Calvin Lough]

Steve, SQL Buddy calls session_start(), so it shouldn't matter if autostart is turned on or off.

Calvin