mysql, can't connect to db

[carpman]

Hello, ok have ehcp installed on a dev ubuntu server via vmware server.

This just a local install to test things, the install seems to have gone well, second attempt but having issue connecting to db via php install script for test domain setup.

I can connect via phpmyadmin fine, i added the db and user at same time via CP but that user is not listed


All mysql db's:
:
domainname dbname host
test.com test1 localhost
Record Count:1



All mysql db users:
:
domainname dbname dbusername host
test.com test1 dbuser localhost
Record Count:1


the dbusername should be 'test' and have tried adding this again?

If i click on the edit icon for db in second entry i get error.


Some Error Occured.
This db user is not your user..


I have tried root user and password as well but no joy!

any ideas what i have missed?

cheers

[bvidinli]

i checked for dbuser edit error, (This db user is not your user.)
it seems a bug of ehcp, i will fix and release the fix with next minor version.


I think you should not use the name "test" for dbuser,
since it may get confused by mysql's self test db's and accounts.
use something else.


What you can do now:
to fix above error: try to delete the db. that deletes the related dbuser too.
if that does not succeeds, you may delete rows/users from phpmyadmin, ehcp db and mysql db.
I am sory for now, but this is what I can think now.

see you.

[carpman]

i checked for dbuser edit error, (This db user is not your user.)
it seems a bug of ehcp, i will fix and release the fix with next minor version.


I think you should not use the name "test" for dbuser,
since it may get confused by mysql's self test db's and accounts.
use something else.


What you can do now:
to fix above error: try to delete the db. that deletes the related dbuser too.
if that does not succeeds, you may delete rows/users from phpmyadmin, ehcp db and mysql db.
I am sory for now, but this is what I can think now.

see you.


Thanks for reply, the user is not actually 'test' i just made that up for post. The actual user name is 'dbuser' i have also tried adding other name as well but to no avail.

i will try removing the the db and all users.

[bvidinli]

i fixed that error,
and uploaded new testing version to www.ehcp.net/ehcp_yeni.tgz
download and try and let me know the result..

[carpman]

i fixed that error,
and uploaded new testing version to www.ehcp.net/ehcp_yeni.tgz
download and try and let me know the result..


ok will try that sunday as busy until then.

cheers

[carpman]

i fixed that error,
and uploaded new testing version to www.ehcp.net/ehcp_yeni.tgz
download and try and let me know the result..


Ok downloaded that file and tried upgrade, well guessed at upgrade procedure but had not joy?


i ran sh ehcp_upgrade.sh this downloaded some file and asked for password but when given failed.

-2009-07-21 14:12:16-- http://www.ehcp.net/download/ehcpupgrade.sql
Resolving www.ehcp.net... 85.98.13.196
Connecting to www.ehcp.net|85.98.13.196|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 508 [text/plain]
Saving to: `ehcpupgrade.sql.1'

100%[================================================== ================================================== ==>] 508 --.-K/s in 0s

2009-07-21 14:12:17 (36.8 MB/s) - `ehcpupgrade.sql.1' saved [508/508]

Enter password:
ERROR 1045 (28000): Access denied for user 'ehcp'@'localhost' (using password: YES)
cp: cannot stat `ehcp.bck.Tue': No such file or directory
cp: cannot stat `Jul': No such file or directory
cp: cannot stat `21': No such file or directory
cp: cannot stat `14:12:09': No such file or directory
cp: cannot stat `BST': No such file or directory
cp: cannot stat `2009/config.php': No such file or directory
upgrade finished.
Reading package lists... Done
Building dependency tree
Reading state information... Done
webalizer is already the newest version.
php5-curl is already the newest version.
php5-xmlrpc is already the newest version.
php-pear is already the newest version.
0 upgraded, 0 newly installed, 0 to remove and 16 not upgraded.


After thought i would just try an install but after running sh install.sh
i got

sh install.sh


Please Wait... initializing.a If something is very slow, please report on our site.


install.sh: 21: Syntax error: "(" unexpected
root@devserver:/home/sysadmin/install/ehcp# sh install.sh


Please Wait... initializing.a If something is very slow, please report on our site.


install.sh: 21: Syntax error: "(" unexpected



cheers

[bvidinli]

do not use upgrade.sh utility for installing from scratch.
initialize a new vps,
then, redownload www.ehcp.net/ehcp_yeni.tgz
then,
start install.sh
i checked install.sh, it is ok.

see you,

[carpman]

do not use upgrade.sh utility for installing from scratch.
initialize a new vps,
then, redownload www.ehcp.net/ehcp_yeni.tgz
then,
start install.sh
i checked install.sh, it is ok.

see you,

you mean i need to a complete reinstall?

[bvidinli]

another way:
just put/copy/overwrite files in new package to /var/www/vhosts/ehcp
except config.php,

then, use your ehcp normally.

upgrade script is normally used to upgrade almost major versions (from versions prior to 0.27 -> latest ehcp)

if you have previously 0.27,0.28,0.29 (you had in this case 0.29.09 i think)
you dont need to run upgrade.sh
even you did upgrade, above method of copying files should work.

if it does not work, I suggest to do a full reinstall (including ubuntu and ehcp)

Thank you for your bug report, I managed to fix it, will be released to public soon (ehcp_yeni.tgz file). Actually anybody can download now, I just did not announce in homepage of ehcp.net