https

[echo@]

hi everyone
I know that this might not be indexu related BUT...

I was hoping someone could point me in the right direction for this one.

I would like to setup phpadmin on my webhost (have tried and got stuck), I want to install this so that i can have greater control over mysql database.

I would like to move many subcategory's at once and using the admin backend is taking for ages and giving me carpel tunnel syndrome

So question 1 would be.. is the possible with phpadmin?


and the point of the thread title
Question 2, when i install phpadmin (through the web interface) it asks for a HTTPS secure connection. I would rather configure using a HTTPS, anyone know how this can be done??
Do webhosts have HTTPS disabled as default, and a command / switch need to be added to the .htaccsess to turn HTTPS on in apache

My host offers me a "Free SSL sertificate" if that helps

I admit im not sure whatsoever, but am competent to install with some advise . As is most things you do for the first time.

How have you guys installed your phpadmins? ( Yes I have read the wiki )

Happy Christmas Everyone

[Bruceper]

Thread moved to appropriate forum

HeidiSQL (http://www.heidisql.com <- free!) is what you want, or even better would be to write out the MySQL commands and dump them all at once and make a million changes in seconds. I can attempt to help you with some commands if you would like. I am NOT a know all expert in MySQL but I can usually make it do what I want.

To use HTTPS you first need
1) a unique IP address
2) An SSL Certificate

OR
A server assigned SSL Cert which really isn't valid, but does the job and is secure.

Secure HTTP is not a function of the webhost, it is a function of Apache and SSL. SSL Certificats range in price from $40-several hundred dollars depending on what you're putting behind them.

Your host will offer you a "free" certificate that is generated by your control panel (such as WHM). It will work, but it will have errors.

Most users that I've spoken with use cPanel servers, which have phpmyadmin installed by default.

[inspireme]

ask your host if they have phpmyadmin, most will run it anyway - often a host will run a database server so you would need to know the exact url to be able to use it, and it isnt always in the control panel.

[echo@]

Thank you very much for your support much appreciated

My host offers a variety of SSL certificates, the two that I think i can use

• Apache/Mod SSL
• Apache - SSL (Ben-SSL, not Stronghold)

I have checked my phpinfo.php to see if i have the mod installed for "Apache/Mod SSL" but I don't. So i guess its the Apache - SSL (Ben-SSL, not Stronghold). And then its the question of how I add it to apache, my shared server runs apache but how do i administrate it, Do i telnet to it and login.
Really I have not got a clue, Does cpannel let you do this?

I do not have Cpannel with my host, or phpadmin either

I am on a shared host, my ip resolves to superultra25.uk2.net, so i guess im not running a unique ip either.

will move host at the end of my renewal

I have downloaded and installed heidiSQL but am struggling to get logged in to mySQL. I have entered all the credentials correctly, I bet my host Denys incoming connections to MYSQL, i am connecting on port 3306 so will look to see if they have changed the ports. Have searched the heidi forum but no threads for "SQL Error: Access denied for user" .

Im not asking for help as your time is like gold dust, and im sure you've got a stack of work mate I was just curious if it could be done in an easier way, (which it can for 99% of the people out there, just not for the 1% of unlucky buggers like me, who for some reason have been cursed, and are born to struggle & burn in hell forever) I will continue to modify manually until my hand falls off.


Wish the easy things like logging in would work, I am getting very disillusioned with computers.

It amazes me the time i waste

Thanks Peter

[Bruceper]

Those aren't SSL Certificates, those are SSL modules for Apache. Ask your host if they'll install phpmyadmin for you or take a look over at Google, there's lots of site that show how to install phpmyadmin.

Ask your host for access to the MySQL Database from your IP address, they may not allow direct connections. HeidiSQL will save you a ton of time and may be even better than phpmyadmin because you can do everything you can with phpmyadmin but on your desktop.

I don't think you're cursed, perhaps just unlucky as you said. Don't get disillusioned at all, a great host makes all the difference in the world.

[echo@]

I have decided not to commit suicide, instead i have persevered with myphpadmin and finally got it installed .
In fact it was so easy to install it actually made it more complicated.
If only the installation guide was more user friendly I would of had this done ages ago.

Now I have looked at Myphpadmin for the first time (giving me a view of indexu under the hood) and I am "understanding" the structure.

What I would like to do now is move all subcategory's into the main category, so all category's are listed there on view

(as users have been complaining of "Sorry, you are not allowed to submit here" when adding links, the problem is when they add their category's they do not have the recourse to click "again" on the category's drop down box thus expanding the subcategory's to add in.
This results in the user blindly adding into a primary category that they don't have permission to add to! So its great having subcategory's to add links into,
but if they don't explode on view the user knows no different and then adds to the primary category container. Personally I think this is a minor problem with indexu, that could do with fixing, unless their is a better/alternative way of displaying category's to the user)

I have come to the conclusion that this way would work better anyways.

So

After looking at the database structure "idx_category" all the "parent_id" (i think) should be value = 0

and "idx_category_path" all the parents should be ;0;

Is this correct and how can I tackle this now I have phpadmin up and running?

Thanks again (sorry for the rant)

[Bruceper]

Slow down there.. if you're having issues with users trying to submit to categories they aren't allowed to, then why not upgrade to the SVN version and make the disallowed categories not visable?

Anyways, if the parent ID is 0 then it will become a top level category.

Remember when I told you about mysql commands? This could have been done easily via the IndexU admin panel in the Find - Replace box.

Select Table idx_category
select field parent_id
find what cat#
replace with 0

Since each category has a unique number this will not overwrite anything except for the one cateogry.

Do NOT change idx_category-path manually. Simply update category paths from the admin panel.

Perhaps in the future you should explain what you want to do, because there are usually ways to do it without getting too involved

[echo@]

I knew you were going the say that. lol

I am running on the latest SVN version, and I set the "permission" value for the category to "Not allowed (invisible in add/modify listing)" but this affects the subcategory's within the category in question and hides them too.

Its hard to understand but originally what i wanted was

FORD = main category = not allowed
FOCUS = subcategory = allowed

FORD/FOCUS
DODGE/VIPER

etc,


So i did try that, Im going to try what you said now

thanks!

[echo@]

I see, thanks

I now understand, a great feature.

Is there a command or a wild card for the value "find what" to replace anything higher than 0, like *.*?

I tried cat# but that returned (updated records : 0).???

[Bruceper]

Nope, because that would be too dangerous with possible mistakes.

[echo@]

Ok

I can manage now thks!

[echo@]

The IMAGE custom field does not display anymore

Are paths to the category images wrong (i guess) after reorganizing the category's in find and replace.

how do you amend this bruce?

[Bruceper]

If the custom field doesn't display then you've removed it from the code. Otherwise it should still try and display an image, even if it was an incorrect image.