Topic: Why is this so hard to figure out!!??!!

[Kronus]

I know I'm a complete newb to linux but this is rediculous!! I have a nice server up and running (phptriad) but the tower is dieing and all I want to do is transfer the existing website/database to a linux based server....stability is the main goal and without the windows OS it has nothing to clog it down. I have sme 6.5 up and running on a brand new box with decent ram and a 1.4 ghz amd. (yes i posted this before) I can get upgrades working like the control pannel and I have installed PHPmyadmin...I have even learned how to manuver via Putty and now undestand the concept of SSh....but PHPmyadmin will not let me creat tables or even use the backup I have to just restore the database I need....I even tried DBTools pro but that cannot even connect to the mysql server....I really though SME would be the way to go but it is just too complicated for newbs like me.

I tried the trial of NITIX server which is the same concept as SME. With NITIX I can connect to the mysql server with DBTools pro but cannot install PHPMyAdmin and there is a heafty $600.00 + price tag. I just can't seem to win and will have to give up and go back to easy to use and easy to crash windows......At least if no one here can help me figure out what I am missing with SME....

[raem]

Kronus

Try using 6.0 + updates or 6.0.1, phpmyadmin works fine on those final releases.
Note that 6.5RC1 is not a final relase and perhaps there is some "issue" with phpmyadmin that is still to be resolved ??

[jackl]

Kronus,
Have you tried:
/sbin/e-smith/config setprop mysqld LocalNetworkingOnly no
/sbin/e-smith/expand-template /etc/my.cnf
/etc/rc.d/init.d/mysqld restart

Regards
Jack

[Kronus]

Kronus

Try using 6.0 + updates or 6.0.1, phpmyadmin works fine on those final releases.
Note that 6.5RC1 is not a final relase and perhaps there is some "issue" with phpmyadmin that is still to be resolved ??

I will try this and see if it helps.

[Kronus]

Kronus,
Have you tried:
/sbin/e-smith/config setprop mysqld LocalNetworkingOnly no
/sbin/e-smith/expand-template /etc/my.cnf
/etc/rc.d/init.d/mysqld restart

Regards
Jack

Yes and no I saw similar comands for trying to use dbmanagerpro and all I got back was BASH errors
going to try this now and see if it works before I install the earlier version

[Kronus]

ok well that doesn't seem to be working so I guess I'll download the earlier version and see how that works

[boss_hog]

Hey Kronus,
did you use the rpm for phpmyadmin?
I use SME 6.5rc1 with e-smith-phpmyadmin-2.6.0-12.noarch.rpm
Works fine. Get it here:
http://mirror.contribs.org/smeserver/contribs/nightspirit/e-smith-phpmyadmin/
Good Luck
Joe

[Kronus]

Hey Kronus,
did you use the rpm for phpmyadmin?
I use SME 6.5rc1 with e-smith-phpmyadmin-2.6.0-12.noarch.rpm
Works fine. Get it here:
http://mirror.contribs.org/smeserver/contribs/nightspirit/e-smith-phpmyadmin/
Good Luck
Joe

That was one of the first things I tried to do...
I have an earlier post talking about some of this and why it took me so long to get it done.

Anyways I was able to install PhpMyAdmin very quickly but it would not let me creat tables or restore previously backed up databases. It simply gave me error code on line 1 of your mysql or something to that effect.....

[boss_hog]

Hey Kronus,
after the first "bad" install of phpmyadmin, did you delete the pmadb database? It seems, in my experience, if you don't remove that one db, you can't re-install phpmyadmin properly.

You can remove databases quite easily from the command line.

Also did you restart the server:
/etc/rc.d/init.d/httpd-e-smith restart
and - or
/etc/rc.d/init.d/httpd graceful
after installing phpmyadmin?

Hope this helps
Joe

[jackl]

Kronus,
What account did you use to connect to mysql when using DBTools?
Just a point of information the system root and the mysql root users have different passwords.
SME is easy to use with Mysql databases I just think we are overlooking something simple here.
If you have created a new mysql account what error do you get when trying to connect using DBTools to Mysql?

Regards
Jack

[Kronus]

Kronus,
What account did you use to connect to mysql when using DBTools?
Just a point of information the system root and the mysql root users have different passwords.
SME is easy to use with Mysql databases I just think we are overlooking something simple here.
If you have created a new mysql account what error do you get when trying to connect using DBTools to Mysql?

Regards
Jack

I get this on phpmyadmin #1064 - You have an error in your SQL syntax near '' at line 1

and access denied for user: 'sam@pc-00001localhost (using password: YES)

[Kronus]

I did creat a new user to see if it was just a problem with using root or admin accounts....

[jackl]

Kronus,
Try this at command line:
grep LocalNetwork /home/e-smith/configuration

It should return:
mysqld=service|LocalNetworkingOnly|no|status|enabled

If you don't get exactly like this, post the result.

Regards
Jack.

[Kronus]

Kronus,
Try this at command line:
grep LocalNetwork /home/e-smith/configuration

It should return:
mysqld=service|LocalNetworkingOnly|no|status|enabled

If you don't get exactly like this, post the result.

Regards
Jack.

Yes that worked fine but I still get the error in dbtools of access being denied and the phpmyadmin error....I just saw someone else posting the same error on the forums this morning

[psdata]

Hello all,

I think you must at the first try to reset the root password for Mysql.

You do this whith the following command:

Code: [Select]


[root@e-smith /root] # /etc/rc.d/init.d/mysqld stop
[root@e-smith /root] /etc/esmith/events/actions/conf-mysql-password
[root@e-smith /root] # /etc/rc.d/init.d/mysqld start



I think that then the phpmyadmin is funktion again but you can also do to make a extra mananging account for you databases whit use off external tools.
 

Code: [Select]


grant all privileges on *.* to mysqladmin@'%' identified by 'password';
grant all privileges on *.* to mysqladmin@localhost identified by 'password';
flush privileges;


Now you have made a new user whith (mysaladmin) whith all right on all databases from only local are remote station. You can also change mysqladmin@'%' whith mysqladmin@pc00xx. so only your station can run a admin tool.

Regards

John

[Kronus]

   
THANK YOU THANK YOU THANK YOU!!!!!!!!!!!!!!!!!!!



It now works and so much faster than that old windows box......I really can't thank you enough.....