FreeBSD ?

[joximu]

Is there another user who has all privileges? Debian has one...
or maybe you can try to connect from outside (first activate access from extern) and tray the root@yourhost.domain.tld...

You cannot change the table mysql.user when starting with --skip-grand-tables?

/J

[StevenE]

hi,

I started again with new mysql installation :S
and now I'm sure that the installation changes the PRIVILEGES
I created a dbuser omega with all privileges, after ispcp-setup, where I give omega as SQL user, omega has only Usage instead of all privileges....

and ispcp-setup failed with

Code:

ERROR: External command '/usr/local/bin/mysql --host=localhost --user=omega --pass=admin < /tmp/db.sql 1>/tmp/db.sql.stdout 2>/tmp/db.sql.stderr' returned '1' status !

db.sql.stderr sais:

Code:

ERROR 1044 (42000) at line 1: Access denied for user 'omega'@'localhost' to database 'ispcp'

the installation overwrite the rights of omega everytime so here's at the moment no way out for me...
whats to do?


edit: I use the current nightly one

[joximu]

you *can* give ispcp an own mysql user (I do this also) but this needs to be a user with the same privileges as the root user becaus it needs to create databases and users.

I installed the r1043 tonight and this runs well. Ok, it's on debian, but I don't think that this is the reason.

/J

Upd: maybe you can post the table mysql.user before and after the installation

[StevenE]

I created the user omega with ALL_PRIVILEGES after Installation its only Usage
so the error occurs during the installation I think.

A short look at ispcp-setup didn't get me any hint
Sorry don't know where the error could be, I'm not so well with scripting

[joximu]

Really strange - there is no code in the setup which changes this.
Only the pma and vftpd users are created and "granted" - you did not mix theese users?

[StevenE]

don't know why but now it seems working only few files are not copied well....

[StevenE]

so whyever DB works, was my mistake
but now, how could it be otherwise, some new probs occurs

Code:

ERROR: Can't open file |/usr/local/etc/ispcp/cron.d/backup/ispcp| for writing: No such file or directory

Code:

cp: directory /etc/cron.d does not exist

Code:

cp: /usr/local/etc/ispcp/cron.d/working/ispcp: No such file or directory

these 3 above seems not well copied from the routine, or am I wrong?

Code:

/usr/local/etc/named.rc: not found
cp: /usr/local/etc/ispcp/bind/backup/named.conf.ispcp: No such file or directory
ERROR: External command '/bin/cp -p /usr/local/etc/ispcp/bind/backup/named.conf.ispcp /etc/namedb/named.conf' returned '1' status !

Code:

cp: /etc/namedb/named.conf: No such file or directory
ERROR: External command '/bin/cp -p /usr/local/etc/ispcp/bind/backup/named.conf.ispcp /etc/namedb/named.conf' returned '1' status !

ok my fault haven't installed any nameserver before, thes should fit with excisting nameserver I think

Code:

ERROR: File '/usr/local/etc/ispcp/apache/working/fastcgi_ispcp.conf' does not exist !

my path is /usr/local/etc/ispcp/apache22/working/fastcgi_ispcp.conf

Code:

ERROR: File '/usr/local/etc/ispcp/apache/01_awstats.conf' does not exist !

don't exist in my path anyway...


after that an error occurs becaus of my slopy troubleshooting so never mind. but perhaps we can solve together things above...

[StevenE]

tried it once again....
I belive it hates me really hard

Ok... I loaded the current nightly.

Code:

make -f BSDMakefile

works fine as allways

but now first question why you changed path from

/usr/local/www/apache22/ispcp/
to
/usr/local/www/ispcp/

this only catches more difficultes....
so I move it back to old path.

I started then...

Code:

./ispcp-setup

several errors occur

here how I solved them

Code:

mv /usr/local/www/ispcp /usr/local/www/apache22/

ln -s /usr/local/etc/ispcp/ /etc/ispcp

cp /omega/engine/setup/ispcp-setup-methods.pl /usr/local/www/apache22/ispcp/engine/setup/

cp -Rp /omega/configs/dists/freebsd/cron.d /usr/local/etc/ispcp/cron.d

mkdir /usr/local/www/apache22/fcgi/master

mkdir /etc/cron.d

cp /omega/configs/dists/freebsd/bind/named.rc /usr/local/etc/ && chmod 777 /usr/local/etc/named.rc

touch /usr/local/etc/ispcp/bind/backup/named.conf.ispcp

mkdir /etc/namedb

ln -s /usr/local/etc/ispcp/apache22 /usr/local/etc/ispcp/apache

cp /omega/configs/dists/freebsd/apache/01_awstats.conf  usr/local/etc/ispcp/apache/

but now I stuck no idea whats going wrong here, but looks familiar to the other current new topic "Installation problem on CentOS 5.1"

Code:

ERROR: Undefined intput data, bt: |// bind Data BEGIN.
|, et: |// bind Data END.
|, src !

Greetz Steve

edit: this is the tail of ispcp-setup with debug

Code:

DEBUG: push_el() sub_name: get_tag(), msg: Starting...
DEBUG: push_el() sub_name: get_tag(), msg: Ending...
DEBUG: push_el() sub_name: get_tag(), msg: Starting...
DEBUG: push_el() sub_name: get_tag(), msg: ERROR: '// dmn [admin.ispman.cbt-l.de] cfg entry BEGIN.
' ne '// dmn [admin.ispman.cbt-l.de] cfg entry END.
', '// dmn [admin.ispman.cbt-l.de] cfg entry BEGIN.
' or '// dmn [admin.ispman.cbt-l.de] cfg entry END.
' missing in src !
DEBUG: push_el() sub_name: get_tag(), msg: Starting...
DEBUG: push_el() sub_name: get_tag(), msg: Ending...
DEBUG: push_el() sub_name: repl_tag(), msg: Starting...
DEBUG: push_el() sub_name: get_tag(), msg: Starting...
DEBUG: push_el() sub_name: get_tag(), msg: Ending...
DEBUG: push_el() sub_name: repl_tag(), msg: Ending...
DEBUG: push_el() sub_name: sys_command(), msg: Starting...
DEBUG: push_el() sub_name: sys_command('cp -p /etc/namedb/named.conf /usr/local/etc/ispcp/bind/backup/named.conf.1205332667'), msg: Ending...
DEBUG: push_el() sub_name: store_file(), msg: Starting...
DEBUG: push_el() sub_name: setfmode(), msg: Starting...
DEBUG: push_el() sub_name: setfmode(), msg: Ending...
DEBUG: push_el() sub_name: store_file(), msg: Ending...
DEBUG: push_el() sub_name: get_tag(), msg: Starting...
DEBUG: push_el() sub_name: get_tag(), msg: ERROR: Undefined intput data, bt: |// bind Data BEGIN.
|, et: |// bind Data END.
|, src !
DEBUG: pop_el() sub_name: get_tag(), msg: ERROR: Undefined intput data, bt: |// bind Data BEGIN.
|, et: |// bind Data END.
|, src !
ERROR: Undefined intput data, bt: |// bind Data BEGIN.
|, et: |// bind Data END.
|, src !

[RatS]

seems to be a bind defect. Please copy the bind-files from Debian into your ispcp/bind/ directory and retry

[StevenE]

ok that do it so long, but its not the last error at all, if there is one I can't terminate I will post again.

thanks a lot