13 Pro
2012
13 Pro
'12
17:57
Due to the augmented abilities of FRED 2.11, I've attempted to migrate the production
database, which runs FRED 2.2, to the FRED 2.11 format, running in a test server running
the later. For the DB migration, I've run the SQL scripts, one by one, until it
supposedly has the 2.11 structure. I've not run the script for having the initial
structure, but a) firstly I migrate the complete DB from the production server to the test
server and B) run the appropiate SQL scripts from 2.2 to 2.11.
The result when I try to run fred-client:
root@fredbeta:~# fred-client
Unsupported language code: 'es' in os.environ.LANG. Available codes are: cs, en.
Set default to: 'en'.
FredClient 2.4.1
Type "help", "license" or "credits" for more information.
Using configuration from /usr/etc/fred/fred-client.conf
Connecting to 127.0.0.1, port 700 ...
ERROR: Login failed
The fred-eppd.log file:
[13/Dec/2012:10:45:24 --0600] 127.0.0.1 (process:17973) [sessionID 512160] fred-logd
createRequest logging error: IDL:ccReg/Logger/INTERNAL_SERVER_ERROR:1.0
[13/Dec/2012:10:45:24 --0600] 127.0.0.1 (process:17973) [sessionID 512160] Error while
logging the request
[13/Dec/2012:10:45:24 --0600] 127.0.0.1 (process:17973) [sessionID 512160] Created session
in fred-logd with id: 68462
[13/Dec/2012:10:45:24 --0600] 127.0.0.1 (process:17973) [sessionID 512160] using fred-logd
session id: 68462
[13/Dec/2012:10:45:24 --0600] 127.0.0.1 (process:17973) [sessionID 512160] Client
disconnected without proper logout.
[13/Dec/2012:10:45:24 --0600] 127.0.0.1 (process:17973) [sessionID 512160] Session ended
The fred.log file:
[2012-Dec-13 10:45:24] [fred-server] [error] [logd-<30156468>/session-0] --
Result failed: INSERT INTO request (time_begin, time_end, source_ip, user_name,
user_id, service_id, request_type_id, session_id, is_monitoring, result_code_id
) VALUES ('2012-12-13 16:45:24.018801', NULL, E'127.0.0.1', NULL, NULL, 3,
100,
NULL, 'f', NULL) (ERROR: column "service" does not exist
<------------------------------
CONTEXT: SQL statement "CREATE TABLE request_epp_12_12 (CHECK (time_begin >=
TIMESTAMP '2012-12-01 00:00:00' AND time_begin < TIMESTAMP '2013-01-01
00:00:00
' AND service = 3 AND is_monitoring = 'f') ) INHERITS (request)"
PL/pgSQL function "create_tbl_request" line 31 at EXECUTE statement
<-----------------------
SQL statement "SELECT create_tbl_request(time_begin, service_id,
is_monitoring)"
PL/pgSQL function "tr_request" line 26 at PERFORM
The are apparent problems when creating the auxiliary
request_epp_<year>_<month> table it seems.
Best regards.
--
Mario Guerra <mguerra(a)nic.cr>
13 Pro
13 Pro
18:27
The are apparent problems when creating the auxiliary
request_epp_<year>_<month> table it seems.
Hello Mario
I can't tell you right now from which to which version we migrated our
FRED installation, but about a year ago we've chosen the newest. In
general: it works.
AFAIR I've tuned the migration procedure slightly to have the logging
tables log_year_month created just before the month begins.
The reason for that is that we've scripted and croned adding them to
replication set as well. And to improve the performance we only
replicate current month.
I may try looking for the patches if you'd be interested although they
may not satisfy your needs.
Best
Piotr
14 Pro
14 Pro
6:45
Mario,
I have migrated from Fred 2.1 to 2.11 successfuly , I had to tune the migration scripts as
I realised some errors if you do not tune them.I have attached a text file with the notes
I took when i was upgrading i am not sure if it will help much.If I was facing that
problem i would go back to the upgrade script and look for the sql statement that update
that particular table and see why it is not working and tune it to make it work the way it
is required as I am sure once you tune the script to add the column service the error will
disappear.
One problem i face is when i was upgrading the invoice table and other related credit
tables to the new one it did not work because what happens is that the scripts generate
the text file from the table,delete the tables and then create new table upload from the
text file,now if the user does not have enough permission to do that you will fail.I know
this is not your problem but just incase you suffer such a problem.
Finally I can just say the upgrade works after some tuning!
On Dec 13, 2012, at 7:57 PM, Mario Guerra <mguerra(a)nic.cr> wrote:
The fred-eppd.log file:
6:59
Mario,
Another thing that I faced and it was seriously affecting my upgrade is the scripts that
create a temporary tables.Apparently all the scripts that was supposed to create temporary
tables did not work I could not create temp tables instead I had to create normal table
that starts with tmp so that I could identify them and delete once the upgrade is
done.This was so serious that I could not proceed without finding a solution for it.I know
this may be it was my problem only but you can check to see if you have same problems.
Find the attached notes i took.
Regards,
Bryton
On Dec 14, 2012, at 8:45 AM, Bryton Focus <bfocus(a)tznic.or.tz> wrote:
Mario,
I have migrated from Fred 2.1 to 2.11 successfuly , I had to tune the migration scripts
as I realised some errors if you do not tune them.I have attached a text file with the
notes I took when i was upgrading i am not sure if it will help much.If I was facing that
problem i would go back to the upgrade script and look for the sql statement that update
that particular table and see why it is not working and tune it to make it work the way it
is required as I am sure once you tune the script to add the column service the error will
disappear.
One problem i face is when i was upgrading the invoice table and other related credit
tables to the new one it did not work because what happens is that the scripts generate
the text file from the table,delete the tables and then create new table upload from the
text file,now if the user does not have enough permission to do that you will fail.I know
this is not your problem but just incase you suffer such a problem.
Finally I can just say the upgrade works after some tuning!
On Dec 13, 2012, at 7:57 PM, Mario Guerra <mguerra(a)nic.cr> wrote:
The fred-eppd.log file:
_______________________________________________
fred-users mailing list
fred-users(a)lists.nic.cz
https://lists.nic.cz/cgi-bin/mailman/listinfo/fred-users
17 Pro
17 Pro
18:03
On Fri, 14 Dec 2012 08:59:35 +0300
Bryton Focus <bfocus(a)tznic.or.tz> wrote:
Mario,
Another thing that I faced and it was seriously affecting my upgrade is the scripts that
create a temporary tables.Apparently all the scripts that was supposed to create temporary
tables did not work I could not create temp tables instead I had to create normal table
that starts with tmp so that I could identify them and delete once the upgrade is
done.This was so serious that I could not proceed without finding a solution for it.I know
this may be it was my problem only but you can check to see if you have same problems.
Exactly my problem. By far, the main problem. I'm going to study very closely each SQL
from 2.2 up to 2.11, especially the temporal tables are created.
Thanks for all your help.
Best.
--
Mario Guerra <mguerra(a)nic.cr>
4387
days inactive
4391
days old
4 comments
3 participants
participants (3)
-
Bryton Focus -
Mario Guerra -
Piotr Przybył