+- ispCP - Board - Support (http://www.isp-control.net/forum)
+-- Forum: ispCP Omega Support Area (/forum-30.html)
+--- Forum: System Setup & Installation (/forum-32.html)
+--- Thread: FreeBSD ? (/thread-2409.html)
RE: FreeBSD ? - joximu - 03-08-2008 02:46 AM
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
RE: FreeBSD ? - StevenE - 03-10-2008 10:30 PM
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
RE: FreeBSD ? - joximu - 03-10-2008 10:39 PM
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
RE: FreeBSD ? - StevenE - 03-10-2008 10:46 PM
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
RE: FreeBSD ? - joximu - 03-10-2008 11:06 PM
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?
RE: FreeBSD ? - StevenE - 03-10-2008 11:06 PM
don't know why but now it seems working only few files are not copied well....
RE: FreeBSD ? - StevenE - 03-10-2008 11:31 PM
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 directoryCode:
cp: directory /etc/cron.d does not existCode:
cp: /usr/local/etc/ispcp/cron.d/working/ispcp: No such file or directorythese 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...
RE: FreeBSD ? - StevenE - 03-13-2008 12:27 AM
tried it once again....
I belive it hates me really hard
Ok... I loaded the current nightly.
Code:
make -f BSDMakefilebut 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-setuphere 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 !RE: FreeBSD ? - RatS - 03-13-2008 02:06 AM
seems to be a bind defect. Please copy the bind-files from Debian into your ispcp/bind/ directory and retry
RE: FreeBSD ? - StevenE - 03-13-2008 02:19 AM
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