atomic-psa not able to create PSA database

[jnoble]

Hello, Had a problem installing psa today,

This post will be updated as I progress, but feel free to make any comments

-----

Centos 5, fresh install, first commands I ran:

Code: Select all

    1  wget http://www.atomicrocketturtle.com/RPM-GPG-KEY.art.txt
    2  rpm --import RPM-GPG-KEY.art.txt
    3  lynx -source http://www.atomicorp.com/installers/atomic.sh | sh
    4  wget -q -O - http://www.atomicorp.com/installers/atomic.sh | sh
    5  yum install -y atomic-psa

in my log file:
psa_8.3.0_cos5.build83071218.19_installing.080709.05.47.log
I get this.

Code: Select all

Starting MySQL:  [  OK  ]
mysqld (pid 4878) is running...
 Trying to define valid mysql credentials...  Trying to establish test connection... ERROR 1045 (28000): Access denied for user 'admin'@'localhost' (using password: YES)
 Trying to establish test connection... connected
done
mysqld (pid 4878) is running...
 Trying to establish test connection... connected
done
 Trying to check psa database...  Trying to find psa database... Mysql exited with non-zero status 11 at -e line 27.
ERROR 1049 (42000): Unknown database 'psa'
not found
Mysql exited with non-zero status 11 at -e line 27.
ERROR 1049 (42000): Unknown database 'psa'
 Trying to install initial Plesk database... ERROR 1064 (42000) at line 2: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '------------------------------------------------------------------------

I located the file /usr/local/psa/etc/db/psa_db.sql

this appears to be the base of database.

Tried importing it directly:

Code: Select all

mysql -uadmin -p`cat /etc/psa/.psa.shadow` < /usr/local/ps                                      a/etc/db/psa_db.sql

No luck:

Code: Select all

ERROR 1064 (42000) at line 2: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '------------------------------------------------------------------------

(still working on this, will post more after checking the mysqlsite)
[/code]

[jnoble]

Ok, seems the ------- lines are the problem

copied the psa_db.sql to a working directory and ran :

Code: Select all

sed 's/\-\-/##/g' psa_db.sql > psa_db.sql2

then:

Code: Select all

 mysql -uadmin -p`cat /etc/psa/.psa.shadow` < psa_db.sql2

that worked.

just to see what happens, I ran:

Code: Select all

    yum -y remove psa
     yum -y install psa

result is not quite good enough:

Code: Select all

----------------------------
END OF INNODB MONITOR OUTPUT
============================

DATABASE ERROR!!!
Database psa found, but version undefined

ERROR while trying to find psa database

Aborting...

Back to the mysql site.

[faris]

There's an Parallels KB entry on the --- issue. They suggest downgrading to a previous version of mysql before installing.

I suspect something might have got broken when you manually loaded the sql data?

[jnoble]

I should mention that I have reinstalled the server several times. Ill try downgrading mysql next.