Page 1 of 1

Portal Login Retreval

PostPosted: Sat Nov 29, 2008 12:25 pm
by kolucoms6
My technical guy provided with me Root Password but Didn't provide me with the Portal Admin password and gave me one Local admin but with Restriction.

How to Retrieve ADMIN password ?

PostPosted: Sun Nov 30, 2008 9:46 am
by kolucoms6
Anyway to do it ?

PostPosted: Sun Nov 30, 2008 12:04 pm
by williamconley
honestly, password crack requests are frowned upon. especially posting them. i could give you offline advice if i could verify your ownership of the box (although having the root password is compelling, it's not final).

PostPosted: Fri Dec 05, 2008 11:31 am
by kolucoms6
How to open mysql database from webmin and view table data and content ?

PostPosted: Sat Dec 06, 2008 11:29 am
by williamconley
um .. click on mysql in webmin under servers, then click on the asterisk database ...
then choose the appropriate table and click on "view data"

PostPosted: Sat Dec 06, 2008 12:03 pm
by kolucoms6
When i click on Mysql, it says :

SQL show index from `recording_log` failed : Table './asterisk/recording_log' is marked as crashed and should be repaired

PostPosted: Sat Dec 06, 2008 12:05 pm
by kolucoms6
If I run this command, it will resolve all database problems ?

mysqlcheck --auto-repair asterisk -p

PostPosted: Sat Dec 06, 2008 12:14 pm
by williamconley
it is likely, and it will not hurt.

make sure noone is using the system when you do it.

you may need to run the command more than once.

you may need to add the actual table to be repaired as well. (this one is for the entire database)

PostPosted: Sat Dec 06, 2008 12:20 pm
by kolucoms6
So, command would be

mysqlcheck --auto-repair asterisk recording_log -p

Correct ?

PostPosted: Sun Dec 07, 2008 1:41 am
by williamconley
kolucoms6 wrote:mysqlcheck --auto-repair asterisk recording_log -p


if that (recording_log) is the name of your defective table, yes

PostPosted: Mon Dec 08, 2008 2:47 pm
by kolucoms6

vicidialnow*CLI>
You have new mail in /var/spool/mail/root
[root@vicidialnow ~]# mysqlcheck --auto-repair asterisk recording_log -p
Enter password:
mysqlcheck: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect
You have new mail in /var/spool/mail/root
[root@vicidialnow ~]# mysqlcheck --auto-repair asterisk recording_log -p
Enter password:
mysqlcheck: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect
[root@vicidialnow ~]# mysqlcheck --auto-repair asterisk recording_log -p
Enter password:
mysqlcheck: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect
[root@vicidialnow ~]#




What password do I need to enter over here ? Root password ?

PostPosted: Mon Dec 08, 2008 10:43 pm
by williamconley
do you know the root mysql password for your installation? this is where you would put it. Check your documentation. Especially if you don't know what it is, it is likely to still be the password generated or installed by the system.

PostPosted: Tue Dec 09, 2008 2:37 am
by kolucoms6
I can change Mysql password from webmin but is there any default ?

PostPosted: Tue Dec 09, 2008 11:47 pm
by williamconley
if you can change the ROOT mysql password, do so. it is not to be used to perform database tasks, only for administrator "master access".

never use root mysql to perform any tasks (except for this) and never give your root mysql password to anyone you do not trust.

all other mysql accounts/users should be limited in what they can do and on what database, generally to a single database and only used for the program accessing that data.

when and where to set each account and password is listed in the scratch install for vicidial, you can change the password and even the account name, but if you do so you must be sure it is changed in both mysql AND in the vicidial configuration files.

PostPosted: Fri Apr 03, 2009 12:43 am
by daaliya
Can i Run a VOIP router with a wireless router from same computer?
I have a Lingo Router, and i wanna hook my Playstation 3 via Wi-Fi. So i bought a Wireless G router, however it doesnt support VOIP. So i was wondering can i hook both of them up some how?? or are there special wireless routers that supporot VOIP?